HRS_APP_PROFILE Contains Only 1 Row When Applicant has Applied for 1 Job Opening and has been Linked to Another Job Opening
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***
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms