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 laterInformation 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 |