Benefits Administration Error: ORA-03113 When Selecting the Option Code After Upgrading to Oracle 11.2 (Doc ID 1068434.1)

Last updated on FEBRUARY 28, 2023

Applies to:

Symptoms

Benefits Administration Open Enrollment Information Center > Troubleshooting Benefits Administration > Troubleshooting Benefits Administration Errors

On PeopleTools 8.50 and Oracle 11.2.01 database when selecting the look up an option code, using OnDemand, the following error occurs:

Navigation:  Benefits > Manage Automated Enrollment > Events > On-Demand Maintenance

On the option election tab, select an option:

ERROR
-----------------------
PSAPPSRV.11941 (235) 1-2 16.03.45 8300.286835 SQL error. Function: SQLExec
Error Position: 0
Return: 3113 - ORA-03113: end-of-file on communication channel Process ID: 16731 Session ID: 77 Serial number: 11
Statement: SELECT O.CROSS_PLAN_TYPE, O.CROSS_BENEF_PLAN, O.CROSS_PLN_DPND_CHK, O.COVERAGE_LIMIT_PCT, TO_CHAR(B.EFFDT,'YYYY-MM-DD') FROM PS_BEN_DEFN_PGM B, PS_BEN_DEFN_PLAN P, PS_BEN_DEFN_OPTN O WHERE B.BENEFIT_PROGRAM=:1 AND B.EFFDT<=TO_DATE(:2,'YYYY-MM-DD') AND P.BENEFIT_PROGRAM=B.BENEFIT_PROGRAM AND P.EFFDT=B.EFFDT AND P.PLAN_TYPE=:3 AND O.BENEFIT_PROGRAM=P.BENEFIT_PROGRAM AND O.EFFDT=P.EFFDT AND O.PLAN_TYPE=P.PLAN_TYPE AND O.OPTION_ID=:4 ORDER BY B.EFFDT DESC
Original Statement: SELECT O.CROSS_PLAN_TYPE, O.CROSS_BENEF_PLAN, O.CROSS_PLN_DPND_CHK, O.COVERAGE_LIMIT_PCT, ÚteOut(B.EFFDT) FROM PS_BEN_DEFN_PGM B, PS_BEN_DEFN_PLAN P, PS_BEN_DEFN_OPTN O WHERE B.BENEFIT_PROGRAM=:1 AND B.EFFDT<=ÚTEIN(:2) AND P.BENEFIT_PROGRAM=B.BENEFIT_PROGRAM AND P.EFFDT=B.EFFDT AND P.PLAN_TYPE=:3 AND O.BENEFIT_PROGRAM=P.BENEFIT_PROGRAM AND O.EFFDT=P.EFFDT AND O.PLAN_TYPE=P.PLAN_TYPE AND O.OPTION_ID=:4 ORDER BY B.EFFDT DESC

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.