Create Bank using IBY_EXT_BANKACCT_PUB, IBY_EXT_BANKACCT_PUB, IBY_EXT_BANKACCT_PUB and IBY_DISBURSEMENT_SETUP_PUB

Create Bank, Branch, Account and associate to Supplier

Prerequisites:

In the below examples we have done the following steps

  1. Create Bank by using the script (sql)
  2. Create Bank Branch by passing the Created Bank using the script (sql)
  3. Create Bank Account by passing the ID’s of Supplier, Bank and Bank Branch using the script (sql)
  4. After success of Bank Account creation, now we need to assign the Instrument to the above created Supplier using the script (sql)

Name of the API used:

IBY_EXT_BANKACCT_PUB.CREATE_EXT_BANK 

Base Tables Affected:

IBY_EXT_BANK_ACCOUNTS 

General Tips for Running the Create Banks:

  • Save the script file and then run the script from the SQL Prompt (Example : RUN createbanks.sql)
  • Enter the values for the Parameters from inside the script file itself unless it is required to Enter some value from the SQL Prompt.
  • This script will create the External Banks.

 

Values to be Passed in the script

  • BANK_NAME
  • BANK_NUMBER
  • INSTITUTION_TYPE
  • COUNTRY_CODE

Script To Verify whether the Create Bank is successful:

 

Navigation to find the above created Bank in Application

(N) Cash Management >> View >> Banks >> Under Manage Accounts Tab >> Banks

Query for Bank  XXAOA BANK – DEMO

Create Bank Branches

Name of the API used:

IBY_EXT_BANKACCT_PUB.CREATE_EXT_BANK_BRANCH

Base Tables Affected:

IBY_EXT_BANK_ACCOUNTS

General Tips for Running the Create Bank Branches:

  • Save the script file and then run the script from the SQL Prompt (Example : RUN createbankbranches.sql)
  • Enter the values for the Parameters from inside the script file itself unless it is required to Enter some value from the SQL Prompt.
  • This script will create the Bank Branches.

Values to be Passed in the script

  • BANK_NAME

Script To Verify whether the Create Bank Branch is successful:

 

Navigation to find the above created Bank Branch in Application

(N) Cash Management >> View >> Banks >> Under Manage Accounts Tab >> Bank Branches

Query for Bank   – XXAOA BANK – DEMO

Create Bank Account

Related posts:

Leave a Reply