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
Good Blog, Thanks for sharing this informative article.
ReplyDeleteOracle Fusion HCM Online Training
Oracle Fusion SCM Online Training
Oracle Fusion Financials Online Training
Big Data and Hadoop Training In Hyderabad
Very interesting blog Really excellent information and thank you for giving your valuable information
ReplyDeleteOracle Fusion HCM Online Training
Thanks for sharing this great information I am impressed by the information that you have on this blog. Same as your blog i found another one Oracle ADF .
ReplyDeleteActually, I was looking for the same information on internet for
Oracle ADF Interview Questions and Answers/Tips and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject.