"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.

Oracle CRS with Trunked public interface problem (+ workaround)

I've encountered a problem installing Oracle CRS on a server with trunked public 'ce' interfaces.

Hardware: v890
OS : Solaris 10 update 3
Oracle Version: 10.2.0.3
Trunking : 1.3

The 'vipca' script fails, and when you look at the logfile $CRS_HOME/log//racg/ora..vip.log it's packed full of usage messages from nettr (see extract from log below). Oracle has a bug logged with similar symptoms 5876195 but this is marked as not a bug and they have not published a workaround.

Looking at the script $CRS_HOME/bin/racgvip, it calls nettr -stats with incorrect options if you have a 'ce' interface.

line 305 # _O1=`$NETTR -stats ${_TRUNKHEAD} device=${_DEVICE} | $AWK '/'$_DEVICE'/ { _S += $2 } END { print _S }'`

If you alter this line to read

_O1=`$NETTR -stats ${_TRUNKHEAD} | $AWK '/'$_DEVICE'/ { _S += $2 } END { print _S }'`

Then re-run vipca manually, your vip will create successfully.

Hope this helps stop someone having the same headaches I did,

mel


------ Extract from log starts here

Oracle Database 10g CRS Release 10.2.0.1.0 Production Copyright 1996, 2005 Oracle. All rights reserved.
2007-03-08 13:48:30.063: [ RACG][1] [5638][1][ora.bombay.vip]: Usage: /etc/opt/SUNWconn/bin/nettr -setup device= members=
[ { device= members= }... ]
[ policy= ]
[ mac= ]
[ lacp= [ ptimer=<0|1> ] ]
/etc/opt/SUNWconn/bin/nettr
2007-03-08 13:48:30.070: [ RACG][1] [5638][1][ora.bombay.vip]: -setup device= members=
[ policy= ]

/etc/opt/SUNWconn/bin/nettr -stats
[ type=<1|2> ] [ interval= ]
/etc/opt/SUNWconn/bin/nettr -stats device=
[ type=<1|2> ] [ in
2007-03-08 13:48:30.070: [ RACG][1] [5638][1][ora.bombay.vip]: terval= ]

/etc/opt/SUNWconn/bin/nettr -release
/etc/opt/SUNWconn/bin/nettr -release device=

/etc/opt/SUNWconn/bin/nettr -add
device= members=
[ { device=dev2> members= }.
2007-03-08 13:48:30.070: [ RACG][1] [5638][1][ora.bombay.vip]: .. ]

/etc/opt/SUNWconn/bin/nettr -rem
device= members=
[ { device= members= }... ]

/etc/opt/SUNWconn/bin/nettr -mod
[ policy= ]
[ lacp= ] [ ptimer=<0|1> ]

/etc/opt/S