Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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

How to query PVO in Oracle BI Publisher Data Model

Accepted answer
3534
Views
23
Comments
13»

Answers

  • User_H31GM
    User_H31GM Rank 1 - Community Starter

    Hello , any idea i am not able to Query the following

    select_physical * from "FscmTopModelAM.FinExtractAM.ArBiccExtractAM.TransactionLineExtractPVO"

    image_2025-04-04_135952150.png
  • ravikiran goda-Oracle
    ravikiran goda-Oracle Rank 6 - Analytics Lead

    Hi @User_H31GM

    You can review the below sample one

    select
    *
    from
    EXTERNAL('ADF','"oracle.apps.fscm.model.analytics.applicationModule.FscmTopModelAM_FscmTopModelAMLocal"."Connection Pool"').'FscmTopModelAM.FinFunBusinessUnitsAM.BusinessUnitPVO' as t
    FETCH FIRST 100 ROWS ONLY

  • arun n
    arun n Rank 1 - Community Starter
    edited Jun 2, 2025 2:24PM

    @Sumanth V -Oracle / Community

    In order to a do a data mapping exercise, I am trying to look at the columns and "the data" in a BICC Public view object as BICC is being used to extract data out of oracle to a data warehouse

    image-c1cba3a1ec9d7-ad1e.png

    Is it possible to query BICC public views

    I get the message Missing left Parenthesis

    Select * from

    EXTERNAL('ADF','"oracle.apps.fscm.model.analytics.applicationModule.FscmTopModelAM_FscmTopModelAMLocal"."Connection Pool"').'FscmTopModelAM.ScmExtractAM.DooBiccExtractAM.FulfillLineDetailExtractPVO' as t

    FETCH FIRST 100 ROWS ONLY

    Alternatively – If I try writing

    select_physical * from "'FscmTopModelAM.ScmExtractAM.DooBiccExtractAM.FulfillLineDetailExtractPVO"

    It gives error “Missing Right Parenthesis”

    image-0790687e741a08-16ad.png

    Is there anything i did wrong