My Oracle Support Banner

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 OCTOBER 02, 2019

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

Diagnostic shows
OE_ORDER_LINES (LIN)
LINE 1.1
LINE_ID ####
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 
....
#### Return Receiving - Line Start Null Complete RMA_RECEIVING_SUB START 
#### Return Receiving - Line Utility to Get Line Category Return Complete RMA_RECEIVING_SUB UTIL_GET_LINE_CATEGORY 
#### Return Receiving - Line Wait for receiving Complete Complete RMA_RECEIVING_SUB RMA_WAIT_FOR_RECEIVING
#### 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.

Changes

 

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
Changes
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.