CCG Metabuilder Synchronize Job Error TICK_SYNCHRONIZE_PKG.RUN_SYNCHRONIZE ORA-06502 (Doc ID 1616040.1)

Last updated on OCTOBER 10, 2023

Applies to:

Symptoms

 On Configuration Controls Givernor, the Metabuilder synchronize job errors out.

Error:
TICK_SYNCHRONIZE_PKG.RUN_SYNCHRONIZE ORA-06502: PL/SQL: numeric or value error:  
character string buffer too small

PDF Job log shows the following error:

Enabling Descriptive Flexfield on AR_LOCATION_VALUES_OLD ...
applsys_schema_v APPLSYS
Error in Enable_DFF(): ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Error occurred while running the Synchronize process.
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
...requires: AP 12.1.1
Before insert for TICK_TARGET_APPL_SCHEMAS for AP. Value for v_target_schema_id:

Cause

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