Previous	Next		Contents	Index	Navigation	Glossary	Library

1. Determine external forecast source types and their selection criteria. See: Define External Source Types and Selection Criteria.

2. Define value sets to be used for the selection criteria segments. See: Define Value Sets for Selection Criteria.

3. Define the Forecast Selection Criteria Descriptive Flexfield segments for each selection criteria. See: Define Forecast Selection Criteria Descriptive Flexfield

4. Define the external forecast source transaction database views. See: Define External Source Views

5. Associate the external source types with the views, and if necessary, the name of the database link. See: Associate External Forecast Source Types with Views

Define External Source Types and Selection Criteria

1. Determine the external source types that you want to include in your cash forecasts.

2. Determine appropriate selection criteria for each type.

3. Identify the selection criteria common to all external source types.

4. Identify the selection criteria appropriate only for specific external source types.

5. Design the use of criteria segments.

Use the Descriptive Flexfields worksheets located in the appendix of the Oracle Applications Flexfields Guide to help you with your design.

See Also

Defining Descriptive Flexfield Structures (Oracle Applications Flexfields Guide)

Descriptive Flexfield Segments Window (Oracle Applications Flexfields Guide)

Context Field Values (Oracle Applications Flexfields Guide)

Define Value Sets for Selection Criteria

1. Navigate to the Value Sets window (Descriptive Flexfield Segments window > Segments button > Value Sets button).

2. Define your value set and give it a validation type, and enter the appropriate validation information to suit your selection criteria.

See Also

Define Forecast Selection Criteria Descriptive Flexfield Segments

1. Navigate to the Descriptive Flexfield Segments window.

2. Enter Oracle Cash Management in the Application field, and Forecast Selection Criteria in the Title field.

3. Uncheck the Freeze Flexfield Definition check box.

4. Refer to the worksheet you filled out in designing your descriptive flexfield.

• Include the common selection criteria that are applicable to all external source types.

• Specify external source types in the Context Field region.

• For each external source type defined as a context field value, define the criteria segments that are used by the specific external source type as the context-sensitive segments. These are the selection criteria that depend on the external source types.

• All segments must be enabled and non-required.

• Choose the value sets that you predefined in the Value Set field.

• Do not update any existing default entries.

5. Check the Freeze Flexfield Definition check box and save your work.

Define External Source Views

Alternatively, if your proprietary application system does not support real-time access from an Oracle database, you can create a table for the External Source Transaction View, and use SQL*Loader or another batch mechanism to populate the table with information from the non-Oracle system transactions.

Column specifications for the External Source Transaction View are outlined in the following table:

Column Name	Type	Required?	Description/Value
ROW_ID	ROWID	Yes	Row ID
TRANSACTION_AMOUNT	NUMBER	Yes	Amount in transaction currency
FUNCTIONAL_AMOUNT	NUMBER	Yes	Amount in functional currency
CURRENCY_CODE	VARCHAR2(15)	Yes	Transaction currency code, must be valid currency code defined in FND_CURRENCIES
FUNCTIONAL_CURRENCY	VARCHAR2(15)	Yes	Functional currency code, must be valid currency code defined in FND_CURRENCIES
CASH_ACTIVITY_DATE	DATE	Yes	Projected cash transaction date, date when the transaction has become or will become a cash transaction (e.g. check date)
CRITERIA1...15	VARCHAR2(150)	No	Selection criteria
Table 1 - 2. (Page 2 of 2)

Note: Organization ID is not included as a default criterion. However, if you want to select transactions for a specific organization, you can define it as a common selection criterion for all external source types.

If your environment includes a distributed source transaction type, either you must import remote data to the local database, or you must establish a database link from the local database to the remote database. See: Associate External Forecast Source Types with Views

Using Remote Databases

• cefextmp.sql

• cefremts.pls

• cefremtb.pls

Use of Indexes on Views

Associate External Forecast Source Types with Views

   To associate external forecast source types and views:

1. Navigate to the External Forecast Sources window.

2. Choose an external forecast source Type. The list of values is the context field of the Forecast Selection Criteria Descriptive Flexfield.

3. Enter an external forecast source View. This field is not validated until you submit a forecast that uses the associated external forecast source type.

4. (Optional) Enter a Database Link Name if the source type is on a remote database. The list of values includes currently available links, but you can enter others as this field is not validated until you submit a forecast that uses the associated external forecast source type.

See Also