"Participation Process: Absence" ORA-20001: BEN_91665_BENMNGLE_ERRORED and 'pqp_gb_osp_functions.chk_calendar_occurance{0}: ORA-06502: PL/SQL: numeric or value error: number precision too large' (Doc ID 1642601.1)

Last updated on JULY 18, 2016

Applies to:

Oracle Advanced Benefits - Version 12.1 HRMS RUP6 and later
Information in this document applies to any platform.

Symptoms

Concurrent request 'Participation Process: Absence' results in 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 6441
ORA-06512: at "APPS.BEN_MANAGE_LIFE_E

...
You must either Reverse the Termination and Reprocess this event
so that the entry can be created beyond 30-SEP-12 or you should de-enroll the participant so that the entry is ended on or before 30-SEP-12.
'pqp_gb_osp_functions.chk_calendar_occurance{0}: ORA-06502: PL/SQL: numeric or value error: number precision too large'
'pqp_gb_osp_functions.chk_calendar_occurance{0}: ORA-06502:



Steps to Reproduce:

  1. Use responsibility : UK HRMS Manager
  2. Navigation :processes and reports
  3. 1.submit new request - single request
  4. 'Participation Process: Absence'
    • Parameters
      • Run Mode :Absences
      • Validation Mode :No
      • Limit By Person's Organization :No
      • Benefit Action ID :53353
      • Effective Date :01/01/2011
      • Derivable Factors :Age, Service, Compensation, Hours Worked, Percent Full Time
      • Business Group ID :83
      • Program ID :All
      • Plan ID :All
      • Plan Type ID :All
      • Option ID :All
      • Just Plans not in Programs :Yes
      • Just Programs :No
      • Reporting Group :All
      • Eligiblity Profile :All
      • Variable Rate Profile :All
      • Person Selection Rule :None
      • Comp Object Selection Rule :None



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