My Oracle Support Banner

The Job Opening Recruiting Locations Got Deleted From HRS_JO_LOC but Not From HRS_JOB_OPENING (Doc ID 2737917.1)

Last updated on DECEMBER 20, 2022

Applies to:

PeopleSoft Enterprise HCM Talent Acquisition Manager - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


When a user deletes the recruiting location from a Job Opening that is saved as Draft, it got deleted from HRS_JO_LOC, but not from HRS_JOB_OPENING.

Steps to replicate the issue:

  1. Navigate to Recruiting > Create a job opening : Add a new Location and mark it as the 'Primary Location' and Save the JO as Draft
  2. Navigate to Reporting Tools > Query > Query Manager: Ensure that the HRS_PRM_LOCATION is updated correctly in HRS_JOB_OPENING
  3. Navigate to Recruiting > Search Job Openings: Access the Job Opening saved at step 1 as a Draft and delete the Location




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.