Offer Budget Line Approval Fails With Error :ORA-06502: PL/SQL: Numeric Or Value Error (Doc ID 2585338.1)

Last updated on SEPTEMBER 09, 2019

Applies to:

Symptoms

Offer Budget line approval fails with error :ORA-06502: PL/SQL: numeric or
value error

After creating offer and clicking 'request approval', the budget line approval fails with error :

3146: Commit happened in activity/function
'AMS_VALIDATE_OBJECT_BUDGET:AMS_VALIDATE_OBJ_BUDGET/AMS_APPROVAL_PVT.VALIDATE_
OBJECT_BUDGET_WF'

Error Stack
AMS_APPROVAL_PVT.Validate_Object_Budget_WF(AMSAPRV, 556473_OFFRxxxxxxx,
353784, 1: Generating product eligibility denorm statement failed. Details:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
2: ORA-06502: PL/SQL: numeric or value error: character string buffer too
small in Package OZF_OFFR_ELIG_PROD_DENORM_PVT Procedure refresh_products )
Wf_Engine_Util.Function_Call(AMS_APPROVAL_PVT.VALIDATE_OBJECT_BUDGET_WF,
AMSAPRV, 556473_xxxxxxxx, 353784, RUN)

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.