Error When Receiving PO Through Interface ROI (COLUMN=SHIPMENT_HEADER_ID) RCV_INVALID_ROI_VALUE_NE (Doc ID 1942077.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On :  12.1.3 version, Receiving Functions

When trying to create ROI receipts for PO lines the following errors are seen in po_interface_errors:


Steps
The issue can be reproduced at will with the following steps: .
a. Maximo application is integrated with Oracle application

Use Receiving Open Interface ROI features to populate ROI interface tables rcv_header_interface (RHI), rcv_transactions_interface (RTI)  

b. Run Receiving Transaction Processor.

c. Rcv11i output from <Note 402245.1> ran for PO 37587 shows :

RCV_HEADERS_INTERFACE
HEADER_INTERFACE_ID 469044
GROUP_ID 100
PROCESSING_STATUS_CODE ERROR
RECEIPT_SOURCE_CODE VENDOR
ASN_TYPE
TRANSACTION_TYPE NEW
RECEIPT_NUM Null
RECEIPT_HEADER_ID Null
VENDOR_ID 57062
SHIP_TO_ORGANIZATION_ID 572 
VALIDATION_FLAG Y
ORG_ID 428

RCV_TRANSACTIONS_INTERFACE
INTERFACE_TRANSACTION_ID 876812
GROUP_ID 100
TRANSACTION_TYPE RECEIVE
PROCESSING_STATUS_CODE ERROR
PROCESSING_MODE_CODE BATCH
QUANTITY 1
ITEM_ID 560158
AUTO_TRANSACT_CODE DELIVER
SHIPMENT_HEADER_ID 581528
SHIPMENT_LINE_ID
RECEIPT_SOURCE_CODE VENDOR
TO_ORGANIZATION_ID 572
SOURCE_DOCUMENT_CODE PO
PO_HEADER_ID 819733
HEADER_INTERFACE_ID 469047
DOCUMENT_NUM 37587
DOCUMENT_LINE_NUM 14
VALIDATION_FLAG Y
ORG_ID 428

PO_INTERFACE_ERRORS
INTERFACE_TYPE RCV-856
COLUMN_NAME SHIPMENT_HEADER_ID
ERROR_MESSAGE Error: The value specified 581528 is invalid. (COLUMN=SHIPMENT_HEADER_ID)
ERROR_MESSAGE_NAME RCV_INVALID_ROI_VALUE_NE
TABLE_NAME RCV_HEADERS_INTERFACE
BATCH_ID 100
INTERFACE_HEADER_ID 469047
INTERFACE_LINE_ID 876812

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