Batch Element Entry (BEE) Spreadsheet Interface > 10 Rows Fails with Error: 'SQL exception occured during PL/SQL Upload.'
Last updated on OCTOBER 31, 2017
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.
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