ARXCUDCI - Add Customer Address Error 'ORA-04063: Rule Set "APPLSYS.WF_DEFERRED_R" has errors' (Doc ID 1561277.1)

Last updated on JULY 12, 2017

Applies to:

Oracle Receivables - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

In 11.5.10.2:

Attempting to add customer address to existing customer in Customers Standard form (ARXCUDCI) and receive the following error:

APP-AR-96282: Error: The following SQL error occurred:
ORA-04063: rule set "APPLSYS.WF_DEFERRED_R" has errors. The following SQL error occurred:
User-Defined Exception: The following error occurred:
ORA-04063: rule set "APPLSYS.WF_DEFERRED_R" has error. The following SQL error occurred:
User-Defined Exception: Unexpected SQL error encountered during synchronization:
Procedure: syn_party_site
Error: ORA-04063: rule set "APPLSYS.WF_DEFERRED_RR" has errors
Please contact the system administrator.

The issue also happens in  other modules like AP and HR:
 -the same error occurs when users tried to run payment batch in AP
 -the same error occurs when users tried to enter employee in HR

This had worked previously.  The only changes to the environment is that the following were done over the weekend:

-run APPS schema
-rebuild the indexes

Steps to reproduce:
Responsibility:  Receivables
Navigation:  Customer > Standard
Query for customer 'Spectrum Desion'
Click the New button to add a new address

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms