6 Replies Latest reply on Aug 24, 2018 8:43 AM by John_K

    ORA-04061: existing state of has been invalidated - Workflow errors in Production

    3419777

      Order lines (OEOL) workflow is failing at a custom node with the error shown below. This happens in Production but not in any test instances that are cloned. Shared pool was flushed for this package and workflow mailer was bounced multiple times but nothing helped. This happens only for some order lines and other similar lines go through fine. There are no invalid objects. Also when workflow lines are retried, they go through fine.

       

      Failed Activity  XX Check Shippable Flag

       

      Activity Type  Function

       

      Error Name  -4061

       

      Error Message  ORA-04061: existing state of has been invalidated ORA-04061: existing state of package body "APPS.XX_OM_WORKFLOW" has been invalidated ORA-04065: not executed, altered or dropped package body "APPS.XX_OM_WORKFLOW" ORA-06508: PL/SQL: could not find program unit being called: "APPS.XX_OM_WORKFLOW"