My Oracle Support Banner

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

Last updated on MARCH 20, 2019

Applies to:

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


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:


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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.