Whatever column is using that lookup in HWM_TM_REC table, join that using lookup_code in fnd_lookup_values. Thanks.

Hi Harsh, There is an idea raised already to expose backend tables: https://community.oracle.com/products/oracleanalytics/discussion/20052/expose-table-for-bursting-output-results/p1 I would suggest to evaluate the existing idea, upvote there and close this idea. Thanks.

Hi Neha, The forum is specific to Oracle HCM Analytics (HCM FAW/FDI). Please post your query on customer connect for better traction and support. Welcome to Cloud Customer Connect Thanks.

To enhance data security for customers, this feature should be included.

Welcome to Oracle analytics query. It will be helpful for community members if you can share some more details on what exact attributes you are looking for. You just have mentioned the module names which have too many tables/objects/columns. Thanks.

Exciting new feature !!!

Hi Vijay, This is not supported currently. In case you want to merge data between external API and fusion, then you need to have a middleware and a DB where you can push the data from both the systems and merge it. Thanks.

Are you using WITH clause? If yes, below might be applicable for your scenario as well: OAS Manual Query Error [nQSError: 10058] — Oracle Analytics Thanks.

Hi, Welcome to Oracle Analytics community. Do you have a specific question? If yes, please update your post with correct description. Thanks.

Hi Neha, Do you mean on the fusion SaaS side, you see two user accounts for same rehired worker with same user name? And it causes issues into FDI import? Thanks.

Hi Diane, Is your issue resolved yet? Or still you are facing an issue? I can then try to loop in some product team members. Thanks.

Hi Claudia, You can check the query on below link: Thanks.

So many amazing features were added this year, and I can genuinely feel how much they've enriched our community experience. It’s been a joy to be part of this journey. Huge thanks to the entire team—your hard work truly shines through. Great job! Thanks.

Hi @Diane G123 , Welcome to Oracle Analytics community. Is your issue resolved yet? If no, can you try to use As of date prompt concept and see if that works? OTBI Report as on effective date — Cloud Customer Connect Thanks.

Hi Vishwas, Welcome to Oracle Analytics community. Can you please confirm if you have the required access to view the requested data? Benefits - Enrollments Real Time Thanks.

Hi Alex, Welcome to Oracle Analytics community. Can you please confirm if you are trying to fetch JRs linked to a particular JR? If yes, it won;t be possible directly. You will need to either write a logical SQL or BIP. Thanks.

Hi Diba, Welcome to Oracle Analytics community. This is not possible currently. Thanks.

Hi Bishoy, Welcome to Oracle Analytics community. You can check BIP query given on below link: Thanks.

Hi Abhishek/All, This is not supported yet. An idea has already been logged. Please review and upvote: Report that provides a list of permissions for all folders in BI Catalog — Oracle Analytics Thanks.

Hi, Can you please specify the product where you are looking to find this information? Is it fusion analytics (FAW/FDI) or fusion SaaS? Thanks.