Oracle Data Integrator can automatically call the RunUBE command to write to JDE. The RunUBE call should be activated in the IKM only after loading the appropriate Z-table for populating JDE. The capability to load the Z-Tables, as well as the call of the RunUBE command is provided by the IKM JDE Enterprise One Control Append (UBE).
To integrate data into JDE with Oracle Data Integrator:
Create an integration interface with Z-tables as target datastores.
Create joins, filters, and mappings as usual.
In the Flow tab select the IKM JDE Enterprise One Control Append (UBE).
Specify the KM options as follows to run the RunUBE command:
Set the JDE_RUNUBE option to Yes.
Specify the JDE_DIRECTORY in which the RunUBE command is executed.
If you want to create a password file, set the password related options as follows: JDE_CREATE_PWD_FILE: Set to Yes. Note: To enhance RunUBE security in a Unix or iSeries environment, when the RunUBE
command is submitted, the system reads the text file specified in the JDE_PWD_FILE option and uses the JD Edwards EnterpriseOne user ID and password as indicated in the text file.
JDE_PWD_FILE: Specify the absolute path of the password security file. This file contains the user id and password specified in the JDE_USER_ID and JDE_PWD options.
JDE_DELETE_PWD_FILE: Enter D to delete the password file. Enter F to keep the password file.
Note: Even if the password file is removed after the execution of the command, the file should be kept in a secure location on the file system
JDE_USER_ID: An JDE EnterpriseOne user ID. The user must have permissions to run the report.
JDE_PWD: The EnterpriseOne password that corresponds to the user ID.
You also need to specify the following parameters for the RunUBE command: JDE_ENVIRONMENT: The JDE EnterpriseOne environment JDE_ROLE: The JDE EnterpriseOne role
JDE_REPORT: The system name of the report that you want to process, such as the APS Outbound Processor (R34A400) and APS Inbound Processor (R34A410) for flat files, and the APS SCBM 2.0 Outbound Processor (R34A700) and APS Master Inbound Processor (R34A820) for XML files.
JDE_VERSION: The name of the version of the report that you want to process, such as XJDE0001. You must enter a version name; you cannot submit the template of a report.
JDE_JOB_QUEUE: The name of the job queue to which the system should route the batch job, such as QBATCH.
JDE_PROCESSING_MODE: The processing mode: Enter B to use batch processing. In this case, the system uses the Job Control Status Master table (F986110) to assign the report a place in the queue. Enter I to use the interactive mode. This mode runs the report immediately outside of the JDE EnterpriseOne queuing mechanism.
JDE_HOLD_CODE: The hold code: Enter P to send the output to a printer immediately after the job completes. Enter H to hold the processed file without printing. You can print the job later
Knowledge Modules Reference Guide