PRC: POR: Exception Occurred During Requisition Import: ORA-06533: Subscript Beyond Count (Doc ID 2887691.1)

Last updated on AUGUST 04, 2022

Applies to:

Symptoms

While Importing Requisitions getting below error:
Exception occurred during Requisition Import: JBO-29000: Unexpected exception caught: java.sql.SQLException, msg=ORA-06533: Subscript beyond count. For few number of records(tried for 10 rows) able to import, but for 100 records getting this error. Please find attached zip FBDI file which is used for importing requisitions.

ERROR
-----------------------

Exception occurred during Requisition Import: ORA-06533: Subscript beyond count


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Prepare FBDI file for Creating 100 Requisitions
2. Load the data into interface
3. Import the data-ends in failure
4. When FBDI is loaded for only 10 Requisitions, Import goes through fine.

Cause

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