Concurrent Processes to Import Suppliers in Oracle Fusion

After  inserting data into Interface tables Supplier Interface Tables in Oracle Fusion the following concurrent processes must be run to import the supplier profile data in Oracle Fusion Suppliers:

• Import Suppliers
• Import Supplier Addresses
• Import Supplier Sites
• Import Supplier Site Assignments
• Import Supplier Contacts
• Import Supplier Business Classifications
• Import Supplier Products and Services Categories
• Import Supplier Attachments

Above Import Processes are executed by the Enterprise Scheduler Service (ESS), which manages all concurrent processes. Enterprise Scheduler Service allows you to monitor the status of each process and provides access to output reports. 

Below are the Supplier import processes parameters:

Import Options: 

• All
• New and 
• Rejected

Import Options are used to determine if the import process should attempt to import new, rejected, or all rows from the respective open interface tables.

Report Exceptions Only: 

• Yes 
• No. 

Used to determine if the Import Process Reports prints success and rejected information, or just the rejected information. 

When the processes are complete, a .pdf report is generated detailing the status of the records that were imported. If a record could not be imported, then the status is set to Rejected. 

The supplier import processes are used to create new entities, and to update or delete existing supplier profile data. Creation can be done only with attachments. Deletion can be done only with contact addresses, business classifications, and products and service categories.

Supplier import supports supplier numbering of characters that are not numeric to allow supplier records from legacy systems to retain their unique identifier.

Update supports updating the functional key attributes. The columns ending with _NEW are specifically earmarked for updates. Use this only if the underlying functional key attributes must be updated. To update functional keys, the new value should be provided in the _NEW column.