Before you begin, please review the current Suppliers Limitations. We expect that these will be resolved over time as Oracle improves the underlying web services allowing us to add functionality to this product.
The Oracle REST web services are designed to default certain information during the upload process. To preserve performance, this Integrator has been designed to allow the background REST web service to create such default values rather than leaving this to the Oracle ERP Cloud UI.
To create new Supplier master data records, ensure the Upload Action for all relevant sections is set to Create. Alternatively the action Create records can be entered: this will upload all data contained in the sections to the right of this entry without having to enter an Upload Action value in each subsequent section.
Tip: Use the Default Values row (row 10) and set the value to Create for each section to be uploaded if you only want to upload a subsection of the data in the sheet. Alternatively, simply enter Create records (case sensitive) into the ‘Supplier Upload Action’ Default Values row to automatically set the Upload Action in the Supplier and all subsequent sections containing data for all rows present.
Sheet Structure Examples
Like all other More4apps EBS Wizards and Fusion Integrators, the worksheet sections are related to each other in a hierarchical manner. The following table demonstrates the sections’ relationships.
|
Section
|
Parent Section
|
Relationship
|
|
Suppliers
|
|
Each row in the Supplier section is a separate Supplier record
|
|
Supplier Attachments
|
Suppliers
|
Many to One
Each Supplier Attachment row is associated with the Supplier record
|
|
Addresses
|
Suppliers
|
Many to One
Each Address row is associated with the Supplier record
|
|
Sites
|
Suppliers
|
Many to One
Each Supplier Site row is associated with the Supplier record
|
|
Supplier Contacts
|
Suppliers
|
Many to One
Each Supplier Contact row is associated with the Supplier record
|
|
Contact Addresses
|
Supplier Contacts
|
Many to One
Each Contact Address row is associated with the Supplier Contact record
|
|
Site Assignments
|
Sites
|
Many to One
Each Site Assignment row is associated with the Supplier Site record
|
|
Site Attachments
|
Sites
|
Many to One
Each Site Attachment row is associated with the Supplier Site record
|
|
Products & Services
|
Suppliers
|
Many to One
Each Product & Service row is associated with the Supplier record
|
|
Business Classifications
|
Suppliers
|
Many to One
Each Business Classification row is associated with the Supplier record
|
|
Spend Authorization
|
Suppliers
|
One to One
One Spend Authorization row per Supplier record
|
The scenarios below illustrate the hierarchical layout. Examples do not include all critical columns. Note the ‘Create’ action in each section.
Scenario 1
Two Suppliers each with two Sites with two Site Assignments:
Scenario 2
Three Supplier records.
● the first has three Contacts and one Business Classification.
● the second has two Contacts and two Business Classifications.
● the third has one Contact and two Business Classifications:
Once all Supplier information is entered, the upload process can be initiated. For details on uploading refer to the Upload section.
Successful uploads will return ‘Accepted’ statuses and some response information from the web service.
Rejected uploads will return messaging.
More information on how to reprocess these records is here.
Attachments
The Integrator is only able to create Attachments as the Oracle web services does not currently allow for the update or download of existing Attachments.
Refer to the Attachment documentation for more information on these limitations.
Descriptive Flexfields
In the DFF form, the field controls may not represent the Data Type of each DFF Attribute for the chosen Context. They will be presented as shortlist LOVs as shown below:
For DFF Attributes with a Data Type of Free Text, a user can type the required value into the available field.
