Error in Workflow POAPPRV/19799-83839 [WF_ERROR] ERROR_MESSAGE=3835: Error '-6508 - ORA-06508: PL/SQL: could not find program unit being called' encountered during execution of Generate function 'WF_XML.Generate' for event 'oracle.apps.wf.n

“Error in Workflow POAPPRV/19799-83839 [WF_ERROR] ERROR_MESSAGE=3835: Error '-6508 - ORA-06508: PL/SQL: could not find program unit being called' encountered during execution of Generate function 'WF_XML.Generate' for event 'oracle.apps.wf.n”

Like above notifications in sysadmin workflow notifications

                                                                AND

Users are complaining workflow mails are not getting (i.e) If a purchasing user creates a PO and sends to his manager but his manager not getting mail for approval link.

                                                                AND

 Unsent mails  count are getting increase and not getting reduce its count more than 1hr.

                                                AND

wf_notifications table column shows mail is “open” and mail_status are “invalid or mail”

Solution for this above problem is ,

1)      Check workflow mailer is running, if running go to step 2.

2)      Go to Oracle application manager > sitemap > Notificaton Mailer > click on “view details” >on right corner of the page , you will see test mail “so click on test mailer” >recipient role “enter some users name who is facing problem > send test message

3)      Check with that users whether he gets the test mail from EBS or not

4)      Check for any new invalid objects in apps schema (Select object_name,owner ,status from dba_objects where status=”INVALID” and owner=”APPS”;)

5)      If found any new invalid objects in apps schema, recompile if using SQL>@$ORACLE_HOME/rdbms/admin/utlrp.sql

6)      Now check count of invalid objects in apps again using above query

7)      If any new invalid objects apps schema and all objects in valid state

8)      Now go to workflow manager  >  stop & start  workflow notification mails

9)      After restarting “workflow notification mailer “ users must get the notification from EBS