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 15, 2017

Applies to:

Oracle Inventory Management - Version 12.2.5 and later
Information 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


Stesp to Reproduce Issue:
----------------------------

  1. Populate ROI interface tables to perform receipt against Purchase Order (RCV_HEADERS_INTERFACE & RCV_TRANSACTIONS_INTERFACE tables)
  2. Run Receiving Transaction Processor to process the receipt
  3. Concurrent RVCTP fails with RCV_ASN_INVAL_SHIP_TO_LOC errors

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