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.