My Oracle Support Banner

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 DECEMBER 09, 2022

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

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
Symptoms
Cause
Solution

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