Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Multiple rows in HCM Extract based on conditions
Summary
Multiple Rows in HCM ExtractContent
Hi,
I need to pull 2 rows in HCM extracts based on below conditions.
a. In case for both Assignment and Absence record where effective start date is same then single row will be displayed in file with that effective date.
b. In case for both Assignment and Absence record where effective start date is different then two different rows will be added in file. One with ‘Effective Date’ value as ‘Assignment Effective Start Date’ and another with ‘Effective Date’ value as ‘Absence Start Date’.
Can you please give some ideas on how to achieve it.
Tagged:
0