Benefits Administration Error: ORA-03113 When Selecting the Option Code After Upgrading to Oracle 11.2

(Doc ID 1068434.1)

Last updated on APRIL 25, 2016

Applies to:

PeopleSoft Enterprise HRMS Benefits Administration - Version 9.1 to 9.1 [Release 9.0]
Information in this document applies to any platform.

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, %DateOut(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<=%DATEIN(: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

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