Importing Supplier Bank Account through Interface Tables in R12

Importing Supplier Bank Account through Interface Tables in R12

 

The data to be imported is to be inserted in the interface tables first. After inserting the data in the interface tables, the ‘Supplier Open Interface Import’ program is run for inserting the data in the R12 tables.

An important point to be noted with regard to the supplier bank accounts – the bank accounts data related to the suppliers can only be imported along with the supplier or supplier site. The bank account details cannot be imported individually. After creating the supplier or supplier site, the bank account can only be added from the user interface.

The supplier bank accounts can be assigned at the Supplier or Supplier Site or Address or Address Operating Unit level from the user interface. The import program supports assigning Supplier bank accounts at Supplier or at Supplier Site level only.

 

The main interface tables used for importing Suppliers, Supplier sites and Bank accounts data are as follows –

AP_SUPPLIERS_INT

IBY_TEMP_EXT_BANK_ACCTS.

AP_SUPPLIER_SITES_INT

 

Following business requirements can be achieved using supplier interface import

a) Importing the bank account at Supplier level along with Supplier data

b) Importing the bank account at site level along with Supplier and Supplier site

        i. Importing bank account at site along with supplier and site details.

        ii. Importing bank account along with supplier site for an existing Supplier.

c) Importing the bank accounts for Employee type Supplier

 

Following concurrent program is used to create suppliers

1. Supplier Open Interface Import
2. Supplier Sites Open Interface Import

 

Thanks Yogesh