Getting Users Assets information from Oracle Fusion

Mohammed Hanzala

Hello,

We have an assets report that show the IT assets assigned to each user in the organization. This report was developed from Oracle E-business on premise version. Recently, we migrated from Oracle E-business to Oracle Fusion and need to update or create a new report from Oracle Fusion. The E-business report output is attached. I want to develop similar report using BI Publisher but I am unable to identify the appropriate tables and columns that can give me the required information. How can I know the fusion table(s) and their relationships and the column names that can help to get the required fields?

My Assets Report.JPG

I would like to get this information so that I can write a query and use BI Publisher to develop the desired report.

Regards,

Mohammed Hanzala

Hassan El Bouihi-Oracle

Hello Mohammed,

Please use this document for table information:

https://docs.oracle.com/en/cloud/saas/financials/24a/oedmf/

Thank you

Hassan