Batch Element Entry (BEE) Spreadsheet Interface > 10 Rows Fails with Error: 'SQL exception occured during PL/SQL Upload.' (Doc ID 388012.1)

Last updated on MAY 26, 2016

Applies to:

Oracle Payroll - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms

Problem Statement:

Using the BEE Spreadsheet Interface to upload element entries, when a batch is larger than 10 records, only the first 10 records load.  Have unprotected the spreadsheet, inserted additional rows and added data. For every row insert, in additional to the original, the import fails with the following:

SQL exception occurred during PL/SQL Upload.


 
STEPS TO REPRODUCE

  1. Create Batch
  2.  Mass Information eXchange: MIX
  3. BEE Spreadsheet Interface
  4. Query Batch
  5. Choose element
  6. Export Template
  7. Unprotect spreadsheet
  8. In the batch area, choose insert > rows
  9. Complete spreadsheet with batch data
  10. Oracle > Upload


Note:
Been able to successfully import a batch; however only the first 10 records will load. It appears the template is not copying the macros onto the inserted rows.

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