My Oracle Support Banner

Workflow Error: XDPWFSTD due to ORA-4061 in APPS.CSI_INV_TRXS_PKG (Doc ID 1237694.1)

Last updated on MARCH 12, 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).
------------------------------------------------------------------------------------------------------------
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

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.