How to get UNION_ID for an employee in FAW? It is not present in assignment table:dw_wrkfrc_asg_f.

Question

Is there a way to bring UNION_ID for an employee in FAW? Not able to find a suitable PVO to bring the value through data augmentation. Please suggest.

Mallikarjuna Kuppauru-Oracle · Answer

Hi @User_JS1AB

I didnt see UNION_ID column from data lineage  document.

https://docs.oracle.com/en/cloud/saas/analytics/24r1/fahia/chapter-data-lineage.html#GUID-69B6BE1A-183B-4F76-B211-7A9295AA1D02

For finding the correct PVO please connect with below forum, PVO owners are Fusion team.

https://community.oracle.com/customerconnect

Regards,

Arjun

Subha_Tripathy-Oracle · Answer

Hi @User_JS1AB

Thank you for visiting and posting in Fusion Analytics Warehouse(FAW) Product Community Page

For all PVO related questions, please post in :

https://community.oracle.com/customerconnect/categories/fusion-apps-administration-forum

Thanks

Subha