COBRA Administration Error: No Benefit Programs Found (Doc ID 1913343.1)

Last updated on FEBRUARY 29, 2016

Applies to:

PeopleSoft Enterprise HRMS Human Resources - Version 9 and later
Information in this document applies to any platform.

Symptoms

 The COBRA Administration process errors with the following:


No Benefit Programs Found

Application Program Failed
In Pgm Section  : GET-PROGRAMS                                        

Application Program Failed
In Pgm Section  : TABLE-ACCESS(PSPBATBL)                              

COBRA did not finish at 11:28:28.26 !!!!!


The last select statement executed is:

SELECT A.BENEFIT_PROGRAM ,A.EFFDT ,B.ELIG_RULES_ID ,C.EFFDT ,B.LOCATION_TBL_ID ,A.DFLT_CREDIT_RLLOVR ,A.EFF_STATUS ,A.PROGRAM_TYPE
FROM PS_BEN_DEFN_PGM A ,PS_BEN_DEFN_OPTN B ,PS_BAS_ELIG_RULES C
WHERE B.BENEFIT_PROGRAM=A.BENEFIT_PROGRAM AND B.EFFDT=A.EFFDT AND B.PLAN_TYPE='01' AND B.OPTION_TYPE='P' AND C.ELIG_RULES_ID=B.ELIG_RULES_ID AND C.EFFDT= (SELECT MAX(D.EFFDT) FROM PS_BAS_ELIG_RULES D WHERE D.ELIG_RULES_ID=C.ELIG_RULES_ID )
ORDER BY A.BENEFIT_PROGRAM ASC ,A.EFFDT DESC

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