Single Web Service To Import All Supplier Data (Doc ID 1965851.1)

Last updated on SEPTEMBER 12, 2017

Applies to:

Oracle Fusion Supplier Model - Version 11.1.11.1.0 and later
Oracle Fusion Supplier Model Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Goal

Previously for the Oracle Fusion Supplier Model -> Import Suppliers functionality, multiple processes need to be run to import all of the Supplier-related data (i.e., Supplier, Address,
Site, Site Assignment, Classification, etc.) An enhancement was requested to create a single web service that would accomplish all of this via a single process.

Customers may use an external database to maintain trading partner information. If a Supplier needs to be added into Fusion Applications, previously multiple import processes
need to be run. Running multiple ESS job programs is not optimal from a customer perspective. Customers need the Supplier Model application to have the ability to do the following:

1. To support a Supplier (import) web service in Fusion Procurement
2. To support add and update for Supplier, Supplier Site, Supplier Site Assignment and Supplier Address via the web service
3. To support re-using an existing trading party record instead of creating a new one if the Supplier already exists

Related data tables:

POZ_SUPPLIERS_INT
POZ_SUPPLIER_SITES_INT
POZ_SITE_ASSIGNMENTS_INT
POZ_SUP_SITE_CONTACTS_INT
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms