Create Bank and Bank Branch Using API

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

  • October 12, 2015 | 22 views