Cannot Find Receipt To Deliver FRM-40212 RECEIPT_NUM On RCVTXERT / Parent Quantity ZERO On RCVTXECO (Doc ID 1682249.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Inventory Management - Version 12.0.6 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.

Symptoms

Find it is not possible to find one GRN to accept / Receipt for Purchase Order.
 
When searching on Receiving Transactions form for Receipt = 9999 to accept or deliver, get error:


When seeing transactions on Corrections form, there are Receive and Transfer transactions. All records appear with 0 Parent Qty.

It has been checked per <Note 1622366.1> that no records are stuck in RCV_TRANSACTIONS_INTERFACE table.

Steps
The issue can be reproduced at will with the following steps:
 
Navigate to Receiving Transactions RCVTXERT form > Find Transactions  form
Search for Receipt = 9999
Get FRM-40212: Invalid value for field RECEIPT_NUM
 
Navigate to  Receiving Corrections RCVTXECO form and can be seen the following transactions for Receipt = 9999 :
Receive
Transfer
Transactions
 
Both have Parent Qty = 0 

Cause

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