Health Plan Participants Report Error: (SQR 5528) ORACLE OCIStmtExecute error 933 in cursor 48: (Doc ID 823546.1)

Last updated on FEBRUARY 01, 2017

Applies to:

PeopleSoft Enterprise HRMS Human Resources - Version 8.9 to 9.1 [Release 8.9 to 9]
Information in this document applies to any platform.

Symptoms

While running the 'Health Plan Participants Rpt" (BEN001.sqr) through navigation: (Benefits, Reports, Participation, Health Plan Participants) for a non-base language, receive the following error message:

ERROR
-----------------------
Report ID: Health Plan Participants
(SQR 5528) ORACLE OCIStmtExecute error 933 in cursor 48:
ORA-0933: la commande SQL ne se termine pas correctement
SQL: SELECT DISTINCT FIELDVALUE, XLATSHORTNAME FROM PSXLATITEM A WHERE
A.FIELDNAME='PLAN_TYPE' And A.EFFDT = (Select Max(D.EFFDT) From
PSXLATITEM D WHERE D.FIELDVALUE = A.FIELDVALUE AND D.FIELDNAME =
A.FIELDNAME and D.EFFDT <= '27-APR-2009' )And A.FIELDVALUE Not In
(Select B.FIELDVALUE From PSXLATITEMLANG B Where
B.FIELDNAME='PLAN_TYPE' And B.LANGUAGE_CD='ENG') UNION Select Distinct
C.FIELDVALUE, C.XLATSHORTNAME From PSXLATITEMLANG CWhere
C.FIELDNAME='PLAN_TYPE' And C.LANGUAGE_CD='ENG' AND C.EFFDT = (SELECT
MAX(E.EFFDT) FROM PSXLATITEMLANG E WHERE E.FIELDVALUE = C.FIELDVALUE AND
E.FIELDNAME = C.FIELDNAME and EFFDT <= '27-APR-2009' )

Error on line 49:
(SQR 2605) Cannot compile SQL for LOAD-LOOKUP table 'plan-types'.

SQR for PeopleSoft: Program Aborting.

STEPS
-----------------------
By following these steps the issue can be reproduced:
1. Goto: Main Menu > Benefits > Reports > Participation> Health Plan Participants
2. Add a new Run Control ID
3. Select Language as a non base language, for example, Canadian French, French etc.

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