ASN Receipts Fail With Errors RCV_ASN_ACCEPT_NO_ER and RCV_ASN_SHIPMT_NOT_OPEN
(Doc ID 1335486.1)
Last updated on JANUARY 03, 2023
Applies to:
Oracle Inventory Management - Version 12.1.3 and laterInformation in this document applies to any platform.
Executable:RVCTP - Receiving Transaction Processor
Symptoms
Attempting to perform accept and deliver of ASN Receipt fails with the following error messages in Receiving Transaction Processor log:
Purchasing: Version : 12.0.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
RVCTP module: Receiving Transaction Processor
+---------------------------------------------------------------------------+
Current system time is XXXXXXX
+---------------------------------------------------------------------------+
po.plsql.RCV_ROI_TRANSACTION.RCV_ROI_TRANSACTION.4027: Should give us the exact error
po.plsql.RCV_ROI_TRANSACTION.RCV_ROI_TRANSACTION.4091: This PO is not open and the profile option to include closed POs is N
po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.begin: v--------Procedure Started-----------v
po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.214: set error message token = RCV_ASN_SHIPMT_NOT_OPEN
po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.215: 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_ERROR_PKG
po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.-1: ----- PL/SQL Call Stack -----
object line object
handle number name
0x8bd989b8 109 package body APPS.ASN_DEBUG
0x8765bc50 216 package body APPS.RCV_ERROR_PKG
0x8765bc50 227 package body APPS.RCV_ERROR_PKG
0x8ecbd168 4095 package body APPS.RCV_ROI_TRANSACTION
0x8ecbd168 178 package body APPS.RCV_ROI_TRANSACTION
0x842ef748 1639 package body APPS.RCV_ROI_PREPROCESSOR
0x842ef748 723 package body APPS.RCV_ROI_PREPROCESSOR
0x82b1ef68 1 anonymous block
po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.71: logging error PO Shipment (NUMBER = 1) is not open. on column DOCUMENT_SHIPMENT_LINE_NUM
po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.36: error stack from call to po_interface_call
po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.-1: Current Calling Stack = ? RVTBM.C RCV_ROI_PREPROCESSORRCV_ROI_TRANSACTION RCV_ERROR_PKG
po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.-1:
----- PL/SQL Call Stack ---
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
RVCTP module: Receiving Transaction Processor
+---------------------------------------------------------------------------+
Current system time is XXXXXXX
+---------------------------------------------------------------------------+
po.plsql.RCV_ROI_TRANSACTION.RCV_ROI_TRANSACTION.4027: Should give us the exact error
po.plsql.RCV_ROI_TRANSACTION.RCV_ROI_TRANSACTION.4091: This PO is not open and the profile option to include closed POs is N
po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.begin: v--------Procedure Started-----------v
po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.214: set error message token = RCV_ASN_SHIPMT_NOT_OPEN
po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.215: 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_ERROR_PKG
po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.-1: ----- PL/SQL Call Stack -----
object line object
handle number name
0x8bd989b8 109 package body APPS.ASN_DEBUG
0x8765bc50 216 package body APPS.RCV_ERROR_PKG
0x8765bc50 227 package body APPS.RCV_ERROR_PKG
0x8ecbd168 4095 package body APPS.RCV_ROI_TRANSACTION
0x8ecbd168 178 package body APPS.RCV_ROI_TRANSACTION
0x842ef748 1639 package body APPS.RCV_ROI_PREPROCESSOR
0x842ef748 723 package body APPS.RCV_ROI_PREPROCESSOR
0x82b1ef68 1 anonymous block
po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.71: logging error PO Shipment (NUMBER = 1) is not open. on column DOCUMENT_SHIPMENT_LINE_NUM
po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.36: error stack from call to po_interface_call
po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.-1: Current Calling Stack = ? RVTBM.C RCV_ROI_PREPROCESSORRCV_ROI_TRANSACTION RCV_ERROR_PKG
po.plsql.RCV_ERROR_PKG.RCV_ERROR_PKG.-1:
----- PL/SQL Call Stack ---
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 |