R12 Workflow Notification Errors for AGIS Outbound Transaction with ORA-04061 existing state of package body "APPS.FUN_TRX_PVT" has been invalidated (Doc ID 554282.1)

Last updated on SEPTEMBER 19, 2016

Applies to:

Oracle General Ledger - Version 12.0.4 and later
Oracle Financials Common Modules - Version 12.0.4 and later
Information in this document applies to any platform.

Symptoms

Create an AGIS outbound transaction and submit it. Then log on as Workflow Administrator, on the Workflow Notification Detail page, the failed AGIS outbound transaction notification shows the following error :-

ERROR
Item Type = FUNRTVAL
Item Key = 79121_80747_44C972EEB10AD0AAE0430A021002D0AA
User Key =

Error Name = -4061
Error Message = ORA-04061: existing state of has been invalidated
ORA-04061: existing state of package body "APPS.FUN_TRX_PVT" has been invalidated
ORA-04065: not executed, altered or dropped package body "APPS.FUN_TRX_PVT"
ORA-06508: PL/SQL: could not find program unit being called: "APPS.FUN_TRX_PVT"
Error Stack =
FUN_RECIPIENT_WF.UPDATE_STATUS_RECEIVED(FUNRTVAL, 79121_80747_44C972EEB10AD0AAE0430A021002D0AA,164756, RUN)
Wf_Engine_Util.Function_Call(FUN_WF_COMMON.UPDATE_STATUS_RECEIVED, FUNRTVAL,79121_80747_44C972EEB10AD0AAE0430A021002D0AA, 164756, RUN)

Activity Id = 164756
Activity Label = RECIPIENT_VALIDATION:UPDATE_RECEIVED
Result Code = #EXCEPTION
Notification Id =
Assigned User =

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