Detail Client Data Loader ORA-00936: missing expression Error Processing With Replacement Mode

(Doc ID 373080.1)

Last updated on FEBRUARY 20, 2008

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.9 to 11.5.10
FEM
Detail Client Data Loader
This problem can occur on any platform.

Symptoms

When running the Detail Client Data Loader for a FEM_DATAx table using the FEM.D.1 'Execution Mode' = 'Replacement', the following errors occur:

ERROR

The request was run with the following parameters: 

CALP_DIM_GRP_DISPLAY_CODE: Month
CAL_PERIOD_NUMBER: 2
CAL_PERIOD_END_DATE: 28-FEB-03
LEDGER_DISPLAY_CODE: Support Ledger
DATASET_DISPLAY_CODE: ACTUALS
SOURCE_SYSTEM_DISPLAY_CODE: FEM
TABLE_NAME : FEM_DATA5

The execution mode is 'R'.

0 rows loaded successfully.
0 rows failed to load successfully.

The execution produced errors. Correct the errors and rerun.

From the sub-process log file:

An unexpected error has occurred: ORA-00936: missing expression. Please contact your System Administrator. 

Parent request 3276093
Sub-request 3276094 : Engine program aborted before completing

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