Supplier Payment Details Integrator
The Supplier Payment Details Integrator is a solution for uploading data for Payment Methods, Bank Account Assignments and Payment Attributes, via the supported Oracle ERP Cloud REST web services.
The utilized REST web services that exist today, as at version 24B, are inbound web services that allow both the creation and update of supplier payment detail data in Oracle Fusion Suppliers.
Ensure you are familiar with the More4apps Finance Module prerequisites before attempting to use this Integrator.
Tip: There are many fields available in each section of this Integrator so, for performance reasons, we highly recommend using tailored worksheet layouts for specific processes.
Important to Note: As with Oracle’s FBDI products, all approval configuration in Oracle’s ‘Setup and Maintenance’ > ‘Configure Supplier Registration and Profile Change Request’ form will be bypassed by the Supplier Payment Details Integrator. Therefore, care must be taken to ensure that all data being uploaded via the Integrator has already been approved in line with your company’s policies.
Sections:
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.
Creates and Updates
The following sections and functionality are available in the Supplier Payment Details Integrator:
Key
Update
|
Create or Update
|
Read/Reference Only
|
Section Name
|
Column Name
|
Header
|
Supplier Name
|
|
Supplier Number
|
|
Address Name
|
|
Procurement BU
|
|
Supplier Site
|
|
External Payee Id
|
Payment Delivery
|
Delivery Channel
|
|
Delivery Channel Code
|
|
Bank Instruction Code 1
|
|
Bank Instruction Code 2
|
|
Bank Instruction Details
|
|
Settlement Priority
|
|
Payment Text Message 1
|
|
Payment Text Message 2
|
|
Payment Text Message 3
|
|
Service Level Code
|
Payment Specifications
|
Pay Each Invoice Alone
|
|
Bank Charge Bearer Code
|
|
Payment Reason
|
|
Payment Reason Comments
|
Separate Remittance Advice Delivery
|
Remittance Advice Delivery Method
|
|
Remittance Advice Delivery Email ID
|
|
Remittance Advice Delivery Fax
|
Payment Methods
|
Payment Method*
|
|
Primary
|
|
From Date
|
|
To Date
|
Bank Account Assignments
|
Account Number*
|
|
External Bank Account Id*
|
|
Bank Account Name
|
|
Bank Number
|
|
Bank Name
|
|
Bank Branch Number
|
|
Bank Branch Name
|
|
Currency
|
|
IBAN
|
|
Bank Code
|
|
Account Type
|
|
BIC
|
|
Primary Bank Account
|
|
From Assignment Date
|
|
Assignment Inactive On
|
*Note: The value itself cannot be changed to another value.
Note: Payment Delivery, Payment Specifications and Separate Remittance Advice Delivery only have an Upload Action of Update. Any changes to the values are considered an update.
Header Section
The information provided in the header section of the Supplier Payment Details Integrator determines the foundation for assignment of the uploaded data.
The data can be assigned to the Supplier Site Supplier Address, Supplier Profile, or all levels.
The following images illustrate how to layout your data for each of the above scenarios.
1. Supplier Site
To create/update Payment Details for a Supplier Site only. The Supplier Site Name must be entered for the integrator to determine that the upload is at the Site level and against the correct Supplier & Address.
The Supplier Name or Number and Address Name and Procurement BU and Supplier Site all need to be populated for upload at the Supplier Site level.
In scenarios 1-6 the Site is present as it is required for an upload at Site level. This is missing in scenarios 7 & 8. In these cases, the upload will take place against the Address (7) or the Supplier (8).
2. Supplier Address
To create/update Payment Details for a Supplier Address only. The Supplier Address Name must be entered for the integrator to determine that the upload is at the Address level and against the correct Supplier.
The Supplier Name or Number and Address Name all need to be populated for upload at the Supplier Address level.
In scenarios 1 & 5 the Address is present as it is required for an upload at Address level. In scenarios 2-4. the upload will take place against the Supplier as an Address is not present.
3. Supplier Profile
To create or update Payment Details for a Supplier Profile. Only the Supplier Name and/or Number must be entered.
Note: If the External Payee Id column is populated, any data in that column will be ignored for upload. This column assists in refining downloaded data only.
4. All Levels
Note: We advise as best practice to use a different sheet for each level for ease of use. However, in situations where it is necessary to upload payment details for the same Supplier at all levels. Please see below for the data layout, which is a mixture of the above methods.
Payment Attributes
The Payment Attributes Section covers Payment Delivery, Payment Specifications and Separate Remittance Advice Delivery. This section only allows a one-to-one relationship per Supplier Profile, Supplier address or Supplier Site. Only Updates can be undertaken in this section.
Payment Methods
The Payment Methods Section enables Create and Update of existing Payment Methods. This section allows a one-to-many relationship per Supplier Profile, Supplier address or Supplier Site. A user can update a Payment Method or Create an existing Payment Method assignment in the same upload. See Update Supplier Payment Detail Records.
Bank Account Assignments
The Bank Account Assignment Section enables Create and Update of existing Bank Account Assignments. This section allows a one-to-many relationship per Supplier Profile, Supplier address or Supplier Site. A user can update a Bank Account Assignments or Create a Bank Account Assignments assignment in the same upload. See Update Supplier Payment Detail Records.
Note: As Bank Accounts are often masked for security purposes it can be difficult to distinguish accounts where the masked data is different, but the other data is the same i.e.
XXXX5678
XXXX5678
Where the masked data maybe different:
56145678
12455678
When the LOV in the integrator is opened the account number as above will show once.
Once the value XXXX5678 is selected, the External Bank Id column will show both values with all its attributes so the user can use the information to select the correct value.
One the correct value is selected; the reference data populates to the sheet and the unique Id for the bank account selected is used in the upload.
Sections: