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?
5 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.
July 7, 2016 at 12:43 AM
Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
November 19, 2016 at 5:05 PM
nice!
November 20, 2016 at 10:54 PM
Awesome list! Students via essaywriting.education taking up Oracle course, will not have a hard time finding the right vendor for migration oracle.
December 29, 2018 at 9:48 PM
Thanks and Regards. Oracle Apps R12 Training Videos at affordable cost. please check oracleappstechnical.com
Post a Comment