My Oracle Support Banner

'ORA-06512' Error Reported while Running Job with Over 100 Input Files (Doc ID 1435269.1)

Last updated on AUGUST 03, 2020

Applies to:

Oracle Retail Store Inventory Management - Version and later
Information in this document applies to any platform.


In Store Inventory Management (SIM), when batch is run with over 100 input files (for 100 different stores), the batch aborts with the following error:


531836633[ERROR]ORA-06512: at "SYS.UTL_FILE", line 536
ORA-06512: at "SIM.RESA_FILE_PARSER", line 625

 Steps to Reproduce:

1. Process 100 input POSU file as follows:
    a. For each input file, kick off the batch.
    b. Process 10 files at a time.
2. The error can be observed after processing 60 files.




To view full details, 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 a vibrant support community of peers and Oracle experts.