ORA-06512: at APPS.AHL_PRD_DF_PVT_W .. When Performing Deferral In UMP (Counter Name > 30 Chars)

(Doc ID 2036610.1)

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.

Symptoms

In Component Maintenance ... when attempting to do Maintenance Deferral/Concession in UMP ... the following error occurs.


ERROR
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


STEPS
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
Step4: Apply

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.



Cause

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