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 JULY 17, 2024
Applies to:
Oracle Payroll - Version 12.0.0 and laterInformation 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
- Create Batch
- Mass Information eXchange: MIX
- BEE Spreadsheet Interface
- Query Batch
- Choose element
- Export Template
- Unprotect spreadsheet
- In the batch area, choose insert > rows
- Complete spreadsheet with batch data
- 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 |