ROI Receipts Transactions Stuck In The Interface Table with RCV_ALL_INVALID_LOCATOR
(Doc ID 1995894.1)
Last updated on FEBRUARY 01, 2023
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
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
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |