Refresh of Classification Denormalization Error: 'DRG-10595: Alter Index HZ_CLASS_CODE_DENORM_T1 Failed' (Doc ID 1293491.1)

Last updated on JULY 12, 2017

Applies to:

Oracle Trading Community - Version 12.1.3 and later
Information in this document applies to any platform.
Refresh of Classification Denormalization (ARHRECC module)


Symptoms

In R12.1.3, run the Refresh of Classification Denormalization (ARHRECC module) and it fails with the following error in the log file:


ORA-29874: warning in the execution of ODCIINDEXALTER routine
ORA-29960: line 1,
DRG-10595: ALTER INDEX HZ_CLASS_CODE_DENORM_T1 failed
DRG-00100: internal error, arguments : [51021],[drwaf.c],[1607],[],[]


Steps to reproduce:
Responsibility: Trading Community Manager
Navigation: Control > Requests > Run
-Select concurrent program Refresh of Classification Denormalization from the list of values.
-Click Submit.

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