Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Analysis/SQL Query behind Standard Purchase Order Infotiles

edited Mar 7, 2023 6:44PM in Reporting and Analytics for ERP 2 comments

Version (include the version you are using, if applicable):

Oracle Fusion Cloud Applications: 22D (11.13.22.10.0)


Summary:

How to Get the actual OTBI Analysis behind standard Infotiles & the SQL query to get a listing of all transactions on hyperlink click?


Content (required):

I am looking for a way where I can get to know the following:

A. Which OTBI analysis is behind the Procurement --> Purchase Order standard Infolet.

  1. Order Requisitions (Rejected, Failed Submission and With Invoice Holds)
  2. Requisition Lines (Requiring Action)
  3. Incomplete (Orders and Change Orders)

I tried using the Sandbox approach, in vain. I also checked the analysis under /Shared Folders/Procurement/Purchasing/Transactional Analysis Samples

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!