My Oracle Support Banner

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 MAY 12, 2021

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.


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

The value specified XXXXXX is invalid. (COLUMN=ITEM_NUM) on column ITEM_NUM

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

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





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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.