My Oracle Support Banner

PO_INTERFACE_ERRORS RCV_TRANSACTIONS_INTERFACE RCV-856 LINE_NUM The value specified 1 is invalid. (COLUMN=LINE_NUM) (Doc ID 2754997.1)

Last updated on FEBRUARY 23, 2021

Applies to:

Oracle Inventory Management - Version 12.2.3 and later
Information in this document applies to any platform.
select b.document_shipment_line_num,b.document_line_num,b.INTERFACE_TRANSACTION_ID,
a.interface_type, a.column_name, a.error_message,b.SHIPMENT_HEADER_ID, b.SHIPMENT_LINE_ID
from PO_INTERFACE_ERRORS a, RCV_TRANSACTIONS_INTERFACE b
where a.ERROR_MESSAGE = 'Error: The value specified 1 is invalid. (COLUMN=LINE_NUM)'
and a.ERROR_MESSAGE_NAME = 'RCV_INVALID_ROI_VALUE_NE'
and a.TABLE_NAME = 'RCV_HEADERS_INTERFACE'
and b.AUTO_TRANSACT_CODE = 'DELIVER'
and a.INTERFACE_LINE_ID = b.INTERFACE_TRANSACTION_ID
and b.DOCUMENT_LINE_NUM IS NOT NULL
and b.DOCUMENT_SHIPMENT_LINE_NUM IS NOT NULL
and (b.shipment_header_id IS NULL
or (b.shipment_header_id IS NOT NULL
and not exists (select 1 from RCV_SHIPMENT_LINES RSL
where RSL.SHIPMENT_HEADER_ID = b.SHIPMENT_HEADER_ID
and RSL.SHIPMENT_LINE_ID = b.SHIPMENT_LINE_ID
)
))

Symptoms

On : 12.2.3 version, MICC Transfer to TSC

Processing an ASN

ERROR
-----------------------
Error: The value specified 1 is invalid. (COLUMN=LINE_NUM)

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Purchasing> ASN> receiving

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot process with out error

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.