Thursday 24 June 2021

Tables for Supplier Bank Accounts in Oracle fusion

 Here are the interface tables for the Supplier Bank Accounts in Oracle fusion :


1. IBY_TEMP_EXT_PAYEES

This table stores the Supplier Bank Payees data records.

2. IBY_TEMP_EXT_BANK_ACCTS

This table stores the Supplier Bank Accounts

3. IBY_TEMP_PMT_INSTR_USES

This table stores the Supplier Bank Account Assignments.


Supplier Banks Accounts - Uploading files into UCM - Oracle fusion

 The Supplier Bank Accounts Import has the three different csv files


1. Supplier Bank Accounts

2. Supplier Payees

3. Supplier Accounts Assignments.


The zip files needs to be uploaded into the UCM into the following area for the Import process. 

Here are the steps to be followed to upload the zip file into UCM.


1. Navigate to Tools -> File Import and Export



2. In the file import and export page, click on the '+' (upload) .

3. In the file field browse and select for the zip file.

4. From the Account list of values, select the  fin$/payables$/import$



5. Click Save and Close