Export JD Edwards EnterpriseOne Items to Oracle CX Sales

Use this topic to export JD Edwards EnterpriseOne items to Oracle CX Sales.

For additional information about the Item Batch Outbound program (R4101ZO) used to create the item XML file, see the Item Master chapter in the JD Edwards EnterpriseOne Applications Business Interface Implementation Guide. You can access this guide on the Cross-Product tab of the JD Edwards EnterpriseOne Applications Documentation Library, located at: http://docs.oracle.com/cd/E16582_01/index.htm.

To import JD Edwards EnterpriseOne items do the following:

1. Export JD Edwards items using the batch process by submitting Item Batch Outbound program (R4101ZO).

   When you submit Item Batch Outbound program (R4101ZO) for exporting items into XML, the printer selection window appears.

   In the printer selection window, then click the Document Setup tab, and click the OSA Interface Name check box, and enter XMLPOSA in the text box beneath the check box.

2. Submit the batch and review the submitted jobs.

   After the job is completed, a status of Done is displayed.

3. Select a row, then from the Row menu, select View OSA.

4. Use the included processing script to prepare the XML file.

   Note: Of the two included scripts, use the script appropriate to your operating system.Refer to the Related Topics section in this topic for a link to integration implementation files (Doc ID 1645923.1) on My Oracle Support.

   • Linux: prepareImportItems.sh

   • Windows: prepareImportItems.ps1

5. Right-click PowerShell and select Run as administrator.

6. Execute the command: Get-ExecutionPolicy.

   If the returned value is Restricted, you will receive an error. In this case, note the current value, and execute the command: Set-ExecutionPolicy RemoteSigned.

7. From the \batch_scripts folder, run the following script to retrieve the necessary XML file:

   • Windows:

     .\prepareImportItems.ps1 .\<jde items xml file> <OSC Jde Catalog Reference Number>

   • Linux:

     sh prepareImportItems.sh <jde items xml file> <OSC Jde Catalog Reference Number>

8. Re-institute the execution policy as: Set-ExecutionPolicy Restricted.

   A new XML file is created: impost_<XML_filename>.