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.
Session Variables are not working in Person Security Profile Custom Criteria
Hello Experts
We have a requirement to give access to Logged In User's Legal Entity employees in Public Person Profile. We are using following SQL in custom criteria.
&TABLE_ALIAS.PERSON_ID IN
(SELECT PERSON_ID
FROM PER_PERIODS_OF_SERVICE PPOS
WHERE LEGAL_ENTITY_ID IN (SELECT LEGAL_ENTITY_ID
FROM PER_PERIODS_OF_SERVICE PPOS1
WHERE PPOS1.person_id = HRC_SESSION_UTIL.GET_USER_PERSONID
AND NVL(PPOS1.ACTUAL_TERMINATION_DATE, TO_DATE('47121231', 'YYYYMMDD')) >= TRUNC(SYSDATE))
)
This query is working fine in BI Publisher but not giving desired results when applied in Security Profile.
Please help on how to achieve this requirement.
Tagged:
0