ORA-12801: error signaled in parallel query server P000 ORA-01460 ORA-29 Running Concurrent Requests (Doc ID 2936832.1)

Last updated on AUGUST 29, 2023

Applies to:

Symptoms

On : 12.2.x version, Concurrent Manager Issues

ORA-12801: error signaled in parallel query server P000 ORA-01460 ORA-29 w/Conc Programs
Seeing the following errors in the request logs. Happening for both seeded and custom programs.
Already have FND_FILE enabled as expected. DB parameter temp_undo_enabled set to FALSE and
event='10946 trace name context forever, level 8454144'


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

Enter Password:
MSG-00101: Error occured in BATCH_APPROVAL()
MSG-00102: Error Code : -20100
MSG-00103: Error Message : ORA-20100: ORA-20100: ORA-00604: error occurred at recursive SQL level 1
ORA-12801: error signaled in parallel query server P000
 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Run programs and unexpectedly received errors for all programs

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Production concurrent processing is down

Changes

Cause

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