Detail Client Data Loader: Unable to Generate Any Data Slices with the Program Parameters (Doc ID 307818.1)

Last updated on JUNE 27, 2007

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.9 to 11.5.10
This problem can occur on any platform.
Oracle Enterprise Planning and Budgeting (EPB) - Version: 11.5.10
FEM

Symptoms

When running the the Detail Client Data Loader to load data into a FEM_DATAx table, no rows are loaded and the following message appears in the Request Log:

The request was run with the following parameters:

CALP_DIM_GRP_DISPLAY_CODE: <value> (ex. Month)
CAL_PERIOD_NUMBER: <value> (ex. 2)
CAL_PERIOD_END_DATE: <value> (ex. 28-FEB-03)
LEDGER_DISPLAY_CODE: <value> (ex.Support Ledger)
DATASET_DISPLAY_CODE: <value> (ex. ACTUALS)
SOURCE_SYSTEM_DISPLAY_CODE: <value> (ex. OFA)
TABLE_NAME : FEM_DATAx

The execution mode is 'S'.

The FEM Multiprocessing Framework was unable to generate any data slices with the program parameters. In most cases, this is due to no row in the interface table that matches with the parameters entered for this execution. It is also possible that the data slicing column(s) had NULL values.

The execution mode is 'S'. If this is a Snapshot ('S') run, only those rows where STATUS is 'LOAD' will be processed. If this is an Error Reprocessing ('E') run, only those rows where STATUS is not 'LOAD' will be processed. If this is a Replacement ('R') run, rows are processed regardless of the STATUS value. (DIM_GRP=Month) (PER_NUM=2) (END_DATE=28-FEB-2003 00:00:00) (LEDGER_DC=Support Ledger) (DATASET_DC=ACTUALS) (SOURCE_DC=OFA)
0 rows loaded successfully.
0 rows failed to load successfully.

The execution produced errors. Correct the errors and rerun.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms