Error FRM-40212: Invalid OE_ORDER_NUM When Attempting to Find a Corrected RMA to Receive or Deliver (Doc ID 1487864.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Inventory Management - Version 11.5.10.CU2 to 12.2.3 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.

Symptoms

When attempting to find corrected RMA to receive or deliver the following error occurs:

Error

 
Steps
The issue can be reproduced at will with the following steps:

A) OM responsibility
Orders, Returns > Order Organizer
Search for RMA Order Number 
Status of line is Awaiting Return Disposition

Htomse11i output from <Note 133464.1> shows
OE_ORDER_LINES (LIN)
LINE 1.1
LINE_ID 143382
DELIVERY DETAIL   
FLOW CODE AWAITING_RETURN_DISPOS
OP Y
BK Y
SH Y
CN N

WORKFLOW LINE STATUS
LIN_ID PROCESS_NAME ACTIVITY_NAME RESULT ACT_STATUS INT_PROCESS_NAME INT_ACTIVITY_NAME 
....
143382 Return Receiving - Line Start Null Complete RMA_RECEIVING_SUB START 
143382 Return Receiving - Line Utility to Get Line Category Return Complete RMA_RECEIVING_SUB UTIL_GET_LINE_CATEGORY 
143382 Return Receiving - Line Wait for receiving Complete Complete RMA_RECEIVING_SUB RMA_WAIT_FOR_RECEIVING
143382 Return Receiving - Line Wait for inspection Notified RMA_RECEIVING_SUB RMA_WAIT_FOR_INSPECTION


B) Inventory responsibility
1. Navigate to Receiving > Receipts RCVRCERC form
2. Customer tab
3. Enter RMA number for search criteria.
4. Click on Find button

C) The same error occurs on Receiving > Receiving Transactions form RCVTXERT 
when trying to find the RMA line to deliver.

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