R12: AP: APXIIPRG - When Attempting To Run Payables Open Interface Purge Concurrent Program, Getting Errror ' ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired ORA-01001 '
(Doc ID 2955079.1)
Last updated on JULY 19, 2023
Applies to:
Oracle Payables - Version 12.0.0 to 12.2.12 [Release 12.0 to 12.2]Information in this document applies to any platform.
Symptoms
When attempting to run Payables Open Interface Purge concurrent Program,
the concurrent Request Log file shows the following error:
ERROR MESSAGE
--------------------------
MSG-00003: (Import_purge ) Deleting records in interface tables...
MSG-00999: (Import_purge ) Open purge_invoices cursor
MSG-00999: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
MSG-00999: (Import_Purge:Exception) The invoices to be selected by this process are locked by the user
MSG-00999: Delete record in control table..
MSG-00999: ORA-01001: invalid cursor
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
REP-1419: 'beforereport': PL/SQL program aborted.
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error
MSG-00999: (Import_purge ) Open purge_invoices cursor
MSG-00999: ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
MSG-00999: (Import_Purge:Exception) The invoices to be selected by this process are locked by the user
MSG-00999: Delete record in control table..
MSG-00999: ORA-01001: invalid cursor
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
REP-1419: 'beforereport': PL/SQL program aborted.
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error
STEPS
-------------------
The issue can be reproduced at will with the following steps:
1. Navigate to the Payables Responsibility
2. Go to the Standard Request Submission screen:: Other > Requests > Run
3. Submit concurrent "Payables Open Interface Purge" concurrent program
4. Observed error message displayed in the concurrent log file
Cause
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
Symptoms |
Cause |
Solution |
References |