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

Click Here for Test Scripts

2

Create Vendor Site

AP_VENDOR_PUB_PKG.CREATE_VENDOR_SITE

Click Here for Test Script

3

Create Vendor Contact

AP_VENDOR_PUB_PKG.CREATE_VENDOR_CONTACT

Click Here for Test Scripts

4

Create External Bank

IBY_EXT_BANKACCT_PUB.CREATE_EXT_BANK

Click Here for Test Scripts

5

Create External Bank Branch

IBY_EXT_BANKACCT_PUB.CREATE_EXT_BANK_BRANCH

Click Here for Test Scripts

6

Create Bank Branch Address

HZ_LOCATION_V2PUB.CREATE_LOCATION

Click Here for Test Scripts

7

Assign Address to Bank Branch

HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE

Click Here for Test Scripts

8

Create Vendor Bank Account

IBY_EXT_BANKACCT_PUB.CREATE_EXT_BANK_ACCT

Click Here for Test Scripts

9

Assign Vendor Bank Account to Vendor

IBY_DISBURSEMENT_SETUP_PUB.

SET_PAYEE_INSTR_ASSIGNMENT

Click Here for Test Scripts

 

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

Click Here for Test Scripts

2

End Date Vendor Site

AP_VENDOR_PUB_PKG.UPDATE_VENDOR_SITE

Click Here for Test Scripts

 

Hopefully, This helps!! Smile

2 Responses to “AP_VENDOR_PUB_PKG - VENDOR/SUPPLIER MIGRATION IN ORACLE APPS R12”

UX Designers Delhi said...
February 23, 2016 at 11:33 PM

Blogging is the new poetry. I find it wonderful and amazing in many ways.


Unknown said...
November 19, 2016 at 5:05 PM

nice!


Post a Comment

Disclaimer

The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.