Fusion Absence Management: Errors ORA-06502 and ORA-06512 when users add Type of Absence (Doc ID 2116599.1)

Last updated on JANUARY 27, 2017

Applies to:

Oracle Fusion Absence Management Cloud Service - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Symptoms

In the Absence Processes, when you attempt to add an absence record for a person, the following error occurs:

ERROR
-----------------------
ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "FUSION.BEN_PER_ASG_ELIG", line 718 ORA-06512: at "FUSION.ANC_COMMON_UTILS", line 1591 ORA-06512: at line 1

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to: Person Management> Manage Absence Records
2. Add an absence record and above error is seen

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, user cannot add an absence record for themselves.

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