INDEX HZ_CLASS_CODE_DENORM_T1 INVALID AFTER DATABASE UPGRADE (Doc ID 428816.1)

Last updated on AUGUST 24, 2016

Applies to:

Oracle Receivables - Version: 11.5.10.0 to 11.5.10.3 - Release: 11.5.10 to 11.5.10
Information in this document applies to any platform.

Symptoms

After the database upgrade to 10.2.0.2 the AR invalid objects

SQL> select owner, object_name, object_type from all_objects where status=
'INVALID' and owner='AR';

OWNER OBJECT_NAME
------------------------------ ------------------------------
OBJECT_TYPE
-------------------
AR HZ_CLASS_CODE_DENORM_T1
INDEX

Changes

database upgrade to 10.2.0.2

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