My Oracle Support Banner

GP BRA: Employee Registry BRA Error When Running In SQL Server. (Doc ID 2176557.1)

Last updated on MAY 11, 2018

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.



Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.