My Oracle Support Banner

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



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


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