GP BRA: MANAD Report - Error in SQL (Perhaps Missing &Name After Expression). (Doc ID 2237211.1)

Last updated on MAY 03, 2017

Applies to:

PeopleSoft Enterprise HCM Global Payroll Brazil - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When trying to generate MANAD file we get the error on GPBRMA01 process:

ERROR
-----------------------
(SQR 1303) Error in SQL (perhaps missing &name after expression):
SELECT TK150.GPBR_MAN_ROW_TYPE, TK150.ESTAB_ID_BRA, ED1.EFFDT, PN.PIN_NM,
CASE WHEN PNL.DESCR IS NOT NULL THEN PNL.DESCR ELSE PN.DESCR END FROM
PS_GP_PIN PN LEFT OUTER JOIN PS_GP_PIN_LANG PNL ON PN.PIN_NUM = PNL.PIN_NUM
AND PNL.LANGUAGE_CD = ? LEFT OUTER JOIN PS_GPBR_MANAD_TMP1 TK150 ON
TK150.PIN_NUM = PN.PIN_NUM LEFT OUTER JOIN PS_GP_ERN_DED ED1 ON ED1.PIN_NUM
= PN.PIN_NUM WHERE TK150.GPBR_MAN_ROW_TYPE = 'K150' AND
TK150.PROCESS_INSTANCE = ? AND ED1.EFFDT = ( SELECT MAX(ED2.EFFDT) FROM
PS_GP_ERN_DED ED2 WHERE ED2.PIN_NUM = ED1.PIN_NUM AND ED2.EFFDT <= ?) ORDER
BY TK150.ESTAB_ID_BRA, TK150.EFFDT, TK150.GPBR_MAN_TEXT
(SQR 1304) Check SELECT columns, expressions and 'where' clause for syntax.

SQR for PeopleSoft: Program Aborting.



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