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
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