Character String Buffer Too Small Error While End Dating Vehicle in Repository (Doc ID 2222575.1)

Last updated on JANUARY 26, 2017

Applies to:

Oracle Human Resources - Version 12.1.3 and later
Oracle HRMS (India) - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Core HR

When attempting to end date a vehicle in Vehicle Repository,
the following error occurs.

ERROR:
oracle.apps.fnd.framework.OAException: java.sql.SQLException:
ORA-6502: PL/SQL: numeric or value error: character string buffer too small
ORA-6512: at "APPS.PQP_VEHICLE_REPOSITORY_SWI", line 412
ORA-6512: at line 1

 
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login under HRMS Manager responsibility
2. Total compensation - Basic - Vehicle repository - search for vehicle - select vehicle and press delete button
3. Select end date option - click Yes
4. Encountering Character String Buffer Too Small Error

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