My Oracle Support Banner

Collective Agreement Evaluation Process Failing (Doc ID 2710622.1)

Last updated on OCTOBER 28, 2020

Applies to:

Oracle Human Resources - Version 12.1 HRMS RUP12 and later
Information in this document applies to any platform.


Problem Statement:

Collective Agreement Evaluation process is failing with error

Cause: FDPSTP failed due to ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.PER_CAGR_APPLY_RESULTS_PKG", line 1620
ORA-06512: at "APPS.PER_CAGR_EVALUATION_PKG", line 4057
Error : Formula XX_UNIONS
Error : ORA-06502: PL/SQL: numeric or value error
 Fast Formula did not determine an eligible entitlement.
 Evaluating related Retained Rights for the item
 Completed related Retained Rights.



Steps to Reproduce:
The issue can be reproduced at will with the following steps:

  1.  Responsibility: XX HRMS Manager

  2. People> Enter & Maintain> Find Person > Click Assignment > Enter Collective Agreement
  3.  Run Collective Agreement Evaluation Process



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.