Perform Initial Import of JD Edwards EnterpriseOne Items from the XML Import File

You use the standard Oracle CX Sales Import Management process to import JD Edwards EnterpriseOne items into Oracle CX Sales product groups.

Note: This import action will import all JD Edwards EnterpriseOne items to the XML import file. In certain circumstances however, it may only add only the first item as a subgroup to the parent JDE Catalog Product Group. If this occurs after you have performed the steps in this task, perform the tasks listed in Troubleshooting the Import of All Items into the JDE Catalog Product Group.

To perform initial import of JD Edwards EnterpriseOne items from an XML import file, do the following:

1. Navigate to Setup and Maintenance.

2. Click the Tasks icon, and then click the Search link.

3. In the Search field, enter: Manage File Import Activities.

4. Click the Manage File Import Activities link.

5. In the Manage Import Activities view, click the Create icon.

6. In the Create Import Activity: Enter Import Options view, enter the information from the following table:

   Field	Value
   Name	JDE Import
   Object	Product Group
   File Type	XML
   File Selection	Specific file
   Upload From	Click the Desktop button
   File Name	Select the XML file generated by the processing script in Performing JD Edwards EnterpriseOne Item Export.

7. Click Next, then enter a new mapping using the details listed in the following table:

   Column Header	Target Object	Target Attribute
   AllowDupContentFlag	ProductGroupBulkImport	AllowDupContentFlag
   Catalog	ProductGroupBulkImport	ProdGroupDescText
   Description1_ID10	ProductGroupBulkImport	ProdGroupName
   ItemID_ID1	ProductGroupBulkImport	PgRefNumber
   ItemProduct_ID4	ProductGroupBulkImport	PgInternalName
   Language	ProductGroupBulkImport	Language
   SourceLangFlag	ProductGroupBulkImport	SourceLangFlag
   SourceObjectType	ProductGroupBulkImport	SourceObjectType
   ItemRel.RelActiveFlag	ProductGroupRelationBulkImport	ActiveFlag
   ItemRel.ItemID_ID1	ProductGroupRelationBulkImport	PgRelChildRefNumber
   ItemRel.RelLanguage	ProductGroupRelationBulkImport	Language
   ItemRel.RelSourceLangFlag	ProductGroupRelationBulkImport	SourceLangFlag
   ItemRel.RelationTypeCode	ProductGroupRelationBulkImport	RelationTypeCode

8. Click Next twice, and then click Activate.

   The process begins. To monitor progress, click Refresh.

9. Once the process shows a status of Completed, click Done.

   1. If there were errors, click the Completed with Errors link on the Status column and review the errors.

   2. Once you have reviewed and corrected the errors in the import file, run the import operation over again.

10. If necessary, perform the steps in the Troubleshooting the Import of All Items into the JDE Catalog Product Group task.