Oracle Transactional Business Intelligence Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Transactional Business Intelligence Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Is it possible get the query for oracle.apps.financials.payables.shared.publicView.ReportsPayeePVO

Received Response
22
Views
2
Comments
Juan Jesus
Juan Jesus Rank 2 - Community Beginner
edited May 29, 2024 9:01AM in Oracle Transactional Business Intelligence Forum

Hi,

I would thank for any help to know how to get the query below ESS job LIST OF VALUES (not by hand, or googling).

Examples:

image.png

or oracle.apps.financials.payables.shared.publicView.ReportsPayeePVO

I would like to know some "automagic" way,.

Note: BICC vo's have been already investigated, this PVOs are not in BICC view objects.

Thanks in advance.

Juan

Answers

  • Gaurav Bharadwaj-Oracle
    Gaurav Bharadwaj-Oracle Rank 6 - Analytics & AI Lead

    Hi @Juan Jesus ,

    I suppose these documents will help you, please review.
    How To Manually Retrieve Database Query for BICC VO Through BI UI (Doc ID 2513701.1)
    How to fetch Physical SQL queries for BICC VOs in Fusion ? (Doc ID 2547087.1)

    If my response has answered your question or assisted you with your concern, please click "yes" below to accept the answer or comment with any additional queries. You can also read the Cloud Customer Connect Guidelines for Accepted Answer

    Regards,
    Gaurav

  • Juan Jesus
    Juan Jesus Rank 2 - Community Beginner

    Thanks Gaurva,

    Sorry, but these (shown above) are no BICC pvos.

    Juan