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.

Supplier Interface Tables in Oracle Fusion

• POZ_SUPPLIERS_INT
• POZ_SUP_ADDRESSES_INT
• POZ_SUPPLIER_SITES_INT
• POZ_SITE_ASSIGNMENTS_INT
• POZ_SUP_CONTACTS_INT
• POZ_SUP_CONTACT_ADDRESSES_INT
• POZ_SUP_BUS_CLASS_INT
• POZ_SUP_PROD_SERV_INT
• POZ_SUP_ATTACHMENTS_INT

Supplier, Address and Site Creation in Oracle Fusion

Login to Oracle Fusion Application àSelect Procurement as shown in below screenshot

It will give below options like Purchase Requisitions, Purchase Agreements, Purchase Orders, My Receipts, Negotiations, Catalogs, Suppliers and Supplier Qualification. Here select Suppliers page  as shown in below screenshot.

Select Create Supplier from Task Panel Tab as shown in below screenshot.

You will get below screenshot.

Enter information as shown below

Field Name	Value
Supplier	XX Test Supplier
Business Relationship	Spend Authorized
Tax Organization Type	Corporation
Tax Country	United States
Tax Registration Number	XXTAXREGNUM
Taxpayer ID	XYZTAX1234
D-U-N-S Number	123456789

Note: You must enter 9 digits or 13 digits for D-U-N-S Number.

Click on Create button.

Profiles Details:-

As shown in above screenshot under Profile Details click on Transaction Tax tab. Select the Allow tax applicability check box as shown in below screenshot.

Click on Save button.

Supplier Address & Site Creation:-

Click the Addresses tab.

Click on Create Icon as shown in above screenshot.

Enter below information to create address.

Field Name	Value
Address Name	XX Supplier Site
Country	United States
Address Line 1	XX Main Street
City	Atlanta
State	GA
Postal Code	12345
Language	American English
Address Purpose	Ordering & Remit to
Phone	12345
Fax
Email	xxtestsuppliersite@xyz.xyz

Click on Save button.

In the Address Details section and on the Sites tab, click Add Icon as shown in below screenshot.

You will get below screenshot.

Enter below information

Field Name	Value
Procurement BU	XX Business Unit
Site	XX Supplier Sit
Site Purpose	Purchasing, Pay & Primary Pay

Click on Save and Close button

You will get confirmation as shown in below screenshot.

Creating a Site Assignment:-

Click the Sites tab as shown in below screenshot.

You will get below screen

Click the Site name link as shown in above screenshot. You will get below screen

Click Site Assignments Tab 

Click on Add icon as shown in above screenshot.

Select Client BU and Bill to BU as shown in below screenshot. Click on Save and Close button

You will get below confirmation message. Click on Ok Button.