1,515 total views
However out of my enthusiasm, I searched for options to get that HDL file from staging tables and finally figured out a way to get it using BI Report. Below is the SQL that need to be used on Data Model to get the HDL file as output.
SELECT fl.TEXT ,bo.data_file_name FROM fusion.hrc_dl_file_lines fl ,fusion.hrc_dl_data_set_bus_objs bo ,fusion.hrc_dl_data_sets ds WHERE ds.ucm_content_id = 'UCMFA00014838' --Replace this with the actual contentid AND fl.data_set_bus_obj_id = bo.data_set_bus_obj_id AND ds.data_set_id = bo.data_set_id ORDER BY fl.seq_num ASC
If you have any questions, please feel free to reach out to me by posting in comments section.
If you are interested in learning Fusion Technical tools go through this post
If you liked the article, please share it with your friends/ colleagues/ teammates or anyone who might also benefit from it.
Latest posts by Sricharan Monigari (see all)
- Renaming HCM Extracts is a possibility from 20D - November 24, 2020
- Sangam20 – Oracle Users Group Conference - November 23, 2020
- Passing Parameter values from Flow Instance to HDL Transformation Formula - November 23, 2020
- Solve manual FTP server update issue for HCM Extracts post every P2T refresh - November 16, 2020