GP BRA: Payslip BRA Ends in Error Depending on the Sort ID Used. (Doc ID 2330417.1)

Last updated on JUNE 21, 2021

Applies to:

Symptoms

Error running the payslip BRA:

ERROR
---

GPBRPS01
Payslip
V.2015-D
Report Began : 04:00:41
(SQR 5528) ORACLE OCIStmtExecute error 904 in cursor 11:
  ORA-00904: "A"."COMPANYB"."NAME_DISPLAY": invalid identifier
SQL: SELECT A.EMPLID, A.EMPL_RCD, A.EFFDT, A.EFFSEQ, B.NAME_DISPLAY,
  C.PAY_ENTITY, A.COMPANY, A.ESTABID, A.DEPTID, A.LOCATION, A.JOBCODE,
  A.DAILY_RT, A.SUPERVISOR_ID, A.GP_PAYGROUP, A.SETID_DEPT,
  A.SETID_JOBCODE, A.SETID_LOCATION, A.MONTHLY_RT FROM PS_JOB A, PS_NAMES
  B, PS_GP_PYGRP C WHERE A.EFFDT = (SELECT MAX(JJ.EFFDT) FROM PS_JOB JJ
  WHERE JJ.EMPLID = A.EMPLID AND JJ.EMPL_RCD = A.EMPL_RCD AND JJ.EFFDT
  <= :1) AND A.EFFSEQ = (SELECT MAX(J.EFFSEQ) FROM PS_JOB J WHERE
  J.EMPLID = A.EMPLID AND J.EMPL_RCD = A.EMPL_RCD AND J.EFFDT =
  A.EFFDT) AND A.EMPLID = B.EMPLID AND B.NAME_TYPE = 'PRI' AND
  B.EFFDT = (SELECT MAX(BB.EFFDT) FROM PS_NAMES BB WHERE BB.EMPLID =
  B.EMPLID AND BB.NAME_TYPE = B.NAME_TYPE AND BB.EFFDT <= :1) AND
  A.GP_PAYGROUP = :2 AND A.GP_PAYGROUP = C.GP_PAYGROUP AND A.EMPLID IN
  (SELECT EE.EMPLID FROM PS_GPBR_RC_PAY_EE EE WHERE EE.OPRID = 'RCRUZ'
  AND EE.RUN_CNTL_ID = 'R002' ) AND EXISTS (SELECT 'X' FROM
  PS_FAST_SQR_SEC_VW SCRTY WHERE SCRTY.EMPLID = A.EMPLID AND A.EMPL_RCD =
  SCRTY.EMPL_RCD AND SCRTY.OPRID = 'RCRUZ') ORDER BY
  A.COMPANYB.NAME_DISPLAY

Error on line 742:
  (SQR 3722) Could not set up cursor.

SQR for PeopleSoft: Program Aborting.

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.