GPCHE: Error "A SQL error occurred. Please consult your system log for details." on Personal Data Page when Making an Address Change Where the Town Has an Apostrophe in the Name
(Doc ID 2859836.1)
Last updated on FEBRUARY 12, 2024
Applies to:
PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
Following SQL error occurs in Personal Data page when making an Address Change where the Town has an apostrophe in the name:
A SQL error occurred. Please consult your system log for details.
The Appserver Log file shows the error occurs in following SQL statement:
Return: 8012 - Invalid syntax in SQL statement
Statement: SELECT FILL.POSTAL,FILL.CITY,FILL.STATE,FILL.MUNICIPALITYCD_CHE,TO_CHAR(FILL.EFFDT,'YYYY-MM-DD'),FILL.EFF_STATUS,FILL.DESCR FROM PS_VILLAGE_CHE_VW FILL WHERE POSTAL = '1341' AND CITY = 'L'ORIENT' AND STATE = 'VD' AND ïFDTCHECK(VILLAGE_CHE_VW, FILL, %CURRENTDATEIN) AND EFF_STATUS = 'A' AND MUNICIPALITYCD_CHE = '5872'
Original Statement: %SelectAll(:1 FILL) Where POSTAL = '1341' and CITY = 'L'Orient' and STATE = 'VD' and ïfDtCheck(VILLAGE_CHE_VW, FILL, %CurrentDateIn) and EFF_STATUS = 'A' and MUNICIPALITYCD_CHE = '5872'
PSAPPSRV.62968 (8422) [2021-11-03T09:52:51.021 PS@10.247.131.202 (CHROME 92.0.4515.107; WIN10) ICPanel] hqvmu07+fS3PMw 2410026173791114241 PS (0) Exception happend in CScrollObjRef::Fill method(), pszWhere= Where POSTAL = '1341' and CITY = 'L'Orient' and STATE = 'VD' and ïfDtCheck(VILLAGE_CHE_VW, FILL, %CurrentDateIn) and EFF_STATUS = 'A' and MUNICIPALITYCD_CHE = '5872'
Statement: SELECT FILL.POSTAL,FILL.CITY,FILL.STATE,FILL.MUNICIPALITYCD_CHE,TO_CHAR(FILL.EFFDT,'YYYY-MM-DD'),FILL.EFF_STATUS,FILL.DESCR FROM PS_VILLAGE_CHE_VW FILL WHERE POSTAL = '1341' AND CITY = 'L'ORIENT' AND STATE = 'VD' AND ïFDTCHECK(VILLAGE_CHE_VW, FILL, %CURRENTDATEIN) AND EFF_STATUS = 'A' AND MUNICIPALITYCD_CHE = '5872'
Original Statement: %SelectAll(:1 FILL) Where POSTAL = '1341' and CITY = 'L'Orient' and STATE = 'VD' and ïfDtCheck(VILLAGE_CHE_VW, FILL, %CurrentDateIn) and EFF_STATUS = 'A' and MUNICIPALITYCD_CHE = '5872'
PSAPPSRV.62968 (8422) [2021-11-03T09:52:51.021 PS@10.247.131.202 (CHROME 92.0.4515.107; WIN10) ICPanel] hqvmu07+fS3PMw 2410026173791114241 PS (0) Exception happend in CScrollObjRef::Fill method(), pszWhere= Where POSTAL = '1341' and CITY = 'L'Orient' and STATE = 'VD' and ïfDtCheck(VILLAGE_CHE_VW, FILL, %CurrentDateIn) and EFF_STATUS = 'A' and MUNICIPALITYCD_CHE = '5872'
Steps to replicate the issue:
1. Go to Personal Data ->Contact Information, choose an employee with a Swiss address format
2. Click to add an address with a new Effective Date
3. Choose a postal code for a town with an apostrophe in the name (L’Orient)
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 |
| Cause |
| Solution |
| References |