WebADI Spreadsheet Load Completes with No Errors But Not All Rows Loaded into FEM_BALANCES (Doc ID 1316281.1)

Last updated on MAY 18, 2017

Applies to:

Oracle Enterprise Performance Foundation - Version 12.0.6 and later
Information in this document applies to any platform.
External General Ledger Data Loader

Symptoms

In Oracle Enterprise Performance Foundation Administrator (FEM) 12.0.6, when you try to load data into FEM_BALANCES using the WebADI Spreadsheet Load, the spreadsheet upload indicates that all rows are uploaded successfully but the concurrent request log for the related "External General Ledger Data Loader" shows that the rows were only partially loaded.  While the log indicates that no rows failed to load, many rows included in the spreadsheet do not exist in FEM_BALANCES.  For example, there were 3,500 rows in the spreadsheet but the log indicates that only 1,400 rows are loaded successfully.  So, over 2,000 rows fail to load into FEM_BALANCES but there are no errors indicating where or why the process failed.  Additionally, there are no rows from the upload left in the FEM_BAL_INTERFACE_T intermediate load table.

In the example:

Spreadsheet Load: "Messages" column indicates that all 3,500 rows are uploaded successfully into FEM_BAL_INTERFACE_T.

Interface Table Load: "External General Ledger Data Loader" log shows all rows loaded successfully but only 1,400 rows loaded.

It is unknown how many rows were actually loaded into FEM_BAL_INTERFACE_T by the Spreadsheet Upload process.

Steps to Reproduce:

  1. Go to the Enterprise Performance Foundation Administrator responsibility
  2. Go to Process Management > Spreadsheet Load
  3. Select Upload Item = Table and select FEM_BALANCES
  4. Click on Launch spreadsheet
  5. Populate the spreadsheet with 3,500 rows
  6. Select Add-In > Oracle > Upload to upload the spreadsheet rows into the FEM_BAL_INTERFACE_T table and execute the load process

When you review the View Log of the "External General Ledger Data Loader" program request executed by the Spreadsheet Upload, only 1,400 rows are actually loaded into FEM_BALANCES but there are no errors listed in the "Messages" column of the spreadsheet.

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