My Oracle Support Banner

When Trying to Update Emergency Contact via Admin Component it Triggers the error " A SQL error occurred. Please consult your system log for details." (Doc ID 3021808.1)

Last updated on MAY 14, 2024

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


The following error is triggered when trying to update Emergency Contact via the Admin component:

Error message on online page:
  A SQL error occurred. Please consult your system log for details.

Error message in trace file: 

ErrorReturn-> 270 - Class Row method GetRowset scroll EO_UPDADDR_DVW is invalid. (2,270) EO.CA.Address.OnExecute Name:BuildEmptyAddressEditRowset PCPC:52171 Statement:851
Called from:EO.CA.Address.OnExecute Name:PopulateAddressEditRowset Statement:807
Called from:EO.CA.Address.OnExecute Name:SetCountrySpecificAddressFields Statement:127
Called from:EO.CA.Address.OnExecute Name:AddressEditPageActivate Statement:414
Called from:EO_ADDR_USA_SEC.Activate Statement:2

Steps to reproduce the issue:
1. Navigate to Workforce Administration > Personal Information > Personal Relationships > Emergency Contact
2. Searched with KU0001 = this employee ID from DEMO - this is fictitious data.
3. Uncheck the "Same Address as Employee", then select USA as the country.
4. Click the "Edit Address" button and the above error message.


NOTE: The above employee ID represents a fictitious sample (based upon made-up data used in the Oracle Demo Vision instance). Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.


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

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