DATAFIX: RMA Receipt Error ROI: Derivation Error: &COLUMN_NAME (VALUE= &VALUE) specified is invalid.

(Doc ID 2321858.1)

Last updated on OCTOBER 31, 2017

Applies to:

Oracle Order Management - Version 12.1 to 12.2 [Release 12.1 to 12.2]
Oracle Inventory Management - Version 12.1.2 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

Problem Statement
When attempting to receive RMA,
the following error occurs.

Error
Below error is found in PO_INTERFACE_ERRORS table.

COLUMN_NAME OE_ORDER_HEADER_ID
ERROR_MESSAGE    Error: Derivation Error: &COLUMN_NAME (VALUE= 1658944) specified is invalid.


Steps to Reproduce
This issue cannot be reproduced at will.
This issue only occurs to some specific RMA.

Receiving Transaction Processor Debug log

[01-SEP-17 10:42:05] po.plsql.RCV_RMA_TRANSACTIONS.RCV_RMA_TRANSACTIONS.1214: oe_order_header_id: XXX
[01-SEP-17 10:42:05] po.plsql.RCV_RMA_TRANSACTIONS.RCV_RMA_TRANSACTIONS.1215: item_id: YYY
[01-SEP-17 10:42:05] po.plsql.RCV_RMA_TRANSACTIONS.RCV_RMA_TRANSACTIONS.1216: oe_order_line_num: 1
[01-SEP-17 10:42:05] po.plsql.RCV_RMA_TRANSACTIONS.RCV_RMA_TRANSACTIONS.1217: to_organization_id: ZZZ
[01-SEP-17 10:42:05] po.plsql.RCV_RMA_TRANSACTIONS.RCV_RMA_TRANSACTIONS.1218: customer_item_num:
[01-SEP-17 10:42:05] po.plsql.RCV_RMA_TRANSACTIONS.RCV_RMA_TRANSACTIONS.1477: Hit exit condition
[01-SEP-17 10:42:05] po.plsql.RCV_RMA_TRANSACTIONS.RCV_RMA_TRANSACTIONS.1478: Temp table size 0
[01-SEP-17 10:42:05] po.plsql.RCV_RMA_TRANSACTIONS.RCV_RMA_TRANSACTIONS.1479: Rows fetched 0
[01-SEP-17 10:42:05] po.plsql.RCV_RMA_TRANSACTIONS.RCV_RMA_TRANSACTIONS.1487: No rows were retrieved from cursor.
[01-SEP-17 10:42:05] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.begin: v--------Procedure Started-----------v
[01-SEP-17 10:42:05] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.214: set error message token = PO_PDOI_DERV_ERROR
[01-SEP-17 10:42:05] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.215: error stack from call to set_error_message
[01-SEP-17 10:42:05] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.-1: Current Calling Stack = ? RVTBM.C RCV_ROI_PREPROCESSORRCV_RMA_TRANSACTIONSRCV_ERROR_PKG
[01-SEP-17 10:42:05] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.-1: ----- PL/SQL Call Stack -----
object line object
handle number name
0x4cd616c80 109 package body APPS.ASN_DEBUG
0x4bd4c2148 216 package body APPS.RCV_ERROR_PKG
0x4bd4c2148 227 package body APPS.RCV_ERROR_PKG
0x4b77f7f70 1593 package body APPS.RCV_RMA_TRANSACTIONS
0x4b77f7f70 347 package body APPS.RCV_RMA_TRANSACTIONS
0x4bd023c20 1853 package body APPS.RCV_ROI_PREPROCESSOR
0x4bd023c20 826 package body APPS.RCV_ROI_PREPROCESSOR
0x4be12fee8 1 anonymous block

[01-SEP-17 10:42:05] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.71: logging error Derivation Error: &COLUMN_NAME (VALUE= XXX) specified is invalid. on column OE_ORDER_HEADER_ID
[01-SEP-17 10:42:05] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.36: error stack from call to po_interface_call
[01-SEP-17 10:42:05] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.-1: Current Calling Stack = ? RVTBM.C RCV_ROI_PREPROCESSORRCV_RMA_TRANSACTIONSRCV_ERROR_PKG
[01-SEP-17 10:42:05] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.-1: ----- PL/SQL Call Stack -----

 

Changes

 

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