Error while uploading talent pool and pool member
Summary:
Hello Experts,
once i uploade the HDL for talent pool i get
The record referenced by the OwnerPersonId foreign key attribute wasn't found. You need to either specify a valid foreign key or first create the referenced record.
Any advice i used this SQL to get data
SELECT
papf.person_id,
papf.person_number,
hpss.source_system_owner,
hpss.source_system_id
FROM
per_all_people_f papf
JOIN hrc_integration_key_map hpss
ON hpss.surrogate_id = papf.person_id
WHERE
papf.person_number = '123456'
AND TRUNC(SYSDATE) BETWEEN papf.effective_start_date
AND papf.effective_end_date
Tagged:
0