My Oracle Support Banner

ERROR: ORA-04063: view "APPS.HXC_RESOURCE_RULES_V" has errors 04063. 00000 - "%s has errors" when editing Preferences (Doc ID 2423640.1)

Last updated on JULY 16, 2018

Applies to:

Oracle Time and Labor - Version 12.1.3 to 12.2.4 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

On: 12.1.3 version, OTL Setup

When attempting to change the Preferences on the Preference tree,
the following error occurs.


ERROR
-----------------------

Receive error: ORA-04063: view "APPS.HXC_RESOURCE_RULES_V" has errors

Details:
ORA-04063: view "APPS.HXC_RESOURCE_RULES_V" has errors
04063. 00000 - "%s has errors"
*Cause: Attempt to execute a stored procedure or use a view that has
errors. For stored procedures, the problem could be syntax errors
or references to other, non-existent procedures. For views,
the problem could be a reference in the view's defining query to
a non-existent table.
Can also be a table which has references to non-existent or
inaccessible types.
*Action: Fix the errors and/or create referenced objects as necessary.
Error at Line: 9 Column: 20


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Responsibility: OTL Application Developer


2.  Navigate: Preferences->Preference Tree->Default Preferences

3.  Receive error: ORA-04063: view "APPS.HXC_RESOURCE_RULES_V" has errors

Details:
ORA-04063: view "APPS.HXC_RESOURCE_RULES_V" has errors
04063. 00000 - "%s has errors"
*Cause: Attempt to execute a stored procedure or use a view that has
errors. For stored procedures, the problem could be syntax errors
or references to other, non-existent procedures. For views,
the problem could be a reference in the view's defining query to
a non-existent table.
Can also be a table which has references to non-existent or
inaccessible types.
*Action: Fix the errors and/or create referenced objects as necessary.
Error at Line: 9 Column: 20

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.