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

Person profile does not have Source System ID and Source System Owner

Accepted answer
55
Views
2
Comments

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?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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