My Oracle Support Banner

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

Last updated on APRIL 04, 2025

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

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.