Recalculate Participation Values: Grade/Step Progression Error - ORA-20001: PQH_GSP_RAT_NOT_DFND (Doc ID 1943130.1)

Last updated on SEPTEMBER 27, 2023

Applies to:

Symptoms

On : 12.1.3 version, Grade / Step Progression

When attempting to run Recalculate Participation Values: Grade/Step Progression,
the logfile output show the following error :

ERROR
-----------------------

ORACLE error 20001 in FDPSTP

Cause: FDPSTP failed due to ORA-20001: BEN_91665_BENMNGLE_ERRORED: N, ORA_ERRCODE, -20001
ORA-06512: at "APPS.FND_MESSAGE", line 509
ORA-06512: at "APPS.BEN_MANAGE_LIFE_EVENTS", line 6454
ORA-06512: at "APPS.BEN_MANAGE_LIFE_E

The batch process BENMNGLE has hit the maxmium allowed errors.
ORA-20001: PQH_GSP_RAT_NOT_DFND:
----------------------------------------------------------------------
Benefits Statistical Information
----------------------------------------------------------------------
Processed persons     0
Errored persons       20
----------------------------------------------------------------------
The batch process BENMNGLE has reached an error status with oracle error code -20001, please consult the log to determine the cause of the errors.
+---------------------------------------------------------------------------+

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Recalculate Participation Values: Grade/Step Progression
2. Run for a particular Grade

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, grade step progression and salary increate cannot be updated via the application

Changes

Cause

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