Error ORA-06502 ORA-4088 During Execution Of Trigger APPS.EGO_MTL_SY_ITEMS_EXT_TL_AU When Updating Translatable User Defined Attributes With Audit Enabled On EGO_MTL_SY_ITEMS_EXT_TL After Entering Attributes Length Greater Than 1000 Characters (Doc ID 3026848.1)

Last updated on JUNE 10, 2024

Applies to:

Symptoms

User has entered the translatable attributes for Item user defined attributes greater than 1000 chars after upgrade to 12.2.10 . The new length allowed for these columns TL_EXT_ATTR1 to TL_EXT_ATTR40 in table EGO.EGO_MTL_SY_ITEMS_EXT_TL has been increased from 1000 to 4000 chars/bytes. The audit on EGO.EGO_MTL_SY_ITEMS_EXT_TL was enabled prior to the upgrade so, the Audit table columns still show the column length as 1000 chars. After this, the users can no longer update the attributes on the item as it causes below error.

ERROR
Executing - "EGO_USER_ATTRS_DATA_PVT"."Raise_WF_Event_If_Enabled" "ORA-06502: PL/SQL: numeric or value error: character string buffer too small"Executing - "EGO_USER_ATTRS_DATA_PVT"."Update_Row" "ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "APPS.EGO_MTL_SY_ITEMS_EXT_TL_AUP", line 158 ORA-06512: at "APPS.EGO_MTL_SY_ITEMS_EXT_TL_AU", line 1 ORA-04088: error during execution of trigger 'APPS.EGO_MTL_SY_ITEMS_EXT_TL_AU'"

STEPS
1. Development Manager > Item catalog > Advanced Search > Query for an item that has Translatable UDA defined > Enter 1000+ chars > No errors first time.
2. Query the same item again to update the attribute > See error above.

Changes

Upgraded to 12.2.10.

Cause

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