Vendors interface tables and Requests?
Posted: Sat May 28, 2016 7:20 am
AP_SUPPLIERS_INT
AP_SUPPLIER_SITES_INT
AP_SUP_SITE_CONTACT_INT
IBY_TEMP_EXT_BANK_ACCTS
AP_SUPPLIER_INT_REJECTIONS (No insert in this table as after running requests you can find exception generated by Oracle in this table)
1] Supplier Open Interface Import
2] Supplier Sites Open Interface Import
3] Supplier Site Contacts Open Interface Import
or
Submit following request set and it will submit all the above requests,
Supplier Open Interface Request
>> Bank accounts will be created using AP_SUPPLIER_SITES_INT if there is data in the IBY_TEMP_EXT_BANK_ACCTS table. There is no separate requests for accounts.
AP_SUPPLIER_SITES_INT
AP_SUP_SITE_CONTACT_INT
IBY_TEMP_EXT_BANK_ACCTS
AP_SUPPLIER_INT_REJECTIONS (No insert in this table as after running requests you can find exception generated by Oracle in this table)
1] Supplier Open Interface Import
2] Supplier Sites Open Interface Import
3] Supplier Site Contacts Open Interface Import
or
Submit following request set and it will submit all the above requests,
Supplier Open Interface Request
>> Bank accounts will be created using AP_SUPPLIER_SITES_INT if there is data in the IBY_TEMP_EXT_BANK_ACCTS table. There is no separate requests for accounts.