My Oracle Support Banner

No Receiving Transactions Created after Work Confirmation has been Approved (Doc ID 1940963.1)

Last updated on JULY 02, 2018

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

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

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

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

Cause

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
Symptoms
Cause
Solution
References


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