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.

To generate a cash position from a new worksheet:

1. After you create a new worksheet, click Apply. See: Creating a Cash Position Worksheet

2. Click Generate Cash Position in the Confirmation page.

3. In the Generate Cash Position page select appropriate values for the submission parameters. See: Generate Cash Position Page Reference

4. Select Continue to generate the cash position.

To generate a cash position from an already existing worksheet:

1. Query an existing worksheet in the Cash Position Worksheet Search and Results page.

2. Select the Generate Cash Position icon corresponding to the worksheet you want to use.

3. In the Generate Cash Position page, select appropriate values for the submission parameters. See:Generate Cash Position Page Reference

4. Select Continue to generate the cash position.

Generate Cash Position Page Reference

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.