My Oracle Support Banner

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 JANUARY 29, 2018

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
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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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