You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Error while uploading talent pool and pool member

edited Aug 16, 2026 10:17AM in Career and Succession 1 comment

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!