ORA-06512: at APPS.AHL_PRD_DF_PVT_W .. When Performing Deferral In UMP (Counter Name > 30 Chars)
Last updated on SEPTEMBER 06, 2016
Applies to:Oracle Complex Maintenance, Repair & Overhaul - Version 12.1.3 and later
Information in this document applies to any platform.
In Component Maintenance ... when attempting to do Maintenance Deferral/Concession in UMP ... the following error occurs.
ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "APPS.AHL_PRD_DF_PVT_W", line 63 ORA-06512: at "APPS.AHL_PRD_DF_PVT_W", line 395 ORA-06512: at line1
CMRO Responsibility -> Planning -> Unit Maintenance Plan ->Overview
Step1: Provide any search criteria
Step2: Select any Unit Maintenance Plan and select "Maintenance Deferral/Concession" from the action list and Click on Go
Step3: Provide the required details with Counter Name
Note: To Reproduce the error follow the above steps and also ensure that the counter name whichever your are providing is of size >30 characters.
The issue resides in Package APPS.AHL_PRD_DF_PVT where TYPE df_schedules_rec_type is RECORD is using the COUNTER_NAME VARCHAR2(30)
Since the CSI_COUNTERS_TL description shows DATATYPE as NAME VARCHAR2(80) which is causing the issue.
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