1. Implementing Payables Invoice to Pay
  2. How You Set Up Cash Positioning and Forecasting

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 3 months

  • Last 6 months

  • Last 1 year

  • Last 2 years

  • Last 3 years

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
Note: 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:

  • Payables invoices

  • Payables payments

  • Receivables receipts

  • Receivables transactions

  • Bank statement

  • External cash transactions

Source Table

List of tables from the selected Application and Source

Source Column

List of the columns from the selected Source Table.
Note: 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.

Related Topics