This chapter tells you how to use Cash Positioning. It explains how to create cash position worksheets, generate daily cash positions from these worksheets, and view the cash position results.
This chapter covers the following topics:
Cash positioning is a planning tool that helps you view your daily cash position by currency or bank account. Cash positioning allows you to project your cash needs, and evaluate your company's liquidity position. The daily cash positions are based on actual cash flows from various Oracle Applications. You can generate a daily cash position for a single currency, multiple currencies, a single bank account, multiple bank accounts, a single Legal Entity, or multiple Legal Entities.
Refer to the following sections in this chapter for details on how to accomplish various cash positioning tasks:
A worksheet contains cash position specifications. Worksheets determine the presentation of sources (rows) and bank accounts (columns) for your cash position. Worksheets also include the following types of general information:
Worksheet name
Number of columns displayed
Cash Management provides the following two seeded worksheets:
Default Cash Position Worksheet: This worksheet includes the default values for the Bank Account Balance section, Intra-Day Activities section and all transaction sources except for the User-Defined and Open Interface sources.
Default Treasury Cash Position Worksheet: This worksheet includes the default values for the Bank Account Balance section, Intra-Day Activities section, Treasury Inflow and Treasury Outflow sources.
You can specify the sources you want to include in the cash position to create custom cash position worksheets. You can include transaction source defaults or you can choose to manually set the parameters for the transaction source. For more information on source type specifications, refer to Cash Position Worksheet Page Reference
Once you have selected your cash position specifications, you can save your worksheet, and use it to generate your daily cash positions. This process gathers current source information from the selected Oracle Applications.
The External Cashflow Open Interface allows you to utilize external sources of cash inflow and outflow data for the Cash Positioning feature, providing you an enterprise-wide cash positioning solution on a distributed database environment.
You define your worksheets to include the Open Interface Inflow and Open Interface Outflow source types. You can then generate a cash position and Cash Management automatically retrieves information available from the external sources you have defined.
Navigate to the Cash Position Worksheet Search and Results page.
Click Create Worksheet.
In the Create Cash Position Worksheet page, enter a unique name for your worksheet.
Enter the number of columns that you want Cash Management to display in each page of your cash position results. The default is 20.
Select whether to use real-time prior day cash flow and overdue transactions balances or to use calculated balances by selecting No or Yes in the Use Calculated Prior Day Cash Flow and Overdue Transactions Balances field. For more information refer to Cash Position Prior Day Cash Flow and Overdue Transactions Program
The Bank Account Balance section is required and is automatically included with the default values. To specify parameters of your choice for this section, click Set Manually and select the appropriate values for each field.
If you have set up cash pools, you can choose to include them in your cash position. To specify parameters of your choice for this section, click on the Set Manually button and select the appropriate values for each field.
Select whether to Include or Exclude Intra Day activities in your cash position. If you choose to include Intra Day activities, you can select to either include or exclude them from the closing balance calculation.
You can select from the following options:
No: Do not include intra-day activities in cash position.
Only Display: Display Intra-day activities in the cash position without affecting the closing balance. This is the default value.
Display and include in closing balance: Display intra-day activities in the cash position and add the amount to the net cash flow to calculate the closing balance.
Enable the Include This Section in the Cash Position check box for each inflow and outflow source type you want to include in the cash position. This option includes the selected sources with the default values. This option is not available for the Open Interface and the User-Defined source types.
Optionally click Set Manually to select the parameters you want to apply to your selected source types if you do not want to use the defaults. You must select appropriate values for the applicable parameters for each source type you choose to include in the worksheet. You can also choose to include multiple rows from the same source type with different parameters by clicking Add Another Row. It is recommended that you provide a unique description for each row you include to make the cash position meaningful. For the list of applicable parameters for each source type see: Cash Position Worksheet Page Reference.
Click Apply to save the worksheet.
Note: A validation is performed for each row for the following and error messages will be displayed in case of a violation:
The transaction type and transaction code combination is validated for the bank account entered, unless no bank account exists.
The bank and bank account combination is validated unless no bank account exists.
The transaction code and bank account combination is validated unless no bank account exists.
When Cash Management collects the source data for a cash position, it includes source transactions whose cash activity date is the As Of Date for the cash position. Cash Management searches for a valid date in the sequence indicated, using the first date it finds.
The following table explains which date is used as the expected cash activity date.
| Type | Expected Cash Activity Date or Time |
|---|---|
| Supplier Payments | 1. Value Date (Actual then Anticipated), 2. Maturity Date, or 3. Payment Date |
| Payroll Expenses | 1. Payment Date |
| Customer Receipts | 1. Value Date (Actual then Anticipated), 2. Maturity Date, or 3. Latest Receipt Transaction Date |
| Treasury Inflow | 1. Settlement Date |
| Treasury Outflow | 2. Settlement Date |
| Intra-Day Activities | 1. Value Date 2. Statement Date |
| Cash Management Inflow | 1. Actual Value Date 2. Cashflow Date |
| Cash Management Outflow | 1. Actual Value Date 2. Cashflow Date |
You have the flexibility to include or exclude overdue transactions for all appropriate source transaction types in your cash positions. Including overdue transactions gives you an accurate representation of potential cash inflows and outflows. Overdue transactions are open transactions with a cash activity date before the cash position As of Date.
Overdue transactions are collected and displayed on the Overdue Transactions line of the Cash Position Results page. Overdue transactions apply to the source types described below. You can specify on each worksheet whether to include overdue transactions for the applicable source types. If you choose to do so, you must also specify the Cutoff Period, which determines how far back in time to include overdue transactions.
The following table contains cash forecasting overdue transaction sources:
| Type | Definition |
|---|---|
| Supplier Payments | Payments scheduled to have been cleared before the position date, but that are still uncleared. |
| Customer Receipts | Receipts scheduled to have been cleared before the position date, but that are still uncleared. |
| Treasury Inflow | Treasury transactions scheduled to have been cleared before the position date, but that are still uncleared. |
| Treasury Outflow | Treasury transactions scheduled to have been cleared before the position date, but that are still uncleared. |
| Cash Management Inflow | Cash Management transactions scheduled to have been cleared before the position date, but that are still uncleared |
| Cash Management Outflow | Cash Management transactions scheduled to have been cleared before the position date, but that are still uncleared. |
To expedite the generation of a cash position, you can run the Cash Position Prior Day Cash Flow and Overdue Transactions program before you submit you cash position. If you specify the option to use calculated prior day cash flows and overdue transactions for the cash position results, the Cash Positioning program will use the pre-calculated prior day and overdue transactions balances. To create these pre-calculated prior day cash flow and overdue transactions balances, you must run the Cash Position Prior Day Cash Flow and Overdue Transactions program prior to generating your cash position. You can run the program manually or you can have the program run automatically according to the schedule you define. In addition to calculating prior day and overdue transactions balances, the Cash Position Prior Day Cash Flow and Overdue Transactions program will purge old summary data.
Navigate to the Submit Requests window.
Select the Submit a New Request button.
Select Cash Position Prior Day Cash Flow and Overdue Transactions program.
Leave all the parameters blank.
Click the Schedule button. Either apply a saved schedule by clicking on the Apply a Saved Schedule button or select Periodically and assign a start time. Schedule it to run every day/nightly. If you are creating a new schedule, you might want to save it. You may need to check the Increment Date Parameters Each Run checkbox if you are scheduling multiple nightly tasks for multiple as of dates.
You can submit Cash Position Prior Day Cash Flow and Overdue Transactions concurrent program manually to calculate summary prior day cash flow and overdue transaction balances.
Navigate to the Submit Requests window.
Click the Submit a New Request button.
Select to run the Cash Position Prior Day Cash Flow and Overdue Transactions program.
Enter the Worksheet Name and the As of Date.
The following table contains the legend for the Cash Inflow Source Types table.
| Legend for Inflow/Outflow Source Type Characteristics | ||
|---|---|---|
| R = Required | ARR = Customer Receipts | OII = Open Interface Inflow |
| O = Optional | XTRI = Treasury Inflow | CEI = Cash Management Inflow |
| Y = Required if Include Overdue Transactions is Yes | UDI = User-Defined Inflow |
The following table displays characteristics, such as required or optional, of the applicable fields for each source type you can enter in the Cash Position Worksheet page.
| ARR | XTRI | UDI | OII | CEI | |
|---|---|---|---|---|---|
| Description | O | O | O | O | O |
| Bank Account | R | ||||
| Transaction Type | O | ||||
| Include Indicative Exposures? | R | ||||
| External Source Type | R | ||||
| Forecast Selection Criteria Descriptive Flexfield | O | ||||
| Receipt Method | O | O | |||
| Transaction Subtype | |||||
| Include Cleared Transactions? | R | R | R | ||
| Include Overdue Transactions? | R | R | R | ||
| Cut Off Days | Y | Y | Y | ||
| Amount | R |
The following table contains the legend for the Cash Outflow Source Types table.
| Legend for Inflow/Outflow Source Type Characteristics | ||
|---|---|---|
| R = Required | APP = Supplier Payments | UDO = User-Defined Outflow |
| O = Optional | PAY = Payroll Expenses | OIO = Open Interface Outflow |
| Y = Required if Include Overdue Transactions is Yes | XTRO = Treasury Outflow | CEO = Cash Management Outflow |
The following table displays characteristics, such as required or optional, of the applicable fields for each source type you can enter in the Cash Position Worksheet page.
| APP | PAY | XTRO | UDO | OIO | CEO | |
|---|---|---|---|---|---|---|
| Description | O | O | O | O | O | O |
| Business Group | O | |||||
| Payroll Name | O | |||||
| Bank Account | R | |||||
| Include Indicative Exposures? | R | |||||
| Transaction Type | O | |||||
| External Source Type | R | |||||
| Forecast Selection Criteria Descriptive Flexfield | O | |||||
| Receipt Method | O | O | ||||
| Transaction Subtype | O | |||||
| Include Cleared Transactions? | R | R | R | |||
| Include Overdue Transactions? | R | R | R | |||
| Cut Off Days | Y | Y | Y | |||
| Amount | R |
Worksheet Name: A unique name for your cash position worksheet.
Number of Columns Displayed in Results: The number of columns that should be displayed in each page of your cash position results. The default is 20.
Use Calculated Prior Day Cash Flow and Overdue Transactions Balances: Indicates if you want to use calculated or real-time prior day cash flow and overdue transactions balances. The default is No.
Description: (Optional) A description of the source type. The information you enter here may be useful when you have multiple rows with the same source type, but different criteria.
Legal Entity: (Optional) A legal entity that you want to generate the cash position for. You can select a legal entity or leave this field blank to collect source data for all legal entities. You can have multiple rows of a bank account balance in your worksheet. Each row can be for a different legal entity, or you can have one row represent all legal entities.
Bank (Optional) The bank whose transactions you want to include in the cash position . You can select a bank name or leave this field blank to include all banks.
Bank Account: (Optional) The bank account whose transactions you want to include in the cash position. You can select a bank account or leave the Bank Account field blank to include all bank accounts. The list of values is controlled by CE: Bank Account Security profile option. See: Profile Options in Cash Management.
Important: If you selected a bank name in the Bank field and/or a legal entity, you should include bank accounts that belong to the selected bank and legal entity.
Balance Type: Select a value in this field to indicate the type of balance to be used for the opening balance of the bank accounts included in the cash pool. Options include: Available Balance, Value Dated Balance, and Ledger Balance.
Float Type: Select a value in this field to adjust your opening bank account balance. Options include: Add One Day Float, Add Two Day Float, None, Subtract One Day Float, and Subtract Two Day Float.
Cash Pool Name: The name of the cash pool.
Balance Type: The type of balance to be used for the opening balance for the bank accounts included in the cash pool. Options include: Available Balance, Value Dated Balance, and Ledger Balance.
Float Type: Select a value in this field to adjust the opening balance of the bank accounts included in the cash pool. Options include: Add One Day Float, Add Two Day Float, None, Subtract One Day Float, and Subtract Two Day Float.
Include intra-day activities in the Cash Position. Choose to include or exclude intra-day activities from the cash position results. Choices include No, Display but do not include in closing balance, and Display and include in closing balance.
Description: (Optional) A description of the source type. The information you enter here may be useful when you have multiple rows with the same source type, but different criteria.
Transaction Type: The type of transactions that you want to include in your cash position for the intra-day activities source. Choices include: All, Miscellaneous Payment, Miscellaneous Receipt, Non-Sufficient Funds, Payment, Receipt, Rejected, Statement, and Stopped.
Description (Optional) A description of the source type. The information you enter here may be useful when you have multiple rows with the same source type, but different criteria.
Payment Method (Optional) The user-defined Receivables choice to account for receipt entries and applications.
Include Cleared Transactions? : (Optional) Indicates if you want to include transactions that have been cleared on the As of Date.
Include Overdue Transactions? : (Optional) Indicates if you want to include or exclude open transactions that have a cash activity date before the cash position As Of Date.
Cut Off Days: If you choose to include overdue transactions, you must enter a value. The value you enter determines how far back to include overdue transactions.
Important: Transaction volume increases with an increase in the cutoff period. If you choose a cutoff period that is very long, and you are including many historical transactions, then the position may take longer to generate.
Description: (Optional) A description of the source type. The information you enter here may be useful when you have multiple rows with the same source type, but different criteria.
Transaction Type: The type of transactions that you want to include in your cash position for the Treasury Inflow and Outflow sources. The list of values displays the transaction types that are seeded in Oracle Treasury.
Include Indicative Exposures: For Treasury Inflow and Outflow, if you select Yes, you can include transactions in the cash position as follows:
Yes: Indicative. Include all transactions including those that may or may not occur.
No: Firm. Include only transactions that definitely have occurred or will occur.
Include Cleared Transactions? : (Optional) Indicates if you want to include transactions that have been cleared on the As of Date.
Include Overdue Transactions? : (Optional) Indicates if you want to include or exclude open transactions that have a cash activity date before the cash position As Of Date.
Cut Off Days: If you chose to include overdue transactions, you must enter a value. The value you enter determines how far back to include overdue transactions.
Important: Transaction volume increases with an increase in the cutoff period. If you choose a cutoff period that is very long and you are including many historical transactions, then the position may take longer to generate.
Description: (Optional) A description of the source type. The information you enter here may be useful when you have multiple rows with the same source type, but different criteria.
External Source Type: Indicates the user-defined external source type for Open Interface Inflow or Open Interface Outflow. The list of values is from the Context field of the Forecast Selection Criteria Descriptive flexfield you created during setup of the External Cashflow Open Interface.
Forecast Selection Criteria: The descriptive flexfield that indicates the external forecast selection criteria based on the external source type you entered in the previous field for Open Interface Inflow or Open Interface Outflow sources. The list of values is from the segments you defined for the Forecast Selection Criteria Descriptive flexfield.
Description: (Optional) A description of the source type. The information you enter here may be useful when you have multiple rows with the same source type, but different criteria.
Amount: The amount of the user-defined inflow and outflow.
Bank Account: The bank account to which the user-defined inflow and outflow amounts belong. This should be a bank account that you have previously selected for inclusion in your cash position in the Bank Account Balance section.
Description: (Optional) A description of the source type. The information you enter here may be useful when you have multiple rows with the same source type, but different criteria.
Payment Method: (Optional) Payment methods predefined in Oracle Payables for how suppliers' invoices can be paid. Choices include: Check, Electronic, Wire, Future Dated, Manual Future Dated, and Clearing.
Include Cleared Transactions? : (Optional) Indicates if you want to include transactions that have been cleared on the As Of Date.
Include Overdue Transactions? : (Optional) Indicates if you want to include or exclude open transactions that have a cash activity date before the cash position As Of Date.
Cut Off Days: If you chose to include overdue transactions, you must enter a value.. The value you enter in the determines how far back to include overdue transactions.
Important: Transaction volume increases with an increase in the cutoff period. If you choose a cutoff period that is very long and you are including many historical transactions, then the position may take longer to generate.
Description: (Optional) A description of the source type. The information you enter here may be useful when you have multiple rows with the same source type, but different criteria.
Payroll Name: (Optional) Indicates the name of the payroll to include in the cash position. Leave this field blank to include cash flows from all payrolls.
Payment Method: (Optional) Predefined and user-defined payment methods in Oracle Payroll for how employees' payroll can be paid. Predefined choices include: Cash, Check, and NACHA (National Automated Clearing House Association).
A cash position worksheet contains rows that define transaction sources and columns that display either currencies or bank accounts included in the cash position. You can define reusable worksheets for generating cash positions.
When you submit a cash position, Cash Management collects the necessary source data and summarizes the information as cash position amounts, based on the cash position worksheet specifications. The cash position data is then available for update, inquiry, viewing in a Discoverer Workbook, or for export to a spreadsheet application.
You can generate a new cash position because you have created a new worksheet, or because you want to recalculate a cash position with different submission parameters.
After you create a new worksheet, click Apply. See: Creating a Cash Position Worksheet
Click Generate Cash Position in the Confirmation page.
In the Generate Cash Position page select appropriate values for the submission parameters. See: Generate Cash Position Page Reference
Select Continue to generate the cash position.
Query an existing worksheet in the Cash Position Worksheet Search and Results page.
Select the Generate Cash Position icon corresponding to the worksheet you want to use.
In the Generate Cash Position page, select appropriate values for the submission parameters. See:Generate Cash Position Page Reference
Select Continue to generate the cash position.
As Of Date: The date for which you want to generate the cash position. The default value is the system date.
Factor: Indicates the way amounts are displayed in the cash position.
Currency: The currency for the source transactions for which you want to generate a cash position. Leave this field blank to include all currencies in your cash position.
View By: Indicates how to display the cash position results. Choices include Bank Account, Currency, and Cash Pool.
Include Subsidiary's Bank Account Balance: If you have subsidiary bank accounts set up in Oracle Treasury, you can choose to include the bank account balances of the subsidiary bank accounts in your cash position. Subsidiary bank account balances are summarized by currency and added to the opening balance of the appropriate currency in the Cash Position Results by Currency page. The subsidiary bank account balances are displayed in a separate section below the cash position results when you view the cash position results by bank account.
The opening bank account balance displayed in the cash position results is the previous day's closing bank account balance for that bank account.
The balance type and the float type used in calculating the opening balance is determined by the selections made in the cash position worksheet.
If the previous day's closing balance is not available, then the latest available bank account balances are displayed instead. In this case, the cash position results also display a Prior Day Cashflows row that includes transactions between the latest available balance date and the Cash Position As of Date.
The closing balance is calculated as Opening Balance + Prior Day Cash Flows + Net Cash Flow.
For cash pools included in the cash position, the opening balance is the sum of the previous day's balances or the last available balance for all the bank accounts included in the cash pool.
You can also define target balances for bank accounts. These target balances are displayed in the cash position and help you determine the surplus or deficit balance for bank accounts that you include in your cash position. See: Company Profiles, Oracle Treasury User Guide.
A balance gap arises when you have gaps in your cash flows between the current system date and your defined until date. This gap can occur under the following circumstances:
You begin with a negative balance and need to borrow money. The balance gap occurs because you don't know when you will receive sufficient funds to pay off part or all of the loan.
You have a positive balance, and you invest the money. The balance gap occurs because you don't know when you will need part or all of that money to cover future obligations.
Knowing when a balance gap occurs is crucial to effectively handle the funds you loaned or invested. You can use the View Balance Gapping window/page, to manage your balance gaps.
To reduce your balance gapping results, enter amount ranges that meet your cashflow requirements. The balance gapping results incorporate real time data from Oracle Treasury.
In the Cash Position Results page, choose the View Balance Gapping button. The View Balance Gapping page appears.
Select a currency for which you want to view the balance gaps.
Select a previously run cash forecast in the Forecast Name field. The forecast selected here will be used to populate the net cash flow data from Oracle Payables, Oracle Receivables and Oracle Payroll. Cashflows from Oracle Treasury will be obtained directly. This field is optional for Oracle Treasury users (if you only want to include cashflows from Oracle Treasury), but it is required for non-Treasury Users.
In the Start Date and End Date fields, enter the dates between which you want to view your balance gaps.
(Optional) Select a legal entity for which you want to view your balance gaps. To view balance gaps for all legal entities, leave this field blank.
(Optional) Select a bank account for which you want to view your balance gaps. To view balance gaps for all bank accounts, leave this field blank.
In the Balance From and To fields, enter an amount range for the balance gap that you want to view. To view all balance gaps, leave these fields blank.
Tip: If you borrowed money to cover a negative balance, enter a number equal to or greater than zero in the Balances From field. By entering a larger number, you accept a larger balance gap. If you had a positive balance and invested the money, enter a number equal to or less than zero in the To field. By entering a larger negative number, you accept a larger balance gap.
Choose the Refresh Gapping Data button to generate balance gapping.
You can view the details of the gapping results in a Discoverer Workbook by selecting View in Discoverer Workbook. See: Viewing Cash Positions in Discoverer
If you are a Oracle Treasury User, the cash position results also include an Available Liquidity section that displays your current position by currency in Short Term Money, Discounted Securities and Fixed Income Securities.
You can click on the amounts displayed for each deal type to drill down to the details of the underlying deals.
In the Short Term Money Details page, you can view the details of the short term money deals and access the Short Term Money window in Oracle Treasury by clicking on the Manage Short Term Money button. In the Fixed Income Securities Details page, you can view the details of the fixed income securities deals and access the Fixed Income Securities window or the Fixed Income Securities for Resale/Repurchase window in Oracle Treasury by clicking on the Create Fixed Income Securities Deal or Resell Fixed Income Securities Deal button respectively. In the Discounted Securities Details page, you can view the details of the discounted securities deals and access the Discounted Securities window or the Discounted Securities Resales window in Oracle Treasury by clicking on the Create Discounted Securities Deal or Resell Discounted Securities Deal button respectively. See: Deal Types and Product Types, Oracle Treasury User Guide
If your cash position includes cash pools, you can select to generate a cash leveling proposal from the Cash Position Results Page, in the Bank Account View Page or Cash Pool View Page. The Cash Leveling Proposal is calculated online based on the Sub Account target balances and transfer amount calculation rules.
For notional cash pools and physical cash pools with bank initiated sweeps, you can use the cash leveling proposal to approximate the projected closing balance of the concentration account so that the investment or funding decisions could be made from the concentration account based on the projection. By clicking the Apply button, the composition results are displayed.
For physical cash pools that do not have bank initiated sweeps, you have the option to generate Intercompany Funding Transactions and/or Inter-Account transfers from the cash leveling proposal. These transfers can then be included in the payment file and sent to the bank through Oracle Treasury.
You can select transfers for which you want to generate transfers in Oracle Treasury and click the Apply button. This will display a Warning page, where you will be provided with the options of submitting the Generate Cash Leveling Transfers concurrent request to generate inter-account and intercompany fund transfers in Oracle Treasury. See: Cash Leveling, Oracle Treasury User Guide
Subsidiary bank accounts that are part of the cash pool are included in the cash leveling proposal. However, since the projected closing balance is not calculated for subsidiary bank accounts, the opening balance is used in calculations instead. You can update the transfer amount calculated and click the Recalculate New Closing Balance button to recalculate the closing balances.
The Transfer Amount will be calculated as follows:
For notional cash pools, the Transfer Amount is equal to the difference between zero and the Closing Balances (as calculated on the Cash Position for the Sub Accounts).
For example, if the projected closing balance for a Sub Account in a Notional Cash Pool is -150,000.00, then the transfer amount between the Sub Account and the Concentration Account will be 150,000.00. The New Closing Balance for the Sub Account will be zero. The New Closing Balance of the Concentration Account will be the Closing Balance (as calculated on the Cash Position for this account) plus the Transfer Amount with the opposite sign, which in this case is equal to -150,000.00.
For physical cash pools, the Transfer Amount is equal to the difference between the Closing Balances (as calculated on the Cash Position for the Sub Accounts) and the nearest target balance (if the projected balance is outside of the target range), adjusted for the Rounding Factor, Rounding Rule, and Minimum Receipt/Payment Amount.
In case where there are two concentration accounts, the calculation of the Transfer Amount is the same as in the case where there is only one concentration account. The only difference is in the destination of the transfer amount. The payments from the Sub Account will go to the Investment Concentration Account and the receipts to the Sub Account will originate from the Funding Concentration Account.
For sub accounts belonging to the subsidiaries, since there is not Projected Closing Balance calculated, the opening balance (as displayed on Cash Position) will be used instead.
Example 1
Projected Closing Balance for a Sub Account in a Physical Cash Pool = -150,005.15
Projected Closing Balance for the Concentration Account = 10,000.00
Minimum Target Balance = 50,000.00
Maximum Target Balance = 100,000.00
Minimum Payment Amount = 100
Minimum Receipt Amount = 1000
Rounding Factor = 10
Rounding Rule = Nearest
Transfer Amount: The difference between 50,000 and -150,005.15 is 200,005.15. Rounded to the factor of 10 and using the "Nearest" rounding rule this amount is transformed to 200,010.00. This amount is greater than the Minimum Payment/Receipt Amounts. Therefore, the Transfer Amount = 200,010.00. New Closing Balance for this Sub Account is -150,005.15 + 200,010.00 = 50,004.85.
The New Closing Balance of the Concentration Account will be the Closing Balance (as calculated on the Cash Position for this account) plus the Transfer Amount with the opposite sign: 10,000 - 200,010.00 = -190,010.00.
Example 2
Projected Closing Balance for a Sub Account in a Physical Cash Pool = 150,155.15
Projected Closing Balance for the Concentration Account = 10,000.00
Minimum Target Balance = 50,000.00
Maximum Target Balance = 100,000.00
Minimum Payment Amount = 100
Minimum Receipt Amount = 1000
Rounding Factor = 100
Rounding Rule = Round Down
Transfer Amount: The difference between 100,000 and 150,155.15 is -50,155.15. Rounded to the factor of 100 and using the "Round Down" rounding rule this amount is transformed to -50,100.00. This amount is greater than the Minimum Payment/Receipt Amounts. Therefore, the Transfer Amount = -50,100.00. New Closing Balance for this Sub Account is 150,155.15 - 50,100.00 = 100,055.15.
The New Closing Balance of the Concentration Account will be the Closing Balance (as calculated on the Cash Position for this account) plus the Transfer Amount with the opposite sign: 10,000 + 50,100.00 = 60,100.00.
Example 3
Projected Closing Balance for a Sub Account in a Physical Cash Pool = 60,000.00
Projected Closing Balance for the Concentration Account = 10,000.00
Minimum Target Balance = 50,000.00
Maximum Target Balance = 100,000.00
Minimum Payment Amount = 100
Minimum Receipt Amount = 1000
Rounding Factor = 100
Rounding Rule = Round Down
Transfer Amount: The projected closing balance (60,000.00) falls within the target balance range (50,000 - 100,000), therefore, no transfer is required and the Transfer Amount will be set to zero.
Example 4
Projected Closing Balance for a Sub Account in a Physical Cash Pool = 49,995.00
Projected Closing Balance for the Concentration Account = 10,000.00
Minimum Target Balance = 50,000.00
Maximum Target Balance = 100,000.00
Minimum Payment Amount = 100
Minimum Receipt Amount = 1000
Rounding Factor = 100
Rounding Rule = Round Down
Transfer Amount: The difference between 50,000 and 49,995 is 5. Rounded to the factor of 100 and using the "Round Down" rounding rule this amount is transformed to 0. This amount is less than the Minimum Payment/Receipt Amounts. Therefore, no transfer is required and the Transfer Amount will be set to zero.
Example 5
Projected Closing Balance for a Sub Account in a Physical Cash Pool = 49,995.00
Projected Closing Balance for the Concentration Account = 10,000.00
Minimum Target Balance = 50,000.00
Maximum Target Balance = 100,000.00
Minimum Payment Amount = 100
Minimum Receipt Amount = 1000
Rounding Factor = Unit
Rounding Rule = Nearest
Transfer Amount: The difference between 50,000 and 49,995 is 5. Rounded to the factor of Unit and using the "Nearest" rounding rule this amount is transformed to 5. This is a receipt to the Sub Account and it is less than the Minimum Receipt Amount. Therefore, no transfer is required and the Transfer Amount will be set to zero.
Example 6
Projected Closing Balance for a Sub Account in a Physical Cash Pool = 100,005.16
Projected Closing Balance for the Concentration Account = 10,000.00
Minimum Target Balance = 50,000.00
Maximum Target Balance = 100,000.00
Minimum Payment Amount = 100
Minimum Receipt Amount = 1000
Rounding Factor = Unit
Rounding Rule = Nearest
Transfer Amount: The difference between 100,000 and 100,005,16 is -5.16. Rounded to the factor of Unit and using the "Nearest" rounding rule this amount is transformed to -5.16. This is a payment from the Sub Account and it is less than the Minimum Payment Amount. Therefore, no transfer is required and the Transfer Amount will be set to zero.
Example 7
Projected Closing Balance for a Sub Account in a Physical Cash Pool = 100,005.16
Projected Closing Balance for the Concentration Account = 10,000.00
Minimum Target Balance = 0
Maximum Target Balance = 0
Minimum Payment Amount = null
Minimum Receipt Amount = null
Rounding Factor = Unit
Rounding Rule = Nearest
Transfer Amount: The difference between 0 and 100,005,16 is -100,005.16. Rounded to the factor of Unit and using the "Nearest" rounding rule this amount is transformed to -100,005.16. This is a payment from the Sub Account and there are no minimum requirements for the payment amount. Therefore, the Transfer Amount = -100,005.16. New Closing Balance for this Sub Account is = 100,005.16 - 100,005.16 = 0.
The New Closing Balance of the Concentration Account will be the Closing Balance (as calculated on the Cash Position for this account) plus the Transfer Amount with the opposite sign: 10,000 + 100,005.16 = 110,005.16.
Example 8
Projected Closing Balance for a Sub Account in a Physical Cash Pool = 100,005.16
Projected Closing Balance for the Concentration Account = 10,000.00
Projected Closing Balance for the Funding Concentration Account = 5,000.00
Minimum Target Balance = 0
Maximum Target Balance = 0
Minimum Payment Amount = null
Minimum Receipt Amount = null
Rounding Factor = Unit
Rounding Rule = Nearest
Transfer Amount: The difference between 0 and 100,005,16 is -100,005.16. Rounded to the factor of Unit and using the "Nearest" rounding rule this amount is transformed to -100,005.16. This is a payment from the Sub Account (therefore, it will go to the Investment Concentration Account) and there are no minimum requirements for the payment amount. Therefore, the Transfer Amount = -100,005.16. New Closing Balance for this Sub Account is = 100,005.16 - 100,005.16 = 0.
The New Closing Balance of the Investment Concentration Account will be the Closing Balance (as calculated on the Cash Position for this account) plus the Transfer Amount with the opposite sign: 10,000 + 100,005.16 = 110,005.16. This transfer will not affect the New Closing Balance of the Funding Concentration Account, which will still be equal to 5,000.00.
Example 9
Projected Closing Balance for a Sub Account in a Physical Cash Pool = -400.00
Projected Closing Balance for the Concentration Account = 10,000.00
Projected Closing Balance for the Funding Concentration Account = 5,000.00
Minimum Target Balance = 0
Maximum Target Balance = 0
Minimum Payment Amount = null
Minimum Receipt Amount = null
Rounding Factor = Unit
Rounding Rule = Nearest
Transfer Amount: The difference between 0 and -400 is 400. Rounded to the factor of Unit and using the "Nearest" rounding rule this amount is transformed to 400. This is a receipt to the Sub Account (therefore, it will originate from the Funding Concentration Account) and there are no minimum requirements for the receipt amount. Therefore, the Transfer Amount = 400. New Closing Balance for this Sub Account is -400 + 400 = 0.
The New Closing Balance of the Funding Concentration Account will be the Closing Balance (as calculated on the Cash Position for this account) plus the Transfer Amount with the opposite sign: 5,000 - 400 = 4,600.00. This transfer will not affect the New Closing Balance of the Investment Concentration Account, which will still be equal to 10,000.
When you generate a cash position, your cash position results are displayed by currency, by bank account, or by cash pools, depending on your selection in the View By field in the Generate Cash Position page. You can switch among the three views by selecting the appropriate value in the View By field and clicking Refresh Data. Cash Management displays the cash position results in a spreadsheet format with the rows representing the cash flows and the balances and the columns representing either bank accounts, currencies, or cash pools.
The cash position results displayed on this page represent only those transactions that are associated with bank accounts to which the current user has Bank Account Access security enabled. This is controlled by CE: Bank Account Security profile option. See: Profile Options in Cash Management.
In the Cash Position Results: Currency View page, the results of your cash position are displayed by currency with each column representing a currency included in your position. If you chose to include subsidiary bank account balances in your cash position, they are added to the opening balance for the currency which corresponds to the subsidiary bank account's currency. This page also displays the available liquidity for Oracle Treasury users.
In the Cash Position Results: Currency View page, you can do the following:
View the opening balance, cash flows, net cash flow, projected closing balance, target balance, and the difference between the projected closing balance and the target balance by currency.
Modify your cash position results by modifying the values for any of the following parameters: As Of Date, Currency, Legal Entity, Currency Range, View By, and Include Subsidiary's Bank Account Balance, and clicking Refresh Data.
Drill down to the details of the source transactions by clicking an amount. This brings up the Source Transaction Details page that displays all the transactions that make up the cash position amount. See: Source Transaction Details Page Reference
Drill down to the details of the intra-day activities by clicking the intra-day activities amount. This brings up the Intra-Day Activities and Net Cash Flow Details page which displays all the intra-day transactions as well as all the transactions included in your cash position from various sources that make up the net cash flow amount. See: Intra-Day Activities and Net Cash Flow Detail Page Reference.
Generate balance gapping by clicking View Balance Gapping. See: Balance Gapping in Cash Positioning.
Export the cash position results to an external application like Excel by clicking Export. See: Exporting Cash Position Results to Your Spreadsheet Application.
Access the Bank Account Transfers page in Oracle Cash Management by clicking Initiate Bank Account Transfer.
Access the Inter-Account Transfers window in Oracle Treasury by clicking Initiate Funds Transfer. This option is only available to Oracle Treasury users.
View the details of the cash position in a Discoverer workbook by selecting View in Discoverer Workbook. This option is available only if Oracle Discoverer is installed.
Drill down to the details of the transactions corresponding to the deal types of short term money, discounted securities and fixed income securities in the Available Liquidity section by clicking on the amount. This section is displayed only for Oracle Treasury users. See: Available Liquidity Details and Viewing Liquidity and Limit Types, Oracle Treasury User Guide.
In the Cash Position Results: Bank Account page, the results of your cash position are displayed by bank account with each column representing a bank account included in your position. If you chose to include subsidiary bank account balances in your cash position, they are summarized by currency and displayed in a separate section below the cash position results.
In the Cash Position Results: Bank Account View page, you can do the following:
View the opening balance, cash flows, net cash flow, projected closing balance, target balance, and the difference between the projected closing balance and the target balance by bank account.
Modify your cash position results by modifying the values for any of the following parameters: As Of Date, Currency, Legal Entity, Bank Account Range, View By, and Include Subsidiary's Bank Account Balance, and clicking Refresh Data.
Drill down to the details of the source transactions by clicking an amount. This brings up the Source Transaction Details page that displays all the transactions that make up the cash position amount.
Drill down to the details of the intra-day activities by clicking the intra-day activities amount. This brings up the Intra-Day Activities and Net Cash Flow Details page which displays the intra-day transactions as well as all the transactions included in your cash position from various sources that make up the net cash flow amount.
Generate balance gapping by clicking View Balance Gapping.
Export the cash position results to an external application like Excel by clicking Export.
Access the Bank Account Transfers page in Oracle Cash Management by clicking Initiate Bank Account Transfer.
Access the Inter-Account Transfers window in Oracle Treasury by clicking Initiate Funds Transfer. This option is only available to Oracle Treasury users.
Save projected balances to the Balances table by selecting Save Projected Balances.
View the details of the cash position in a Discoverer workbook by selecting View in Discoverer Workbook. This option is available only if Oracle Discoverer is installed. See: Viewing Cash Positions in Discoverer.
Drill down to the details of the transaction corresponding to the deal types of short term money, discounted securities and fixed income securities in the Available Liquidity section by clicking on an amount. This section is only displayed for Oracle Treasury users. See: Available Liquidity Details and Viewing Liquidity and Limit Types, Oracle Treasury User Guide.
In the Cash Position Results: Cash Pool page, the results of your cash position are displayed by cash pool with each column representing the cash pools or individual bank accounts included in your position. If you chose to include subsidiary bank account balances in your cash position, they are summarized by currency and displayed in a separate section below the cash position results.
In the Cash Position Results: Cash Pool page, you can do the following:
View the opening balance, cash flows, net cash flow, projected closing balance, target balance, and the difference between the projected closing balance and the target balance by cash pool.
Modify your cash position results by modifying the values for any of the following parameters: As Of Date, Currency, Company, Cash Pool Range, View By, and Include Subsidiary's Bank Account Balance, and clicking Refresh Data.
Drill down to the details of the source transactions by clicking an amount. This brings up the Source Transaction Details page that displays all the transactions that make up the cash position amount.
Generate balance gapping by clicking View Balance Gapping.
Export the cash position results to an external application like Excel by clicking Export.
Access the Bank Account Transfers page in Oracle Cash Management by clicking Initiate Bank Account Transfer.
Access the Inter-Account Transfers window in Oracle Treasury by clicking Initiate Funds Transfer. This option is only available to Oracle Treasury users.
Drill down to the details of the transaction corresponding to the deal types of short term money, discounted securities and fixed income securities in the Available Liquidity section by clicking on an amount. This section is only displayed for Oracle Treasury users. See: Available Liquidity Details and Viewing Liquidity and Limit Types, Oracle Treasury User Guide.
Generate a cash leveling proposal.
As of Date: Indicates the date for which the cash position is generated.
Factor: Indicates the way amounts are displayed in the forecast.
Currency: The currency for which the cash position results are displayed. The value here defaults from the value selected for the Currency field in the Generate Cash Position page. If no value was selected for this field in the Generate Cash Position page, then this field will be blank.
Legal Entity: The legal entity for which the cash position results are displayed.
Currency Range: If the number of columns in your cash position results by currency exceeds the number of columns you specified in the cash position worksheet, the results are displayed in multiple pages. You can navigate between the pages by selecting a value in this field and clicking Refresh Data.
Bank Account Range: If the number of columns in your cash position results by bank account exceeds the number of columns you specified in the cash position worksheet, the results are displayed in multiple pages. You can navigate between the pages by selecting a value in this field and clicking Refresh Data.
View By: Indicates whether the cash position results are displayed by currency, by bank account, or by cash pool. You can select the appropriate option in this field and click Refresh Data to view the cash position results by the selected option.
The following table contains the legend for the Source Transaction Details Column Reference table.
| Legend for Cash Positioning Source Transaction Details Column Reference: Inflows | ||
|---|---|---|
| S = Summary section | ARR = Customer Receipts | CEI = Cash Management Inflow |
| D = Detail section | XTRI = Treasury Inflow |
The following table contains the source transaction details column reference for cash inflow.
| Column | ARR | XTRI | CEI |
|---|---|---|---|
| Cash Activity Date | S | S | S |
| Transaction Currency | S | S | S |
| Transaction Amount | S | S | S |
| Organization | D | ||
| Receipt Number | S | ||
| Bank Account Currency | S | S | S |
| Bank Account Amount | S | S | S |
| Status | D | D | |
| Deal Number | S | ||
| Deal Type | S | ||
| Counterparty | S | ||
| Amount Type | S | ||
| Deal Subtype | D | ||
| Transaction Number | S | ||
| Cashflow Number | S | ||
| Bank Account Name | D | ||
| Bank Account Number | D | ||
| Description | D | ||
| Counterparty Name | D | ||
| Counterparty Bank Account | D | ||
| Transaction Subtype | D | ||
| Legal Entity | D | D | |
| Receipt Method | D | ||
| Product Type | D | ||
| Portfolio Code | D |
The following table contains the legend for the Source Transaction Details Column Reference table.
| Legend for Cash Positioning Source Transaction Details Column Reference: Outflows | ||
|---|---|---|
| S = Summary section | APP = Supplier Payments | XTRO = Treasury Outflow |
| D = Detail section | PAY = Payroll Expenses | CEO = Cash Management Outflow |
The following table contains the cash positioning source transaction details column reference for cash outflow.
| Column | APP | PAY | XTRO | CEO |
|---|---|---|---|---|
| Cash Activity Date | S | S | S | S |
| Transaction Currency | S | S | S | S |
| Transaction Amount | S | S | S | S |
| Payment Priority | D | |||
| Supplier Type | D | |||
| Pay Group | D | |||
| Organization | D | |||
| Payment Number | S | |||
| Bank Account Currency | S | S | S | S |
| Bank Account Amount | S | S | S | S |
| Status | D | D | ||
| Payment Method | D | D | ||
| Payroll Name | S | |||
| Business Group | D | |||
| Deal Number | S | |||
| Deal Type | S | |||
| Counterparty | S | |||
| Amount Type | S | |||
| Deal Subtype | D | |||
| Transaction Number | S | |||
| Cashflow Number | S | |||
| Bank Account Name | D | |||
| Bank Account Number | D | |||
| Description | D | |||
| Counterparty Name | D | |||
| Counterparty Bank Account | D | |||
| Transaction Subtype | D | |||
| Legal Entity | D | D | ||
| Product Type | D | |||
| Portfolio Code | D |
Legend for Cash Positioning Intra-Day Activities and Net Cash Flow Details
S = Summary section
D = Detail Section
IDA = Intra-Day Activities
NCF = Net Cash Flow
The following table contains the intra-day activities and net cash flow details column reference.
| Column | IDA | NCF |
|---|---|---|
| Cash Activity Date | S | S |
| Transaction Currency | S | S |
| Transaction Amount | S | S |
| Transaction Number | S | S |
| Organization | D | |
| Bank Account Currency | S | S |
| Bank Account Amount | S | S |
| Status | D | |
| Line Number | S | |
| Payment Method | D | |
| Transaction Type | S | S |
| Exchange Rate Type | D | |
| Exchange Rate | D | |
| Agent | D | |
| Agent Bank Account | D | |
| Invoice Number | D | |
| Value Date | D | |
| Description | D |
The following table contains the legend for the Short Term Money, Fixed Income Securities, and the Discounted Securities Details pages table.
| Legend for Short Term Money, Fixed Income Securities, and the Discounted Securities Details Pages Table | ||
|---|---|---|
| S = Summary section | STM = Short Term Money | FIS = Fixed Income Securities |
| D = Detail section | DS = Discounted Securities |
The following table contains the Short Term Money, Fixed Income Securities, and the Discounted Securities Details pages.
| Column | STM | DS | FIS |
|---|---|---|---|
| Deal Number | S | S | S |
| Portfolio | S | S | S |
| Deal Subtype | S | S | S |
| Product Type | S | S | S |
| Rate | S | S | S |
| Maturity Date | S | S | S |
| Balance | S | S | S |
| Transaction Number | D | D | D |
| Face Value | D | D | D |
| Rate Basis | D | D | D |
| Start Date | D | D | D |
| Deal Date | D | D | D |
| Counterparty | D | D | D |
You can, with some limitations, modify cash position worksheets and cash position results.
Navigate to the Cash Position Search and Results page.
(Optional) Enter a partial or full Worksheet Name.
Click Go. Cash Management displays all worksheets that match your search criteria.
Click the worksheet name in the Cash Position Worksheet Results table to view the details.
Query an existing cash position worksheet.
You can modify any of the information for the cash position worksheet by selecting the Update icon corresponding to your worksheet.
Query an existing cash position worksheet (see above).
Click the Generate Cash Position icon. The Generate Cash Position page appears.
Select appropriate values for the parameters and click Continue to generate the cash position.
Click the amount corresponding to a transaction source for the bank account or currency in the cash position results that you want to modify. The Source Transaction Details page appears.
You can choose to exclude transactions by disabling the Include checkbox that corresponds to the transaction.
Query an existing cash position worksheet.
Click the Generate Cash Position icon. The Generate Cash Position page appears.
Select appropriate values for the parameters and click Continue button to generate the cash position.
Click the amount corresponding to the currency or bank account for which you want to generate exposures in the Intra-Day Activities row. The Intra-Day Activities and Net Cash Flow Details page appears.
You can choose to generate exposures in Oracle Treasury by selecting one or more intra-day transactions and clicking on the Generate Exposures button.
The Generate Exposures page appears, where you can enter details for the selected exposure transactions and click Apply to generate exposures and return to the Intra-Day Activities and Net Cash Flow Details page
Important: This feature is available only to Oracle Treasury users.
You can transfer cash position results to you spreadsheet application. Excel can be used to manipulate information for analysis and graphical representation. Use the Export button in the Cash Position Results page to export cash positions from Cash Management to Microsoft Excel. This option is available only on the Windows platform, and only if Excel is installed.
Navigate to the Cash Position Worksheets Search and Results page.
Generate a cash position See: Generating a Cash Position
In the Cash Position Results page, click on the Export button. The Save dialogue box appears.
Enter the file name and select the file type to export the results.
Click Save.
You can make modifications to your cash position results in your spreadsheet application.
Note: Saving in your spreadsheet application does not save an updated spreadsheet in your Oracle database.
You can view cash position results in a Discoverer Workbook. Oracle Discoverer enables you to manipulate information for analysis and graphical representation. To view cash position results in Oracle Discoverer, click the View in Discoverer button in the Cash Position Results page. This option is only available if you have Oracle Discoverer installed.
Cash Management provides one predefined workbook, which contains the following worksheets:
Cash Position with Surplus/Deficit
Cash Position with Closing Balance
Cash Position with Surplus/Deficit using Calculated Prior Day Cash Flow and Overdue Transactions
Cash Position with Closing Balance using Calculated Prior Day Cash Flow and Overdue Transactions
Gapping Details Worksheet
Supplier Payments Worksheet
Customer Receipts Worksheet
Payroll Expenses Worksheet
Treasury Transactions Worksheet
Intra-Day Activities Worksheet
This worksheet displays the cash position results along with the surplus and deficit. The prior day cash flow and overdue transactions rows are both calculated in real time.
This worksheet displays the cash position results along with the closing balance. The prior day cash flow and overdue transactions rows are both calculated in real time.
This worksheet displays the cash position results along with surplus or deficit. The prior day cash flow and overdue transactions rows are both calculated using the Cash Position Prior Day Cash Flow and Overdue Transactions program.
This worksheet displays the cash position results along with the closing balance. The prior day cash flow and overdue transactions are both calculated using the Cash Position Prior Day Cash Flow and Overdue Transactions program.
This worksheet displays the details of the balance gapping results grouped by bank account.
This worksheet displays details of supplier payments that pertain to a particular cash position.
This worksheet displays details of customer receipts that pertain to a particular cash position.
This worksheet displays details for payroll expenses that pertain to a particular cash position.
This worksheet displays details of treasury transactions that pertain to a particular cash position.
This worksheet displays details of the intra-day transactions reported by the bank that pertain to a particular cash position.
Oracle Treasury's Legal Entity security secures cash position worksheets and cash position results for Oracle Treasury users. Only Oracle Treasury users have access to the sources of Treasury Inflow and Treasury Outflow for inclusion in a cash position. Similarly, only Oracle Treasury users have the option to include subsidiary's bank account balances in the cash position results when generating a cash position. In the cash position results, Oracle Cash Management displays only the transactions that belong to legal entities that the Treasury user has access to. Non-Treasury users will not have access to any Treasury transactions although they can still generate and view cash position results across all organizations.