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:

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

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