HRS_APP_PROFILE Contains Only 1 Row When Applicant has Applied for 1 Job Opening and has been Linked to Another Job Opening (Doc ID 1479521.1)

Last updated on NOVEMBER 15, 2016

Applies to:

PeopleSoft Enterprise HCM Talent Acquisition Manager - Version 9 and later
Information in this document applies to any platform.
***Checked for relevance on 10-Jan-2014***

Symptoms

Applicant 'A' has applied Job Opening 'J1' and Linked Job Opening 'J2'

Case 1 :
SELECT * FROM PS_HRS_APP_PROFILE WHERE HRS_PERSON_ID = 'A';
The above query - HRS_APP_PROFILE record will return only 1 row, instead of 2 rows (2 rows - one for Applied 'J1' and other for Linked 'J2')

Case 2 :
SELECT * FROM PS_HRS_RCMNT WHERE HRS_PERSON_ID = 'A'
The above query - HRS_RCMNT record has 2 rows for both the Job Openings, but the HRS_PROFILE_SEQ will be '1' for both the Job Openings.

 

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