All sections within the Supplier Bank Accounts Integrator, allow for record updates where supported by the Oracle web services. See Integrator Sections Table for information relating to which fields support Update actions.
To update bank account details, download the current Supplier Bank Accounts data into the appropriate sections, make the necessary changes, populate the Upload Action column with ‘Update’/ ‘Update records’ and upload the records.
The columns ‘Masked Account Number’, ‘External Bank Account Id’, ‘Assignment Id and ‘Intermediary Bank Account Id’ are unique identifiers for specific records within the sections. These columns are required for updating data in the header and child sections.
Update Bank Account Number
If masking is enabled, the existing bank account numbers will download into the column ‘Masked Bank Account Number’. To update the account, enter the designated ‘New Account Number’ column with the updated value.
Update and Create Bank Accounts
This integrator enables you to both update and create bank account information in a single upload.
In this example, the first two rows must have an Upload Action of ‘Update’, whereas the third row needs a ‘Create’ Upload Action:
Update Bank Account Owners
You cannot directly modify the account owner information, including the Primary Flag. Instead, you can end date a bank account owner assignment or update a future date. Download the current Bank Account Number into the sheet and populate the ‘Account Owner To Date’ column with the updated value.
Update Account Assignments
The ‘Assignment Id’ column must be included on the sheet for any updates in the Assignments section. The Primary flag cannot be updated. However, you can update the assignment End Date.
