Error Notifications Received From IGS_PE_WF_GEN Workflows

 Error Notifications Received From IGS_PE_WF_GEN Workflow

We are frequently receiving error notifications like the ones mentioned below:

1. An Error occurred in the following Workflow.

Item Type = IGSPE002
Item Key = oracle.apps.ar.hz.PartySite.update29282
User Key =

Error Name = -6550
Error Message = ORA-06550: line 1, column 7:
PLS-00201: identifier 'IGS_PE_WF_GEN.ADDRESS_UPDATE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Error Stack =
Wf_Engine_Util.Function_Call(igs_pe_wf_gen.address_update, IGSPE002, oracle.apps.ar.hz.PartySite.update29282, 167520, RUN)

Activity Id = 167520
Activity Label = ADDR_UPDATE:ADDR_UPDATE_FUN
Result Code = #EXCEPTION
Notification Id =
Assigned User =

2. Wf_Engine_Util.Function_Call(igs_pe_wf_gen.address_create, IGSPE002, oracle.apps.ar.hz.PartySite.create22168, 167512, RUN)
ORA-06550: line 1, column 7:
PLS-00201: identifier 'IGS_PE_WF_GEN.ADDRESS_CREATE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Not using the IGS module so what is causing the errors?

CAUSE 

The IGS product (Oracle Student System) was deprecated and not included in APPS R12.

SOLUTION

Please disable the IGS Workflows.

To disable this Workflow:

Navigation: Workflow Administrator Web Applications > Business Events >

1. query the Event named oracle.apps.ar.hz.PartySite.create
2. click on the Update pencil icon and change the Status to Disabled
3. click Apply, then Yes
4. query the Event named oracle.apps.ar.hz.PartySite.create
5. click on the Subscription icon
6. for the Function named "WF_RULE.Default_Rule" click to pencil icon
7. select Disabled from the List of Values
8. click Apply button, then Yes
9. Repeat these steps for the Event named "oracle.apps.ar.hz.PartySite.update"

To clean up the workflows:

1. To clean them up, the Workflows for them should be canceled.
2. When the Purge Obsolete Workflow Runtime Data request is run, it will purge the records once they are eligible to be purged.

For information on deleting the WF errors please read Doc ID 804622.1 - How to Purge WFERROR (System: Error) Workflow Items?