No Receiving Transactions Created after Work Confirmation has been Approved
(Doc ID 1940963.1)
Last updated on FEBRUARY 11, 2021
Applies to:Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
After Workflow Confirmation Approval, there is no data in Receiving Transactions table.
When checking the Purchase Order in Find Receiving Transactions form, the system returns APP-PO-14094 No records meet your search criteria
However, when checking the Approval Status in RCV_SHIPMENT_HEADERS and RCV_SHIPMENT_LINES tables we can observe the column APPROVAL_STATUS is APPROVED
Expect if a Work Confirmation is approved, and RCV_SHIPMENT_HEADERS and RCV_SHIPMENT_LINES APPROVAL_STATUS is APPROVED, then Receiving Transaction records are created in RCV_TRANSACTIONS table
The issue can be reproduced at will with the following steps:
1. Create a Work Confirmation
2. Approve the Work Confirmation
3. RCV_SHIPMENT_HEADERS and RCV_SHIPMENT_LINES APPROVAL_STATUS is APPROVED
4. No Data in RCV_TRANSACTIONS exists for the related PO
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