#@#@#@!!!!!!

As technical consultant, I learn new stuff everyday. My goal here to collect those day-to-day findings and organized them for future reference.

#@#@#@!!!!!!

Thursday, March 22, 2007

"ORA-04062: signature of package "APPS.WF_EVENT" has been changed" error (+ solution )

Symptoms

When saving a change in the Expense Report Templates form, the following error is received:

"ORA-04062: signature of package "APPS.WF_EVENT" has been changed"

Cause

The Form was not recompiled after the package signature changed.

If other product teams change their package signature, then all the dependent objects need to be
re-compiled.

Solution

To implement the solution, please execute the following steps:

1. Recompile the Expense Report Templates form APXXXDER using adamin.

Option #2
 Temporarily resetting FORMS60_PATH to:
"/app/D2CRP/d2crpappl/au/11.5.0/resource:/app/D2CRP/d2crpappl/au/11.5.0/forms/US: \
/app/D2CRP/d2crpappl/au/11.5.0/resource/US"

Generating form "forms/US/APXXXDER.fmx" with command:

/app/D2CRP/d2crpora/8.0.6/bin/f60gen module=/app/D2CRP/d2crpappl/au/11.5.0/forms/US/APXXXDER.fmb userid=APPS/***** output_file=/app/D2CRP/d2crpappl/ap/11.5.0/forms/US/APXXXDER.fmx module_type=form batch=yes compile_all=special

Successfully generated form "forms/US/APXXXDER.fmx".

ORA-24026: operation failed, queue APPLSYS.WF_CONTROL error in WF Notification Mailer (+ solution)

Symptoms
The orkflow mailer does not run because of errors in the log file

ORA-20002: 3825: Error '-24026 - ORA-24026: operation failed, queue APPLSYS.WF_CONTROL has
errors' encountered during execution of 'WF_RULE.ERROR_RULE' for event
'oracle.apps.fnd.cp.gsc.SvcComponent.start'.
FUNCTION_NAME=WF_EVENT_OJMSTEXT_QH.enqueue()
Cause
Either the queue WF_CONTROL or its data is corrupted, probably due to the change of the IMAP/SMTPserver settings.

Since the WF_CONTROL queue is used by the notification mailer to hold runtime data, and it is not valid, the mailer will not be able to start up
Solution
To solve this problem please proceed as follows:

1. Stop Workflow Agent listeners

2. Run the following:
cd $FND_TOP/patch/115/sql
sqlplus APPS/ @wfctqrec.sql APPLSYS

3. Grant required privileges:
sqlplus apps/passwd @afwfqgnt.sql APPS APPLSYS

Note: APPLSYS password is the same as APPS'.

4. Start Workflow Agent listeners.

The Workflow mailer should start now

Hint: to make sure the WF_CONTROL queue was created successfully, the Concurrent request 'Workflow Control Queue Cleanup' should run without errors.