Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Duplicate rows on HDL Transformation fast formula
I have a requirement to read the ethnicity information from a third-party system and create worker files accordingly.
Below is the snippet from the HCM data loader Fast formula.
If the input file has multiple ethnicities for the Worker and if it satisifies LINEREPEATNO 15 and 17 conditions, it is creating 3 rows like below instead of two rows. Can some one help where are we doing wrong on the fast formula?
HDL Generated:
Fast Formula snippet:
IF LINEREPEATNO = 15 THEN
(
FileName = 'Worker'
BusinessOperation='MERGE'
FileDiscriminator='PersonEthnicity'
"PersonId(SourceSystemId)" = 'PW_'||SocialSecurityNumber||''||LastName
LegislationCode='US'
Ethnicity1 = POSITION20
if Ethnicity1 = 'Y' then
(
PrimaryFlag = 'N'
0