My Favorite Jobs Error: "Error in PeopleCode ScrollSelect processing (2,213) HRS_APP_SVDJB_SEC.Activate" (Doc ID 1993426.1)

Last updated on DECEMBER 16, 2015

Applies to:

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

Symptoms

When applicants choose a Favorite job and the Status of the job posting is later changed, the applicant can no longer access My Favorite Jobs section. The system throws in a SQL error followed by a PeopleCode Activate error. The issue occurs when the status of all Favorite jobs is closed for a given applicant.

The issue can be reproduced at will with the following steps:

1. Go to my Internal Careers and add a job opening to My Favorite Jobs clicking the star icon.
2. Go to the Search Job Opening page and search for the job just added.
3. Close the Job Opening.
4. Go to My Favorite Jobs link.
5. An error message is displayed.

"A SQL Error has occured"

"Error in PeopleCode ScrollSelect processing (2,213) HRS_APP_SVDJB_SEC.Activate"

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms