My Oracle Support Banner

R12: AP: Why Is Workflow Is Failing With Error ORA-06508: PL/SQL: Could Not Find Program Unit Being Called (Doc ID 2733410.1)

Last updated on DECEMBER 31, 2020

Applies to:

Oracle Workflow - Version 12.2.6 and later
Information in this document applies to any platform.


Workflows are failing because of this below error, after compiling new code (package body ) in PROD.

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

The issue DOES NOT Occur after bouncing workflow agent listener service.  And the issue Not occur on other non-PROD instance.

What is the root cause of the issue to avoid it in the future.



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

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