DQM Parallel Sync Index Child Program Failing With ORA-06502 ORA-20000: Oracle Text error: DRG-50857: Oracle Error in drftpwait ORA-06510 (Doc ID 1670601.1)

Last updated on JULY 25, 2016

Applies to:

Oracle Trading Community - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

Post R12 Upgrade:

Attempting to run the concurrent program "DQM Parallel Sync Index Child Program" and receive the following error:

ORACLE error 6502 in FDPSTP

Cause: FDPSTP failed due to ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.HZ_DQM_SYNC", line 2856
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drftpwait
ORA-06510:
---------------------------------------------------------------------------
Start of log messages from FND_FILE
---------------------------------------------------------------------------
 Starting Sync Index Parallel Child concurrent Program for index AR.hz_stage_party_sites_t1
 Schema name stripped index is HZ_STAGE_PARTY_SITES_T1
 index owner is AR
---------------------------------------------------------------------------
End of log messages from FND_FILE
---------------------------------------------------------------------------

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