ROI RCVTP Error: The PO_LINE_ID Specified Is Invalid. RCV_INVALID_ROI_VALUE (Doc ID 1522585.1)

Last updated on MAY 01, 2023

Applies to:

Symptoms

When attempting to reprocess some Receiving Open Interface (ROI_ receipt transactions for standard purchase orders
following instructions of <Note 605300.1> the error RCV_INVALID_ROI_VALUE occurs.

Inventory debug log file shows

******** New Session:14846210****22-JAN-13:03.51.10 **********
[22-JAN-13 15:51:10] po.plsql.RCV_NORMALIZE_DATA_PKG.RCV_NORMALIZE_DATA_P.begin:   v--------Procedure Started-----------v
[22-JAN-13 15:51:10] po.plsql.RCV_NORMALIZE_DATA_PKG.RCV_NORMALIZE_DATA_P.556:     Process Pending Rows: p_processing_mode=BATCH g_group_id=1791 g_request_id=1021478 p_org_id=-1
[22-JAN-13 15:51:10] po.plsql.RCV_NORMALIZE_DATA_PKG.RCV_NORMALIZE_DATA_P.575:     Processing single group...
[22-JAN-13 15:51:10] po.plsql.RCV_NORMALIZE_DATA_PKG.RCV_NORMALIZE_DATA_P.403:     in explode_lpn
[22-JAN-13 15:51:10] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.35 $): Explode_LPN : WMSINB-12221
[22-JAN-13 15:51:10] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.35 $): Explode_LPN group_id: 1791
[22-JAN-13 15:51:10] INV_RCV_INTEGRATION_PVT($Revision: 120.92.12010000.35 $): Explode_LPN request_id: 1021478
[22-JAN-13 15:51:10] po.plsql.RCV_NORMALIZE_DATA_PKG.RCV_NORMALIZE_DATA_P.434:     finished explode_lpn
[22-JAN-13 15:51:10] po.plsql.RCV_DEFAULT_PKG.RCV_DEFAULT_PKG.begin:     v--------Procedure Started-----------v
[22-JAN-13 15:51:10] po.plsql.RCV_DEFAULT_PKG.RCV_DEFAULT_PKG.1394:       checking for rhi vendor fields
[22-JAN-13 15:51:10] po.plsql.RCV_TABLE_FUNCTIONS.RCV_TABLE_FUNCTIONS.begin:       v--------Procedure Started-----------v
[22-JAN-13 15:51:10] po.plsql.RCV_TABLE_FUNCTIONS.RCV_TABLE_FUNCTIONS.81:         Updating RHI HEADER_INTERFACE_ID=52011
[22-JAN-13 15:51:10] po.plsql.RCV_TABLE_FUNCTIONS.RCV_TABLE_FUNCTIONS.end_implicit:       ^--------Implicit Procedure Exit-----^
[22-JAN-13 15:51:10] po.plsql.RCV_DEFAULT_PKG.RCV_DEFAULT_PKG.231:       Elapsed Time:       0,Absolute Time:    1942738657 - BEGIN default_transaction
[22-JAN-13 15:51:10] po.plsql.RCV_DEFAULT_PKG.RCV_DEFAULT_PKG.7168:       rti.interface_transaction_id = 262268
[22-JAN-13 15:51:10] po.plsql.RCV_DEFAULT_PKG.RCV_DEFAULT_PKG.231:       Elapsed Time:       1,Absolute Time:    1942738658 - default_rti_from_code
[22-JAN-13 15:51:10] po.plsql.RCV_DEFAULT_PKG.RCV_DEFAULT_PKG.231:       Elapsed Time:       0,Absolute Time:    1942738658 - default_rti_from_rhi
[22-JAN-13 15:51:10] po.plsql.RCV_DEFAULT_PKG.RCV_DEFAULT_PKG.231:       Elapsed Time:       0,Absolute Time:    1942738658 - default_rti_from_rti
[22-JAN-13 15:51:10] po.plsql.RCV_DEFAULT_PKG.RCV_DEFAULT_PKG.231:       Elapsed Time:       1,Absolute Time:    1942738659 - default_rti_from_rt
[22-JAN-13 15:51:10] po.plsql.RCV_DEFAULT_PKG.RCV_DEFAULT_PKG.231:       Elapsed Time:       0,Absolute Time:    1942738659 - general defaulting

Rcv11i output from <Note 402245.1> shows

In PO_INTERFACE_ERRORS
Column_Name    PO_LINE_ID
Error_Message    Error: The PO_LINE_ID specified is invalid. The value specified (165930) does not match the expected value (165931).
Request_Id    1021478
Error_Message_Name    RCV_INVALID_ROI_VALUE
Table_Name    RCV_HEADERS_INTERFACE
Batch_Id    1791
Interface_Header_Id    52011
Interface_Line_Id    262268

In RCV_TRANSACTIONS_INTERFACE 
Interface_Transaction_Id 262268
Group_Id 1791
Transaction_Type RECEIVE
Processing_Status_Code ERROR
Quantity 1
Item_Id 13489
Auto_Transact_Code DELIVER
Shipment_Header_Id 64788
Shipment_Line_Id
Receipt_Source_Code VENDOR
To_Organization_Id 207
Source_Document_Code PO
Po_Header_Id 33451
Po_Line_Id 165930
Po_Line_Location_Id 61547
Destination_Type_Code EXPENSE
Shipment_Num 91994379
Header_Interface_Id 52011
Validation_Flag Y
Org_Id 81

In RCV_HEADERS_INTERFACE
one record with Header_Interface_Id 52011
 
Steps
The issue can be reproduced at will with the following steps:
Re-Process Receive transactions via ROI
Run RVCTP for Group_Id 1791

Changes

Cause

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