Creating Banks, Bank Branches and Bank Accounts in Oracle Fusion Applications

This article gives a quick overview of the Bank Structure and demonstrates how to create custom Banks, Bank Branches and Bank Accounts in Oracle Fusion Applications. 

One of the main configurations for Cash Management is you have to define banks, branches, and the actual bank accounts. The Bank and the Branch information are stored in the Trading Community Model (TCM) tables where, whereas the account is stored in Cash Management tables.

To create custom Banks, Bank Branches and Bank Accounts in Oracle Fusion Applications, on the Springboard, click on the Navigator and go to the Functional Setup Manager (also known as "Setup and Maintenance" page):

Select the "Financials" offering, and select the "Cash Management and Banking" functional area and select the task "Manage Banks". Alternatively, you can click on the Task Panel and choose the "Search" function and enter "Manage Banks":

In the Manage Banks screen, click on the + Icon to add a new Bank and fill up the required fields:

In the "Create Banks" screen, fill up the required fields of the Bank such as the Country and Name. Other fields such as contacts and addresses are optional. Once done, click on the "Save and Close" button:

Back in the "Manage Banks" screen, select the newly created Bank and click on the "Create Branch" button to add a new Bank Branch:

In the "Create Bank Branch" screen, fill up the required field ("Branch Name"). Again, the other fields such as contacts and addresses are optional. Once done, proceed to Save and Close.

Back in the "Manage Banks" screen, select the newly-created Bank and click on the "View Branch" button to View the newly-created Bank Branch:

In the "Manage Bank Branches" screen, select the desired Bank Branch and click on the "Create Account" button:

In the "Create Bank Account" screen, specify which legal entities will have access to use this Bank Account and tick the corresponding check boxes if the Bank Account will be used for Payables, Receivables and Payroll functions. Also, take note of the tabs on this screen. These tabs will be very important for Cash Management. 

• Under the General Tab, the GL Accounts section shows accounting information such as Accounts to be used for Cash, Cash Clearing and Reconciliation Differences. Under the Payment Documents section, this specifies what payment documents will be used by this bank account. These are going to be important for payables.

• Under the Controls tab, there is a section dedicated to Reconciliation such as the Tolerance Rules, Auto Reconciliation Rule Set, Start Dates, etc. Also, under Bank Statement Processing, this is where Parsing Rule Sets and bank statement transaction creation rules are configured for the Bank Account. Further below, there are also some options for Payables for minimum and maximum payments, and then some forecasting options for Cash Management.

• Under the security tab, That's an option where you could secure the bank account by directly assigning roles and/or users directly to the bank account.

• Lastly, under the Business Unit Access Tab, you can specify which business units has access to the bank account. 

If the the "Business Unit Access" tab is not filled up, you will get the below error message:

Add the necessary Business Unit access and the correct Payment Document to be used by the Bank and Save:

Below is a quick Video demonstration of creating Banks, Bank Branches and Bank Accounts in Oracle Fusion Applications:

Follow my other Social Media Accounts!

Facebook Page: https://www.facebook.com/theOracleProdigy/

Twitter: https://twitter.com/D_OracleProdigy