Cloud Platform

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

HCM Extract - How can we achieve distinct in Etext template

SivaReddy MitnalaNov 5 2018 — edited Nov 14 2018

Hi,

We have developed extract to fetch job code,job name and position working hours .As job is attached to the multiple positions we have been using position UE as root data group and fetching job code,job name from the fast formulas by passing job_id.

in the etext output we are getting output like below

JOBCode1|JobName1|35.00

Because job is attached to the two positions.

Our requirment is we need to remove duplicates and want to print only once(distinct rows).

JOBCode1|JobName1|35.00

Please let me know if any one had faced this kind of requirement.We have gone through below post but no luck.

Thanks and Regards,

Siva

Added on Nov 5 2018

#cloud-applications, #hcm-cloud-service

18 comments

2,461 views

1 mention