DQM Staging Error: DRG-10502: Index HZ_STAGE_PARTIES_T1 Does Not Exist (Doc ID 1458547.1)

Last updated on JULY 12, 2017

Applies to:

Oracle Trading Community - Version 12.0 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.

Symptoms

In R12.1.1, run the concurrent program "DQM Staging Program" with option STAGE_ALL_DATA results in the following error:

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10502: index HZ_STAGE_PARTIES_T1 does not exist
DRG-50857: oracle error in drdmlv
ORA-01426: numeric overflow


The DQM Staging also fails with the exact same error when running it with parameter CREATE_INDEXES or CREATE_MISSING_INVALID_INDEXES:

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10502: index HZ_STAGE_CPT_T1 does not exist
DRG-50857: oracle error in drdmlv
ORA-01426: numeric overflow

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10502: index HZ_STAGE_CONTACT_T1 does not exist
DRG-50857: oracle error in drdmlv
ORA-01426: numeric overflow

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10502: index HZ_STAGE_PARTY_SITES_T1 does not exist
DRG-50857: oracle error in drdmlv
ORA-01426: numeric overflow

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10502: index HZ_STAGE_PARTIES_T1 does not exist
DRG-50857: oracle error in drdmlv
ORA-01426: numeric overflow

Steps to reproduce:
Responsibility: Trading Community manager
Navigation: Control : Request : Run

-Choose the DQM Staging Program from the LOV.
-Run it for parameter Staging Command = STAGE_ALL_DATA

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