Spreadsheet Load Fails in 12.1.2 with Execution Mode or Invalid Parameter Errors (Doc ID 1126361.1)

Last updated on JUNE 30, 2010

Applies to:

Oracle Enterprise Performance Foundation - Version: 12.1.2 to 12.1.2
Information in this document applies to any platform.

Symptoms

In Enterprise Performance Foundation Administrator, version 12.1.2, when you use the Spreadsheet Load utility to load data into a FEM_DATAx table, the concurrent request generated for the Detail Client Data Loader ends in an error. The following is in the View Log:

Execution mode 'Snapshot' must be either Snapshot ('S'), Error Reprocessing ('E') or Replacement ('R').

The request was run with the following parameters:

CALP_DIM_GRP_DISPLAY_CODE:
CAL_PERIOD_NUMBER:
CAL_PERIOD_END_DATE:
LEDGER_DISPLAY_CODE:
DATASET_DISPLAY_CODE:
SOURCE_SYSTEM_DISPLAY_CODE:
TABLE_NAME : FEM_DATA2

The execution mode is 'Snapshot'.

The execution produced errors. Correct the errors and rerun.

Similarly, if you use the Spreadsheet Upload utility to populate FEM_BALANCES, the concurrent request generated for the External General Ledger Data Loader ends in an error. The following is in the View Log:

Validating parameters...

Invalid parameter. Value not found. Parameter Name: P_QTD_YTD_CODE (Period Specific Amounts Provided)

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

The loading process produced errors. Please correct the errors and re-submit the load.


Note that the WebADI spreadsheet upload completes successfully. An Upload Parameter of Snapshot was selected when uploading data from the spreadsheet.

Steps to Reproduce:
  1. Go to the Enterprise Performance Foundation Administrator responsibility
  2. Go to Process Management > Spreadsheet Load
  3. Select "Table" = "FEM DataX" or "Balances"
  4. Click "Launch Spreadsheet"
  5. Populate a single row in the spreadsheet
  6. Go to Upload the spreadsheet data
  7. In the Upload Parameters screen, select Exec Mode of Snapshot and launch the load.  The Upload is successful.
  8. Go to Process Management > Requests > View Requests
The related concurrent request ends with one of the errors listed above.

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