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.
Company Parameter in HCM Extracts
Summary
Criteria to be added for Company parameter in HCM ExtractContent
Hi All,
We are creating a custom Extract to pull all active employees in any company based on the company paramater selected at runtime. We used the below Criteria Condition:
EXISTS(SELECT 1
FROM
HR_ORGANIZATION_UNITS_F_TL LE
WHERE
ASG.LEGAL_ENTITY_ID=LE.ORGANIZATION_ID
AND (LE.NAME=pay_report_utils.get_parameter_value('COMPANY'))
AND SYSDATE BETWEEN LE.EFFECTIVE_START_DATE AND LE.EFFECTIVE_END_DATE
)
But we also need to fetch all companies when the company parameter is left blank. We get performance issue when we try to handle this in the Criteria as shown below:
0