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