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

R13.x Deprecated and New BI View Objects

7872
Views
25
Comments
2

Comments

  • Dave Kekish
    Dave Kekish Rank 5 - Community Champion

    The primary reason we are moving to extract from the OTBI PVO's is fewer issues with things like determining primary keys, duplicate data, etc. The Extracts have fewer issues in our experience.

    As for changes to the extracts, they add columns, but removal of columns isn't a big issue (at least for us right now). The bigger one is determining how to wire up one or more tables to get back to what we had in the original OTBI version of the download.

  • satya_nvs
    satya_nvs Rank 2 - Community Beginner

    Thanks Dave for those insights. We are in the process of developing a data warehouse using Oracle Fusion SCM Cloud as a source and are trying to determine what the best data extraction mechanism (BICC Extract vs. BICC non-extract vs. BIP) for each of the key procurement cloud table is.

    I noticed that in certain cases, even the Extract PVOs do not get all the columns from the Oracle cloud base table (ex: SupplierExtractPVO does not get all the columns from POZ_SUPPLIERS). Even Flex Fields are not straightforward to extract using BICC.

    Given some of the limitations around using BICC, would using a tool like SplashOC https://splashbi.com/splashoc/ that replicates the data in the core Oracle cloud tables be a better approach for data extraction? It is probably built on BIP but is able to extract (replicate) data in bulk.

  • Dave Kekish
    Dave Kekish Rank 5 - Community Champion

    BIP has limits as well, but I don't know the tool you referenced. One major limit of BIP reports is a hard 2 million row max limit that Oracle seems to not want to lift.

  • LCann-Oracle
    LCann-Oracle Rank 1 - Community Starter

    Another comment on extract vs. nonextract PVOs. The nonextract PVOs are used throughout Fusion Applications just not OTBI/BICC. They contain a lot of columns that are required outside of "reporting". The extract PVOs are scaled down to only include columns deemed required for reporting purposes.

  • Nicole Ghiorzi
    Nicole Ghiorzi Rank 1 - Community Starter

    Hi,

    where can i find 23B BIVO list?

    Regards

    Nicole

  • Praveen Kumar Akkala-Oracle
    Praveen Kumar Akkala-Oracle Rank 6 - Analytics Lead

    @User_GHHVV


    Please review the below KM Document.


    How to Review Database Lineage Mappings, Check For Columns and View Objects for BICC PVOs? (Doc ID 2626555.1)


    Thanks,

    Praveen

  • Sridhar_Rejeti_1423
    Sridhar_Rejeti_1423 Rank 2 - Community Beginner

    Hi,


    Can someone please guide me to the documentation which shows deprecated, inactive, and new BIVOs as part of 23B.


    Thanks,

    Sridhar

  • Dave Kekish
    Dave Kekish Rank 5 - Community Champion

    Try

    R13.x Deprecated and New BI View Objects — Cloud Customer Connect (oracle.com)

  • User_11IRQ
    User_11IRQ Rank 1 - Community Starter

    Hi,

    Can someone help me to get documentation on the deprecated, inactive, and new BIVOs for 23C.

    Thanks.

  • Sridhar_Rejeti_1423
    Sridhar_Rejeti_1423 Rank 2 - Community Beginner

    Thank you Dave Kekish for the link. Thats what I wanted.


    Hi - The link shared by Dave Kekish is the one where you can refer to. But as of now, 23C xlsx file is not yet available.


    Thanks,

    Sridhar