Total Pageviews

Saturday, 4 February 2023

Oracle PLSQL : How to resolve package state in invalid state

How to resolve PLSQL package state in invalid state


Error in Workflow APINL/125-806353 ORA-04061: existing state of  has been invalidated

ORA-04061: existing state of package body "APPS.APINV_NO_WF_PKG" has been invalidated

ORA-04065: not executed, altered or dropped package body "    



Solution :-  Go to v$Session  and find your object and kill the session


No comments:

Post a Comment

FUSION : BIP Reports Multiple Parameter Selection

How to make parameter multiple value selection in FUSION BIP REPORT    AND ( least(:P_PR_NUMBER) is null   or   prha.requisition_header_id i...