Thursday, May 19, 2011

IMPORT EXTERNAL BANK ACCOUNTS R12 ORACLE APPS




Below post will explain the step involved in importing an external bank account in Oracle Apps R12.
STEP 1: CREATE PARTY for BANK in TCA
API involved: IBY_EXT_BANKACCT_PUB.create_ext_bank
STEP2: CREATE PARTY for BANK BRANCH in TCA
API involved: IBY_EXT_BANKACCT_PUB.create_ext_bank_branch
STEP3: CREATE ADDRESS for BANK BRANCH as LOCATION in TCA
API Involved: HZ_LOCATION_V2PUB.CREATE_LOCATION
STEP4: CREATE PARTY SITE for BANK BRANCH with LOCATION created in above step
API Involved: HZ_PARTY_SITE_V2PUB.CREATE_PARTY_SITE
STEP 5: CREATE BANK ACCOUNT in IBY using BANK_ID, BRANCH_ID created in STEP1&2
API involved: IBY_EXT_BANKACCT_PUB.create_ext_bank_acct
SCRIPT: http://www.shareoracleapps.com/2011/05/ibyextbankacctpubcreateextbankacct-r12.html




Graphical Representation

2 Responses to “IMPORT EXTERNAL BANK ACCOUNTS R12 ORACLE APPS”

Arjun said...
September 17, 2012 at 6:48 AM

Can you please tell me the API used for creating address for Internal Banks ?


thomas paul said...
June 1, 2013 at 1:38 AM

Can you please tell me the API used for creating address for Internal Banks .


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.