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 FEBRUARY 21, 2022

Applies to:

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

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