• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Setting Up JDE Flat File Cross Reference (P47002) to run R47002C

Wheeler

Active Member
Hello Everyone,

I am trying to get information on how to set up the Flat File Cross-Reference (P47002) to pick up an 850 Flat File in JD Edwards. .I have currently set up: \\CLARK\Root\edipickup\flatfile01.txt in the Flat File Cross-Reference. I have set up "edipickup" in the root directory and placed the flat file "flatfile01.txt" in that file. However, when I run the program R47002C, I am getting the error message" Error: Open of file Unsuccessful. One ore more of the master files required for the execution of this program..."


If anyone has set this up so that they can successfully pick up the flat file from the IFS running the program R47002C I would appreciate any tips. We are currently on the iSeries. The steps I have taken are as follows: 1) mapped a network drive to the IFS pointing to the folder containing the flat file 2) Populated P47002 Flat File Cross-Reference for the Inbound 850 document with the information \\server name\Root\folder name\flat file name.txt.

I know that there is something that I am missing - the Oracle documentation has been only minimally useful to me so far. Hopefully someone on this forum can help me.
 

Aarto

Reputable Poster
Hi! This is the format we use to define the file location, also on iSeries
/PD910/INBOUNDFORECAST/JDEFC.csv

We tried to use UNC but gave up.. You need to understand that when You run R47002C, it does not use the user-ID of the user running the UBE when accessing file system but uses the "system user" ID, usually "JDE" so it is the system user that should have access to the network folders. We chose to place the files on the Enterprise server instead...

Hope this helps
Aarto
 
Top