My Oracle Support Banner

RMA Stuck With Awaiting Return Disposition; FRM-40212: Invalid value for field OE_ORDER_NUM (Doc ID 339794.1)

Last updated on SEPTEMBER 16, 2019

Applies to:

Oracle Order Management - Version 11.5.1 to 11.5.10.3 [Release 11.5.1 to 11.5.10]
Information in this document applies to any platform.
FORM:OEXOEORD.FMB - Sales Orders

Symptoms

Find a RMA is stuck in Awaiting Return status and the flow code in HTMomse11i output is : AWAITING_RETURN_DISPOS

When try to Inspect the RMA item via: 
    Purchasing Responsibility
    Receiving/Receiving Transactions
    Click on Customer Tab
    Enter the RMA number   
    Click Find

Receive error: 

FRM-40212:  Invalid value for field  OE_ORDER_NUM

Also, data corruption observed in case of RMA. User received the qty into inventory but RMA Line is stuck in "AWAITING_RETURN" or "AWAITING_RETURN_DISPOSITION" statuses

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.