@RajeshSai99 , Thanks for letting me know.

@Marilyn Keating-Oracle , It is obvious you are getting this error because in Oracle FDI, AP invoices and AR invoices do not share any natural join key. It is better to aggregate both datasets independently before comparing. Hope it helps!

Also, please refer this oracle blog that summarizes the principal use cases into Fusion Cloud ERP, Fusion Cloud EPM, and Fusion Data Intelligence (FDI) and how they integrate with Cloud ERP. Its objective is to help you define your enterprise reporting strategy. Hope it helps!

@Sean-B-01 , As a service administrator, you can use the Fusion Data Intelligence extract service to acquire data from the Enterprise Performance Management (EPM) SaaS instance and use it to create data augmentations for various Enterprise Resource Planning and Supply Chain Management use cases. You can connect to these…

@Jaydeep Puranik-Oracle , appreciate if you can confirm if it is available for standalone OAC instance.

@Lalitha Venkataraman-Oracle , @Prasenjit_Thakur-Oracle , thx for sharing, very useful extension. Appreciate it.

@s.datta , I believe Reset and Reload will solve this issue. In general, these are recommended Best Practices after every P2T: Pause pipelines Validate connection Reset extract dates Run Full Reload Reconcile balances Resume incremental Hope it helps!

@User_2JL26 , you can reach out to Rasta Ghafouri-Oracle and she will resolve it. Hope it helps!

@Dhaval Parikh Stantec , I liked your approach of checking the row count and making sure that it is under the threshold before executing the report query. I do not think there is any native mechanism in DV platform besides Max Rows and Max Time. Thanks

@User_QX8AN , Welcome to the Oracle Analytics Community! The Oracle Cloud Applications Exam Subscription (USD 245) is the correct item you need to buy. After purchase, you assign that credit to the FDI Implementation Professional exam (1Z0-1128-24) in your certification account. Then you schedule the exam date/time. Feel…

@Paolo Ernesto Paolucci-Oracle , very insightful and great presentation, thx for sharing.

@jsmithA , as mentioned above, better to put it in the correct forum to get the accurate and latest updates from SMEs. Thanks for the understanding!

@Shyam Patel, appreciate this sql in this forum. This forum was last updated in 2024. As per community guidelines, it will be best to avoid the comments in the old post. Please feel free to share it in Oracle Analytics and AI Sharing Center — Oracle

@Tony_OAS_Apex_User, OAC provides REST APIs, pls explore using REST API. Hope it helps!

@KarimullaShaik , Welcome to the Oracle Analytics Forum! Please consider providing more details. As a start, check Security Roles of both users Go to Navigator → Tools → Security Console → Users and Roles Compare your roles vs functional user’s roles.

You might need to check if OAC and Fusion are in the same OCI IAM identity domain.

@Tony_OAS_Apex_User , In Oracle BI Publisher, access to: Data Models Data Sets Reports Folders is controlled by catalog permissions, if regular user cannot see columns, they likely don’t have required permissions. We give catalog item access permissions to application roles. The permissions that we can assign to others…

@edepot , Welcome to the Oracle Generative AI Forum! You have following options Go to: https://support.oracle.com (Oracle Support) If you cannot log in above, use OCI Sales / Cloud Support Contact Form https://www.oracle.com/cloud/contact.html Hope it helps!

@Farhaj Ahmed Khan , Welcome to the Oracle Generative AI Forum. Please refer this oracle doc, for Oracle AI for Fusion Applications. It has AI features for each Fusion App and also videos. Hope it helps!