Framework.OAException: Java.sql.SQLException: ORA-06502: PL/Sql Apps.Hxc_Alias_Translator Error in Self Service while Trying to Create Timecard (Doc ID 1667971.1)

Last updated on APRIL 25, 2016

Applies to:

Oracle Time and Labor - Version 12.0.6 to 12.2.5 [Release 12.0 to 12.2]
Information in this document applies to any platform.

Symptoms

On Production: 12.0.6 version, Seeded Timecard Layouts

When attempting to save a seeded Projects and Payroll timecard for an employee on Self Service Timecard,
the following error occurs.

ERROR
-----------------------
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.HXC_ALIAS_TRANSLATOR", line 486
ORA-06512: at "APPS.HXC_ALIAS_TRANSLATOR", line 1284
ORA-06512: at "APPS.HXC_SELF_SERVICE_TIMECARD", line 3910
ORA-06512: at "APPS.HXC_SELF_SERVICE_TIMECARD", line 5242
ORA-06512: at line 2
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)


Steps to Reproduce
-----------------------

1. Self Service Time or a Similar responsibility
2. Click on Time Entry for a Employee
3. Create timecard for employee
4. Press Save button
5. Receive 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