Cust Form: Address Entry Form Returns Error: ORA-29877: Failed In The Execution Of The OD (Doc ID 2696926.1)

Last updated on AUGUST 25, 2020

Applies to:

Symptoms

There is an error when creating or updating accounts after a patch application or upgrade.

The following SQL error occurred: ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine ORA-20000: Oracle Text error: DRG-50857: oracle error in textindexmethods.ODCIIndexUpdate ORA-20000: Oracle Text error: DRG-10602: failed to queue DML change to column ADDRESS_TEXT for primary key AABblvAC9AAD4DvAAB DRG-50857: oracle error in drekqkd(execute k_stmt) ORA-00942: table or view does not exist .

A query of the text indexes show that indexes are valid but there is still an error on the customer form.

1) SELECT index_name, index_type, table_name, status FROM dba_indexes WHERE INDEX_TYPE='DOMAIN' AND table_name like 'HZ_%';

INDEX_NAME INDEX_TYPE TABLE_NAME STATUS
---------------------
HZ_STAGE_PARTY_SITES_T1 DOMAIN HZ_STAGED_PARTY_SITES VALID
HZ_STAGE_PARTIES_T1 DOMAIN HZ_STAGED_PARTIES VALID
HZ_STAGE_CPT_T1 DOMAIN HZ_STAGED_CONTACT_POINTS VALID
HZ_STAGE_CONTACT_T1 DOMAIN HZ_STAGED_CONTACTS VALID
HZ_CUST_ACCT_SITES_ALL_T1 DOMAIN HZ_CUST_ACCT_SITES_ALL VALID
HZ_CLASS_CODE_DENORM_T1 DOMAIN HZ_CLASS_CODE_DENORM VALID

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.