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.


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:

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.

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.


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