There is a central place to define internal bank accounts. So with centralized user interface, users can reduce the number of access points to manage bank accounts
With the help of Multi-Org Access Control, we can explicitly grant account access to multiple operating units/functions and users, which improves the visibility and control of bank accounts
A single Legal Entity is granted ownership of each internal bank account and One or more Organizations are granted usage rights. So, a single bank statement can be reconciled across multiple Operating Units, which helps to simplify reconciliation process.
Reconciliation options can now be defined at the bank account level, which provides more flexibility and control to the reconciliation process.
CE_BANK_ACCOUNTS Contains Legal Entity Level bank account information. Each bank
CE_BANK_ACCT_USES_ALL Stores Operating Unit level bank account use information.
CE_PAYMENT_DOCUMENTS Stores payment Documents to be used for Printed type Payments
CE_BANK_BRANCHES_V View: Bank/Branches Info
CE_BANK_ACCT_USES_OU_V View: Internal Bank Account Uses Info
1. Navigate to Suppliers -> Entry.
2. Query or create your supplier.
3. Click on Banking Details and then choose Create.
After creating the bank account, we can assign the bank account to the supplier site.
Benefits of Cash Pooling Techniques:
– Minimizes the idle funds by consolidating balances
– Helps to decrease external borrowing costs and increase investment returns
– Allows users to group bank accounts into pooling structures to manage funds effectively
Oracle supports following types of cash pools:
1. Self-Initiated Physical Cash Pools:
When Organizations want to monitor individual bank account balances manually and then physically move cash to or from their accounts based on their preferences, Self-Initiated Physical Cash Pools structure can be used.
We can define the rules in pool definitions, to automatically determine when bank account transfers should be made and for what amounts.
2. Bank-Initiated Physical Cash Pools, or Zero Balance Accounts(ZBA’s):
Bank-Initiated Physical Cash Pools are used When Organizations want to sweep all end-of-day balances automatically to or from the main accounts.
This kind of services will leave zero balances at the end of way. That is the reason, Bank-Initiated Physical Cash Pools are often called as Zero Balance Accounts.
3. Notional Cash Pools:
If Organizations want to track the net balances across all accounts along with individual accounts, then Notional Cash Pools will be used.
In 11i, this functionality was available to Oracle Treasury users, but now it is supported by Oracle Cash Management in R12.
- How to Define Custom Key Flexfield (KFF) in R12January 19, 2018 - 5:43 pm
- AutoLock Box Concepts In R12November 10, 2017 - 8:30 am
- R12 – java.sql.SQLException: Invalid column type in OAFSeptember 15, 2017 - 9:39 am
- How to Find Duplicate Row in OAF Page?April 26, 2017 - 5:17 pm
- How to Create DBC file in oracle apps R12 EBS?March 15, 2017 - 2:54 pm