ROI Receipts Transactions Stuck In The Interface Table with RCV_ALL_INVALID_LOCATOR

(Doc ID 1995894.1)

Last updated on NOVEMBER 04, 2016

Applies to:

Oracle Inventory Management - Version 12.0.0 to 12.2.4 [Release 12.0 to 12.2]
Information in this document applies to any platform.

Symptoms

When attempting to receiving by ROI, the following error in the log file:

the following error occurs.

po.plsql.RCV_TRANSACTIONS_INTERFACE_SV1.RCV_TRANSACTIONS_INT.1382: Before Get Locator
po.plsql.RCV_TRANSACTIONS_INTERFACE_SV1.RCV_TRANSACTIONS_INT.1413: Loc Cont = 2
po.plsql.RCV_TRANSACTIONS_INTERFACE_SV1.RCV_TRANSACTIONS_INT.1414: Rest Cont =
po.plsql.RCV_TRANSACTIONS_INTERFACE_SV1.RCV_TRANSACTIONS_INT.1439: Sub is not under restricted locator control
po.plsql.RCV_TRANSACTIONS_INTERFACE_SV1.RCV_TRANSACTIONS_INT.1537: BEFORE GET PROJECT TASK LOCATOR
po.plsql.RCV_TRANSACTIONS_INTERFACE_SV1.RCV_TRANSACTIONS_INT.1558: X_LOCATOR_RECORD.PO_DISTRIBUTION_ID17321905
po.plsql.RCV_TRANSACTIONS_INTERFACE_SV1.RCV_TRANSACTIONS_INT.1560: X_LOCATOR_RECORD.SOURCE_DOCUMENT_CODEPO
po.plsql.RCV_TRANSACTIONS_INTERFACE_SV1.RCV_TRANSACTIONS_INT.1571: X_LOCATOR_RECORD.PO_DISTRIBUTION_ID17321905
po.plsql.RCV_TRANSACTIONS_INTERFACE_SV1.RCV_TRANSACTIONS_INT.1579: BEFORE PROJECT ENABLED
po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.begin: v--------Procedure Started-----------v
po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.217: set error message token = RCV_ALL_INVALID_LOCATOR
po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.218: error stack from call to set_error_message
po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.-1: Current Calling Stack = ? RVTBM.C RCV_ROI_PREPROCESSORRCV_ROI_TRANSACTION RCV_TRANSACTIONS_INTRCV_ERROR_PKG
po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.-1: ----- PL/SQL Call Stack -----
  object line object
  handle number name

 

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