ROI Receipts With RCV_ASN_INVAL_SHIP_TO_LOC Errors "The ship-to location (VALUE=nnn) does not match the ship-to location on the purchase order on column SHIP_TO_LOCATION_ID"
(Doc ID 2228323.1)
Last updated on FEBRUARY 24, 2019
Applies to:
Oracle Inventory Management - Version 12.2.5 and laterInformation in this document applies to any platform.
Symptoms
Receiving Open Interface (ROI) Receipt against Purchase Order fail with the following error messages in PO_INTERFACE_ERRORS:
INTERFACE_TYPE RCV-856 INTERFACE_TRANSACTION_ID 3137974 COLUMN_NAME SHIP_TO_LOCATION_ID ERROR_MESSAGE Error: The ship-to location (VALUE=1754) does not match the ship-to location on the purchase order ERROR_MESSAGE_NAME RCV_ASN_INVAL_SHIP_TO_LOC TABLE_NAME RCV_TRANSACTIONS_INTERFACE
INTERFACE_TYPE RCV-856 INTERFACE_TRANSACTION_ID 3137975 COLUMN_NAME SHIP_TO_LOCATION_CODE ERROR_MESSAGE Error: The ship-to location (VALUE=) does not match the ship-to location on the purchase order ERROR_MESSAGE_NAME RCV_ASN_INVAL_SHIP_TO_LOC TABLE_NAME RCV_TRANSACTIONS_INTERFACE
Receiving Transaction Processor (RVCTP) concurrent log debug messages show:
[26-JAN-17 13:36:32] po.plsql.RCV_ROI_TRANSACTION.RCV_ROI_TRANSACTION.4978: Enforce ShipToLocation REJECT
[26-JAN-17 13:36:32] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.begin: v--------Procedure Started-----------v
[26-JAN-17 13:36:32] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.217: set error message token = RCV_ASN_INVAL_SHIP_TO_LOC
[26-JAN-17 13:36:32] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.218: error stack from call to set_error_message
[26-JAN-17 13:36:32] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.-1: Current Calling Stack = ? RVTBM.C RCV_ROI_PREPROCESSORRCV_ROI_TRANSACTION RCV_ERROR_PKG
...
[26-JAN-17 13:36:32] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.74: logging error The ship-to location (VALUE=1754) does not match the ship-to location on the purchase order on column SHIP_TO_LOCATION_ID
...
[26-JAN-17 13:36:33] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.217: set error message token = RCV_ASN_INVAL_SHIP_TO_LOC
...
[26-JAN-17 13:36:33] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.74: logging error The ship-to location (VALUE=) does not match the ship-to location on the purchase order on column SHIP_TO_LOCATION_CODE
[26-JAN-17 13:36:32] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.begin: v--------Procedure Started-----------v
[26-JAN-17 13:36:32] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.217: set error message token = RCV_ASN_INVAL_SHIP_TO_LOC
[26-JAN-17 13:36:32] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.218: error stack from call to set_error_message
[26-JAN-17 13:36:32] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.-1: Current Calling Stack = ? RVTBM.C RCV_ROI_PREPROCESSORRCV_ROI_TRANSACTION RCV_ERROR_PKG
...
[26-JAN-17 13:36:32] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.74: logging error The ship-to location (VALUE=1754) does not match the ship-to location on the purchase order on column SHIP_TO_LOCATION_ID
...
[26-JAN-17 13:36:33] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.217: set error message token = RCV_ASN_INVAL_SHIP_TO_LOC
...
[26-JAN-17 13:36:33] po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.74: logging error The ship-to location (VALUE=) does not match the ship-to location on the purchase order on column SHIP_TO_LOCATION_CODE
Stesp to Reproduce Issue:
----------------------------
- Populate ROI interface tables to perform receipt against Purchase Order (RCV_HEADERS_INTERFACE & RCV_TRANSACTIONS_INTERFACE tables)
- Run Receiving Transaction Processor to process the receipt
- Concurrent RVCTP fails with RCV_ASN_INVAL_SHIP_TO_LOC errors
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 |
Cause |
Solution |
References |