My Oracle Support Banner

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

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