HCM 9.2 : When Registering a New User on the Careers Page With Address Required, SQL Error Is Triggered: "A SQL error occurred. Please consult your system log for details"
(Doc ID 2781941.1)
Last updated on JUNE 07, 2021
Applies to:PeopleSoft Enterprise HCM Candidate Gateway - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
When the Display and Required Address are set to “Yes” on the Recruiting Installation table, while a new applicant registers and fills in the required address after clicking on Register the following SQL error occurs.
Steps to replicate the issue:
Navigate to Set Up HCM > Install > Product Specific > Recruiting Installation > Applicants
1. Navigate to Set Up HCM > Install > Product Specific > Recruiting Installation > Applicants
Set 'Display Address' and 'Address Required' to Yes
2. Access the Careers page (Navigator > Careers)
3. Click the New User link
4. Complete the registration with the minimum required fields: - User Name - Password - Confirm Password - First Name - Last Name
5. Check to "Agree to the terms and conditions" and click Register
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