ARXCUDCI - Add Customer Address Error 'ORA-04063: Rule Set "APPLSYS.WF_DEFERRED_R" has errors'
Last updated on JULY 12, 2017
Applies to:Oracle Receivables - Version 18.104.22.168 and later
Information in this document applies to any platform.
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:
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:
Navigation: Customer > Standard
Query for customer 'Spectrum Desion'
Click the New button to add a new address
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms