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: Purchasing Query

  1) ---------CPA to PO Amount---------- select poh.segment1, (select sum(nvl(cpol.quantity,1)* cpol.unit_price) from po_headers_all cpoh,po...