Monday 12 October 2015

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


3 comments:

  1. Very interesting blog Really excellent information and thank you for giving your valuable information

    Oracle Fusion HCM Online Training

    ReplyDelete
  2. 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 .
    Actually, 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.



    ReplyDelete