How You Set Up Cash Positioning and Forecasting
Use the following to set up your cash positioning and forecasting reporting requirements:
-
Specify Cash Positioning and Forecasting Options
-
Manage Cash Positioning and Forecasting Transaction Grouping
Specify Cash Positioning and Forecasting Options
Use the options page to define the extraction period used to transfer data to the Essbase cube. Transactions with transaction dates within that period are extracted to the cube. You can also select different GL accounting calendars to lay out the time dimension structure in the cubes.
Configure the following options:
Field Name |
Available Values |
Default Value |
---|---|---|
Extraction Duration |
|
Last 2 years |
Reporting Currency |
List of currencies defined in the application |
USD - US Dollars |
Balance Code |
Internal Balance Codes lookups (LOV) |
Closing booked |
Balance Date Threshold Days |
Number days defined before a missing bank statement is reported |
2 |
Transaction Calendar |
List of transaction calendars defined in the application, if not defined, everyday (7) is considered a business day. |
No default |
Time Periods |
List of accounting calendars defined in the application |
No default |
Once the cube is created and locked, the update is disabled in this page. You can't update the cube until you submit the Cash Position Data Deletion program to clear the details in the cube.
Manage Cash Positioning and Forecasting Transaction Grouping
You create or edit configurable dimensions for cash positioning and forecasting from this page. You must have the Manage Cash Positioning and Forecasting Transaction Grouping privilege (ORA_CE_MANAGE_CASH_POSITIONING_AND_FORECASTING_TRANSACTION_GROUPING_PRIV) to access the Create or Edit Cash Position Dimension page:
-
Search for the configurable dimensions defined in the application.
-
Create configurable dimensions to meet your company-specific requirements
-
Modify and edit configurable dimensions to meet reporting requirements.
-
Entering a description is optional but recommended.
The following table contains the fields to be completed:
Field Name |
Description |
---|---|
Name |
Required and must be unique |
Application |
Required and valid values are Oracle Fusion Applications or Other. |
Source |
Required and the following are possible values:
|
Source Table |
List of tables from the selected Application and Source |
Source Column |
List of the columns from the selected Source Table. |
Once the cube is created and locked, you can't update this page. You must submit the Cash Position Data Deletion program to clear the details in the cube to do an update.