R12: AP: Payables Open Interface Import Program Is Failing Frequently With Error: ORA-00060: deadlock detected while waiting for resource
(Doc ID 2904840.1)
Last updated on OCTOBER 24, 2022
Applies to:
Oracle Payables - Version 12.0.0 and laterInformation in this document applies to any platform.
Symptoms
When attempting to import invoices using the Payables Open Interface Import Process, the following error occurs at least once per week:
The issue can be reproduced at will with the following steps:
1. Insert Invoice values into
AP_INVOICES_INTERFACE
AP_INVOICE_LINES_INTERFACE
2.. Using Payables Manager responsibility
3. Navigate to Invoices : Inquiry > Invoices
4. Select View >Requests > Submit a new Request >OK
5. In the Submit request Form, For name, Enter: Payables Open Interface Import >Tab.
6. Enter Required Parameters and select OK.
Changes
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 |
Changes |
Cause |
Solution |
References |