RVCTP Errors with "The value Specified XXXXXXX is invalid. (COLUMN=ITEM_NUM)" and RCV_INVALID_ROI_VALUE_NE (Doc ID 2085317.1)

Last updated on DECEMBER 18, 2015

Applies to:

Oracle Inventory Management - Version 12.0.0 to 12.2.5 [Release 12.0 to 12.2]
Information in this document applies to any platform.

Symptoms

When performing receipts via Receiving Open Interface,  The following error occurs.

ERROR
-----------------------
The value specified 8126157 is invalid. (COLUMN=ITEM_NUM) on column ITEM_NUM

STEPS
-----------------------
a. Use Receiving Open Interface ROI features to populate ROI interface tables RCV_HEADERS_INTERFACE and RCV_TRANSACTIONS_INTERFACE.
    make sure ITEM_NUM is populated.

b. Run Receiving Transaction Processor.

c. Receiving Transaction Processor RVCTP log file shows:

[02-DEC-15 15:58:51] po.plsql.RCV_TABLE_FUNCTIONS.RCV_TABLE_FUNCTIONS.81:         Updating RHI HEADER_INTERFACE_ID=887288
[02-DEC-15 15:58:51] po.plsql.RCV_TABLE_FUNCTIONS.RCV_TABLE_FUNCTIONS.end_implicit:       ^--------Implicit Procedure Exit-----^
[02-DEC-15 15:58:51] po.plsql.RCV_DEFAULT_PKG.RCV_DEFAULT_PKG.231:       Elapsed Time:       0,Absolute Time:    1953242238 - BEGIN default_transaction
[02-DEC-15 15:58:51] po.plsql.RCV_DEFAULT_PKG.RCV_DEFAULT_PKG.7201:       rti.interface_transaction_id = 3805422
[02-DEC-15 15:58:51] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.begin:       v--------Procedure Started-----------v
[02-DEC-15 15:58:51] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.214:         set error message token = RCV_INVALID_ROI_VALUE_NE
[02-DEC-15 15:58:51] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.215:         error stack from call to set_error_message
[02-DEC-15 15:58:51] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.-1:         Current Calling Stack = ?                   RVTBM.C             RCV_NORMALIZE_DATA_PRCV_DEFAULT_PKG     RCV_ERROR_PKG      
[02-DEC-15 15:58:51] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.-1:         ----- PL/SQL Call Stack -----
 object      line  object
 handle    number  name
000007FFC0682AC8       109  package body APPS_APPLMGR.ASN_DEBUG
000007FFD478EB90       216  package body APPS_APPLMGR.RCV_ERROR_PKG
000007FFD73EAF80       180  package body APPS_APPLMGR.RCV_DEFAULT_PKG
000007FFD73EAF80       915  package body APPS_APPLMGR.RCV_DEFAULT_PKG
000007FFD73EAF80      2067  package body APPS_APPLMGR.RCV_DEFAULT_PKG
000007FFD73EAF80      7232  package body APPS_APPLMGR.RCV_DEFAULT_PKG
000007FFCC513930       117  package body APPS_APPLMGR.RCV_NORMALIZE_DATA_PKG
000007FFCC513930       821  package body APPS_APPLMGR.RCV_NORMALIZE_DATA_PKG
000007FFD15E3908         1  anonymous block

[02-DEC-15 15:58:52] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.71:         logging error The value specified 8126157 is invalid. (COLUMN=ITEM_NUM) on column ITEM_NUM

  

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