My Oracle Support Banner

GP BRA: Error in Establishment BRA Page on SQL Server Database. (Doc ID 2536883.1)

Last updated on NOVEMBER 09, 2019

Applies to:

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

Symptoms

On Database-SQL Server, when attempting to search in the component ESTAB_TBL_BRA, the following error occurs:

ERROR
-----------------------
PSAPPSRV.16876 (49) [2019-03-26T11:13:06.893 PS@SRV-RH-HCM.pjmt.local (CHROME 72.0.3626.109; WIN10) ICPanel] tLOX935vxUNTgg 4930571544514894849 PS (3) File: E:\PT857P03B_1811162112-retail\peopletools\src\psppr\ramget.cppSQL error. Stmt #: 709 Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client 11.0][SQL Server]Conversion failed when converting date and/or time from character string. (SQLSTATE 22007) 241
Failed SQL stmt: SELECT ESTABID, EFFDT, (CONVERT(CHAR(10),EFFDT,121)) FROM PS_E_EFFDT_BRA_VW WHERE ESTABID=:1 ORDER BY ESTABID, EFFDT DESC

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate: HOME > Setup HCM > Product Related > Workforce Administration > Establishment BRA
2. Search for any Establishments and click in any of them. The error message will appear.


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!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.