POXPOPDOI: Import Standard Purchase Order Can Not be Approved and Err with PO_REQAPPROVAL_INIT1.REGISTER_DOC_SUBMITTED error msg: ORA-00060: deadlock detected while waiting for resource (Doc ID 2000378.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Approvals - Req, PO

To create Purchase Orders (POs) coming from a legacy system into R12, a custom request set is used to populate the interface files:  po_headers_interface, po_lines_interface and po_distributions_interface.  The POXPOPDOI module: Import Standard Purchase Orders is then launched, but the imported purchase orders cannot be approved as an exception occurs during the activity PDOI_AUTO_APPROVE/UPDATE_HEADERS_WITH_ITEMTYPE. For these POs the following errored activities are generated:

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Populate data in the po_headers_interface, po_lines_interface and po_distributions_interface tables.
2. Run POXPOPDOI module: Import Standard Purchase Orders.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users need to run Retry Errored Workflow Activities program to process the imported and stuck POs.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms