Thursday, June 4, 2015
AP_VENDOR_PUB_PKG - VENDOR/SUPPLIER MIGRATION IN ORACLE APPS R12
As usual, Supplier Migration can be carried out either using Standard Interface tables or API’s. In this article, you will find sample Scripts for API’s required for Creating and updating Vendor information in Oracle Apps R12.
| Step | Action | API | Sample Script |
| 1 | Create Vendor | AP_VENDOR_PUB_PKG.CREATE_VENDOR | |
| 2 | Create Vendor Site | AP_VENDOR_PUB_PKG.CREATE_VENDOR_SITE | |
| 3 | Create Vendor Contact | AP_VENDOR_PUB_PKG.CREATE_VENDOR_CONTACT | |
| 4 | Create External Bank | IBY_EXT_BANKACCT_PUB.CREATE_EXT_BANK | |
| 5 | Create External Bank Branch | IBY_EXT_BANKACCT_PUB.CREATE_EXT_BANK_BRANCH | |
| 6 | Create Bank Branch Address | HZ_LOCATION_V2PUB.CREATE_LOCATION | |
| 7 | Assign Address to Bank Branch | HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE | |
| 8 | Create Vendor Bank Account | IBY_EXT_BANKACCT_PUB.CREATE_EXT_BANK_ACCT | |
| 9 | Assign Vendor Bank Account to Vendor | IBY_DISBURSEMENT_SETUP_PUB. SET_PAYEE_INSTR_ASSIGNMENT |
In some cases, we may need to End Date the vendor details in the source system. In case, if the source system is also Oracle Apps R12, then below API’S would be useful.
| Step | Action | API | Sample Script |
| 1 | End Date Vendor | AP_VENDOR_PUB_PKG.UPDATE_VENDOR | |
| 2 | End Date Vendor Site | AP_VENDOR_PUB_PKG.UPDATE_VENDOR_SITE |
Hopefully, This helps!!
Do you think this Article is useful?
2 Responses to “AP_VENDOR_PUB_PKG - VENDOR/SUPPLIER MIGRATION IN ORACLE APPS R12”
February 23, 2016 at 11:33 PM
Blogging is the new poetry. I find it wonderful and amazing in many ways.
November 19, 2016 at 5:05 PM
nice!
Post a Comment