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

Notice on Deprecated PVOs in BICCC

Received Response
87
Views
1
Comments
MohanPothuri
MohanPothuri Rank 3 - Community Apprentice
in Oracle Transactional Business Intelligence

In our solution we use normal PVOs and Extract PVOs, we observe that document available for Extract kind of PVOs . We load data by scheduling in BICCC.

Can we continue to use normal PVOs in solution?

If any PVO is not used or deprecated in BICCC, how much time before Oracle notifies that it will not support?

Eg: Normal PVO - FscmTopModelAM.FinGlLedgerDefnAM.LedgerPVO (no document)

ExtractPVO: FscmTopModelAM.FinExtractAM.GlBiccExtractAM.LedgerExtractPVO - https://docs.oracle.com/en/cloud/saas/financials/23b/oadsr/LedgerExtractPVO.html#LedgerExtractPVO

Tagged:

Answers

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach
    edited Sep 14, 2023 7:45AM

    Hi, I think if you need to ask this question to the vendor not the user community. Maybe try to find a product manager of BICC or something who might give you some sort of timeline.

    I am not aware of a deadline for the older public view objects to be removed in BICC. Maybe someone else will post otherwise? As you can see from oracle transactional business intelligence (OTBI) subject area data lineage documents these PVO tend also to be used in the physical layer in the metadata repository database (RPD) as well as available in BICC so my assumption is that if they are deprecated in BICC they will remain in OTBI.

    But the place to go to know what is planned to happen in the next releases is cloud readiness

    https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/readiness/offering/index.html

    For example 23D Financials in ERP

    https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/r13/wn/fin/releases/23D/23D-financials-wn.htm


    BTW With the normal PVO you do not particularly need a document to understand data lineage since you can just issue sql to query it fromt he rpd then view the session log in OTBI.

    as a user with a role with privilege "Issue SQl Directly" and "Manage Sessions"

    image.png

    In your browser go to

    /analytics/saw.dll?issuerawsql

    select_physical all t."LedgerId" as pk, t.* 
from "FscmTopModelAM.FinGlLedgerDefnAM.LedgerPVO" t 
fetch next 7 rows only

    then select "View Log" which go to /analytics/saw.dll?managesessions

    image.png