Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Some useful SQLs for checking HDL data issues.
Summary
Some useful SQLs for checking HDL data issues.Content
The below SQLs are useful while loading HDL and this might help beginners who wants check the DM for loaded Data.
To check the SourceSystemID for the supervisor record for the given assignment number:
SELECT A.SOURCE_SYSTEM_ID
FROM HRC_INTEGRATION_KEY_MAP A
, PER_ASSIGNMENT_SUPERVISORS_F B
,PER_ALL_ASSIGNMENTS_M C
WHERE C.ASSIGNMENT_NUMBER='E72-2'AND A.SURROGATE_ID=B.ASSIGNMENT_SUPERVISOR_ID
AND C.ASSIGNMENT_ID=B.ASSIGNMENT_ID;
This table gives the detail of the SourceSystemIDs that are loaded through HDL or created via online
Tagged:
13