“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
