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 OCTOBER 12, 2020
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.
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