Oracle Treasury

This chapter covers the following topics:

Overview
Bank Account Migration to Cash Management
Bank Account Balance Migration to Cash Management

Overview

In Release 12, a common data model and common user interface for creation and maintenance of banks, bank branches and internal bank accounts is provided in Cash Management. Prior to Release 12, if the same internal bank account was used by different applications (such as Treasury and Payables), it had to be defined separately in each application, which created fragmented data. In Release 12, an internal bank account that is intended for use by different applications can be created just once in the centralized Cash Management function and then used in any application or a select group of applications as specified by the user.

Similarly, in Release 12, a common data model and common user interface for creation and maintenance of bank account balances is also provided in Cash Management. Prior to Release 12, maintaining bank-account balances and interest calculation was only available to Treasury bank accounts. In Release 12, this feature becomes available to all bank accounts defined in the new centralized bank account model.

Bank Account Migration to Cash Management

All the existing company and subsidiary bank account information in Oracle Treasury is upgraded as follows:

All company bank accounts are automatically migrated one-to-one to the new centralized data model during the Release 12 upgrade.
All subsidiary bank accounts are automatically migrated one-to-one to the new centralized data model during the Release 12 upgrade. All counterparties that are used as banks before Release 12 in Company or Subsidiary bank accounts are automatically migrated into banks and bank branches in the centralized data model during the Release 12 upgrade. Each such counterparty will be upgraded into one bank and one bank branch belonging to this bank.

Prior to Release 12, company bank accounts were defined in the Company Profiles window. In Release 12, this tab is replaced by a Bank Accounts button that takes the user to the Bank Accounts user interface in Cash Management. Treasury Bank Accounts are distinguished in Cash Management by the Treasury Use flag that can be assigned when a bank account is created for a bank branch that is linked to a Treasury Counterparty. The Treasury Use flag is automatically selected for migrated company bank accounts.

Subsidiary accounts now also reside in the centralized data model. Unlike company bank accounts, however, they will not be visible in the Cash Management Bank Accounts user interface. They will still have to be managed in the Counterparty Profiles form. In Release 12, two new fields Portfolio Code and Pricing Model have been added to the Settlement Account Detail window. These fields are required, if the balance needs to be entered or updated for a subsidiary bank account in the Cash Management Bank balance user interface.

Although the bank account maintenance is changed in Release 12, there is no impact on bank account usage in the Treasury transactions or process flows.

Bank Account Balance Migration to Cash Management

All existing bank account balance information is upgraded as follows:

All existing bank account balance data and the rates at the balance level are automatically migrated to the new centralized data model during the Release 12 upgrade.
Default interest rate setup for bank account balances is not migrated.

Prior to Release 12, Treasury bank balances could be entered or updated in the Current Account Balances window. In Release 12, this functionality is moved to the Cash Management Bank balances user interface. Bank balances can be created or updated in this user interface for Company and Subsidiary bank accounts. Interest rates setup for bank accounts is now done in the Interest Rate Schedules user interface in Cash Management before the bank balances can be created or updated.

Current account balances window is renamed Bank Account Interest Settlement. Bank account balance information is now read-only in this window, except for the Interest amount which can still be overridden by users with appropriate privileges. Interest settlement is still initiated in this window. Balances shown in this window are still used for accrual and revaluation purposes.