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
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.

Company Parameter in HCM Extracts

edited May 16, 2019 5:03PM in HCM Integrations 2 comments

Summary

Criteria to be added for Company parameter in HCM Extract

Content

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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