Workflow Error: XDPWFSTD due to ORA-4061 in APPS.CSI_INV_TRXS_PKG
(Doc ID 1237694.1)
Last updated on AUGUST 17, 2021
Applies to:
Oracle Installed Base - Version 11.5.10 to 12.1.3 [Release 11.5 to 12.1]Information in this document applies to any platform.
Symptoms
Users receive XDPWFSTD item type workflow errors several times a day.
Item Type = XDPWFSTD
Item Key = WF123
User Key =
Error Name = WFNTF_ROLE
Error Message = 3205: 'FND_RESP535:123' is not a valid role or user name.
Error Stack =
Wf_Notification.Send(FND_RESP535:123, XDPWFSTD, XDP_WF_ERROR_MSG, WF_ENGINE.CB)
Wf_Engine_Util.Notification_Send(XDPWFSTD, WF123, 222, XDPWFSTD:XDP_WF_ERROR_MSG)
Wf_Engine_Util.Notification(XDPWFSTD, WF123, 222, RUN).
Item Key = WF123
User Key =
Error Name = WFNTF_ROLE
Error Message = 3205: 'FND_RESP535:123' is not a valid role or user name.
Error Stack =
Wf_Notification.Send(FND_RESP535:123, XDPWFSTD, XDP_WF_ERROR_MSG, WF_ENGINE.CB)
Wf_Engine_Util.Notification_Send(XDPWFSTD, WF123, 222, XDPWFSTD:XDP_WF_ERROR_MSG)
Wf_Engine_Util.Notification(XDPWFSTD, WF123, 222, RUN).
------------------------------------------------------------------------------------------------------------
Due to Failed Sales Order Fulfillment transactions in the SFM xnp_msgs table:
Exception occured when handling TEXT VARCHAR2 Message Error message Id: 40397
Error:-4061 ORA-04061: existing state of has been invalidated
ORA-04061: existing state of package body "APPS.CSI_INV_TRXS_PKG" has been invalidated
ORA-04065: not executed, altered or dropped package body "APPS.CSI_INV_TRXS_PKG"
ORA-04061: existing state of package body "APPS.CSI_INV_TRXS_PKG" has been invalidated
ORA-04065: not executed, altered or dropped package body "APPS.CSI_INV_TRXS_PKG"
ORA-06508: PL/SQL: could not find program unit being called: "APPS.CSI_INV_TRXS_PKG"
ORA-06512: at "APPS.XNP_CSISUBTR_U", l
Error:-4061 ORA-04061: existing state of has been invalidated
ORA-04061: existing state of package body "APPS.CSI_INV_TRXS_PKG" has been invalidated
ORA-04065: not executed, altered or dropped package body "APPS.CSI_INV_TRXS_PKG"
ORA-04061: existing state of package body "APPS.CSI_INV_TRXS_PKG" has been invalidated
ORA-04065: not executed, altered or dropped package body "APPS.CSI_INV_TRXS_PKG"
ORA-06508: PL/SQL: could not find program unit being called: "APPS.CSI_INV_TRXS_PKG"
ORA-06512: at "APPS.XNP_CSISUBTR_U", l
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 |