Person profile does not have Source System ID and Source System Owner
Summary:
Hi Expert,
i have query simple for get source_system_id and source_system_owner from person profile/talent profile like below
SELECT pi.profile_item_id, hikm.source_system_id, hikm.source_system_owner
FROM hrt_profile_items pi, hrc_integration_key_map hikm
WHERE pi.profile_item_id = hikm.surrogate_id(+)
AND hikm.object_name(+) = 'ProfileItem'
AND hikm.source_system_id IS NULL;
but there are some personal profile data that don't have source system id and source_system_owner.
even though I need the data to update the person profile data using HDL.
are any of you experiencing the same problem?
8