When performing
Master Data Migration for Supplier or Customer business also needs the
migration of Associated Banks and Bank Branches.In order to
perform this we need to migrate Banks, Bank Branches and associated Bank
Branches data. Branch can only be created if a bank exist.
Step 1: Create External Banks
Appropriate External Bank values can be passed to the below API’s to insert data to
Oracle standard object CE_BANK_ACCOUNTS and other relevant tables.
Sample
script to create the Bank information is mentioned below
IBY_EXT_BANKACCT_PUB.create_ext_bank
(
p_api_version => 1.0,
p_init_msg_list => FND_API.G_TRUE,
p_ext_bank_rec => lr_extbank_rec,
x_bank_id => ln_bank_id,
x_return_status =>
lc_return_status,
x_msg_count =>
ln_msg_count,
x_msg_data =>
lc_msg_data,
x_response => lr_response_rec
);
Step
2: Create External Bank Branch
Appropriate Bank branch values can be passed to the below API’s to insert data to
Oracle standard object CE_BANK_BRANCHES and other relevant tables. Sample script to Create Bank Branch information is mentioned below
IBY_EXT_BANKACCT_PUB.CREATE_EXT_BANK_BRANCH
(
p_api_version =>
1.0,
p_init_msg_list => FND_API.G_TRUE,
p_ext_bank_branch_rec =>
p_ext_bank_branch_rec,
x_branch_id => x_branch_id,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
x_response => x_response
);
Bank and
Branch will be created in the application as shown in below screenshot
--Deepak Jeyaraj
