Unable To Open AME Condition Page Due to Error “You Have Encountered an Unexpected Error” “ORA-06502: PL/SQL: Numeric or Value Error: Character String Buffer Too Small” (Doc ID 2917080.1)

Last updated on DECEMBER 26, 2022

Applies to:

Symptoms

When attempting to open Conditions page under Approvals Management Business Analyst responsibility
the following error occurs:

ERROR
-----------------------
"You have encountered an unexpected error. Please contact your System Administrator for assistance."

Error from the Java Stack as below:

JBO-27122: SQL error during statement preparation.

Statement: SELECT * FROM (SELECT distinct ame_utility_pkg.get_condition_description(COND.condition_id) AS DESCRIPTION
  ,LOOKUP.meaning AS CONDTYPE
  ,COND.condition_id AS CONDITIONID..................

## Detail 0 ##
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.FND_MESSAGE", line 798
ORA-06512: at "APPS.FND_MESSAGE", line 752
ORA-06512: at "APPS.AME_UTILITY_PKG", line 604
ORA-06512: at line 1



STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. (N) Approvals Management Business Analyst responsibility.
2. On Business Analyst Dashboard click on 'Setup' for any Transaction Type.
3. Click on 'Conditions' tab-> Error is raised.

Changes

 N/A

Cause

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