Wednesday, July 14, 2010

R12 Supplier Banks

Supplier Bank Accounts can be imported during Supplier and Supplier Site Open Interface

Successfull creation of Supplier and Supplier Site a Payee is created in IBY (Payments application) for the Supplier and Supplier Site.If corresponding rows are created in IBY_TEMP_EXT_BANK_ACCTS table then we can use IBY_EXT_BANKACCT_PUB.CREATE_EXT_BANK_ACCT to create bank account and associate it with the payee.In order to import supplier bank accounts during Supplier and Supplier Site Open Interface, we have to populate the IBY_TEMP_EXT_BANK_ACCTS table.
Each row in the IBY_TEMP_EXT_BANK_ACCTS table is associated with the Supplier or Supplier Site if the following condition satisfied

IBY_TEMP_EXT_BANK_ACCTS.calling_app_unique_ref1 = AP_SUPPLIERS_INT.vendor_interface_id (for Suppliers)
OR
IBY_TEMP_EXT_BANK_ACCTS.calling_app_unique_ref2 = AP_SUPPLIER_SITES_INT.vendor_site_interface_id (for Supplier Sites)

No comments:

Post a Comment