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 07, 2020
Applies to:Oracle Payroll - Version 12.0.0 and later
Information in this document applies to any platform.
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:
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
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.
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