GP BRA: Employee Registry BRA Error When Running In SQL Server.

(Doc ID 2176557.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

PeopleSoft Enterprise HCM Global Payroll Brazil - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Employee Registry Report BRA.

ACTUAL BEHAVIOR
---------------
When executing the Employee Registry Report BRA report, the following error occurs:

PeopleTools 8.55.03 - Application Engine Server
Copyright (c) 1988-2016 Oracle and/or its affiliates.
All Rights Reserved


PSAESRV started service request at 12.17.40 2016-08-01


File: E:\pt85503b-retail\peopletools\src\pssys\qpm.cppSQL error. Stmt #: 7838 Error Position: 0 Return: 8603 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Executing SQL directly; no cursor.
[Microsoft][SQL Server Native Client 11.0][SQL Server]'TO_DATE' is not a recognized built-in function name.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Sta
Failed SQL stmt: SELECT A.EMPLID, A.EMPL_RCD, A.REG_NUMBER_BRA, A.ADDRESS1, A.ADDRESS2, A.ADDRESS3, A.ADDRESS4, A.NUM1, A.CITY, A.STATE, A.POSTAL, (CONVERT(CHAR(10),A.TERMINATION_DT,121)), (CONVERT(CHAR(10),A.SERVICE_DT,121)), (CONVERT(CHAR(10),A.GPBR_FGTS_DT,121)), A.STD_HOURS, A.COMPRATE, A.HOURLY_RT, A.GP_PAYGROUP, A.POSITION_NBR, A.DESCR1, A.ESTABID, A.DESCR, A.JOB_FUNCTION, (CONVERT(CHAR(10),A.DUR,121)), A.NAME, A.CONT_SAL_TYPE_BRA, A.DES_SAL_TYPE_BRA, A.NID_CPF_BRA, A.NID_CRES_BRA, A.NID_CTPS_BRA, A.NID_PIS_BRA, A.NID_RG_BRA, A.NID_TITEL_BRA, A.NID_ESTRAN_BRA, A.PASSPORT_NBR, (CONVERT(CHAR(10),A.DT_ISSUED,121)), A.BIRTHCOUNTRY, A.SETID_JOBCODE, A.JOBCODE, A.DESCRSHORT, B.EMPLOYEE_PHOTO, C.SEX, (CONVERT(CHAR(10),C.BIRTHDATE,121)), C.BIRTHPLACE, C.BIRTHSTATE, C.RG_ISSUEDBY_BRA, (CONVERT(CHAR(10),C.RG_ISSUED_DT_BRA,121)), C.RG_STATE_BRA, C.CTPS_SERIES_BRA, (CONVERT(CHAR(10),C.CTPS_EXP_DT_BRA,121)), C.VOTER_ZONE_BRA, C.VOTER_SECTION_BRA, (CONVERT(CHAR(10),C.PIS_PASEP_DT_BRA,121)), C.NAME_FORMAL, C.NAME, C.VISA_WRKPMT_NBR, C.VISA_WRKPMT_STATUS, C.DES_VISA_STAT_BRA, (CONVERT(CHAR(10),C.ENTRY_DT,121)), C.DRIVERS_LIC_NBR, (CONVERT(CHAR(10),C.VALID_FROM_DT,121)), (CONVERT(CHAR(10),C.EXPIRATN_DT,121)), C.MAR_STATUS, C.DES_MAR_STA_BRA, C.EDUCATION_LVL_BRA, C.DES_EDU_LVL_BRA, C.DES_NATIONAL_BRA, C.NUM_BRACHILD_BRA, C.NUM_CHILDREN_BRA, D.ESTAB_ID_BRA, D.COUNTY_CD_BRA, D.DESCR, D.ADDRESS1, D.ADDRESS2, D.ADDRESS3, D.ADDRESS4, D.NUM1, D.CITY, D.STATE, D.POSTAL, D.SETID_LOCATION, D.LOCATION, D.DESCRSHORT, D.LEGAL_ENT_TYPE_BRA, D.DESCR1, A.CBO_CD_BRA, C.VISA_PERMIT_TYPE, C.DESCR2, (CONVERT(CHAR(10),C.EXPIRATION_DT,121)), (CONVERT(CHAR(10),C.RG_END_DT_BRA,121)), (CONVERT(CHAR(10),C.CTPS_END_DT_BRA,121)), C.CTPS_STATE_BRA, C.MIL_CERT_TYPE_BRA, C.DESCR3, C.ISSUED_BY_FRA, C.ISSUE_DEST_FRA, C.LICENSE_TYPE, C.DESCR4, C.DES_MILITA_CAT_BRA, C.MILITAR_CAT_BRA, to_char(to_date( (CONVERT(CHAR(10),A.DUR,121)),'YYYY-MM-DD'),'D'), C.NATIONALITY_CD_BRA, C.SPOUSE_IND_BRA, C.CHILDREN_IND_BRA, (CONVERT(CHAR(10),C.NATURAL_DT_BRA,121)), A.DESCR254, C.NATIONAL_ID_FLG FROM (PS_EMPL_REG_T1_BRA A LEFT OUTER JOIN PS_EMPL_PHOTO B ON A.EMPLID = B.EMPLID ), PS_EMPL_REG_T2_BRA C, PS_EMPL_REG_T3_BRA D WHERE ( A.OPRID = 'PS' AND C.OPRID = 'PS' AND D.OPRID = 'PS' AND ( A.OPRID = :1 AND A.RUN_CNTL_ID = :2 AND A.OPRID = C.OPRID AND A.RUN_CNTL_ID = C.RUN_CNTL_ID AND A.EMPLID = C.EMPLID AND A.OPRID = D.OPRID AND A.RUN_CNTL_ID = D.RUN_CNTL_ID AND D.ESTABID = A.ESTABID )) ORDER BY 1

Error in running query because of SQL Error, Code=8603, Message=[Microsoft][SQL Server Native Client 11.0][SQL Server]Executing SQL directly; no cursor.
[Microsoft][SQL Server Native Client 11.0][SQL Server]'TO_DATE' is not a recognized built-in function name.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Sta (50,380)

Parent query %1 returned no rows. (241,248) PT_CONQRS.CONQRSMGR.OnExecute Name:Run PCPC:22632 Statement:531

Called from:PSXP_RPTDEFNMANAGER.ReportDefn.OnExecute Name:GenerateXmlFileFromConnQuery Statement:2279

Called from:PSXP_RPTDEFNMANAGER.ReportDefn.OnExecute Name:ProcessReport Statement:1471

Called from:BREREG02.RUNCNTL.GBL.default.1900-01-01.Step03.OnExecute Name:ExecXmlpQryReport Statement:47

Called from:BREREG02.RUNCNTL.GBL.default.1900-01-01.Step03.OnExecute Statement:85
Application Engine program BREREG02 ended normally

PSAESRV completed service request at 12.17.55 2016-08-01

Even correcting the error, when logged in Portuguese, the reports is generated in English and without photo.



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