Oracle Analytics Cloud and Server

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

I'm new to BICC - any PVO advice?

Accepted answer
43
Views
1
Comments

I hope this is the right community. I couldn't find one specific to BICC. My background is in integration platforms such as OIC and BizTalk, so working with the Fusion & Oracle ERP Cloud data structures is new to me. We have just started a project utilizing this BICC, and while I find the tool itself fairly straightforward, I am struggling with the locating the correct data stores / PVOs. I am aware of the documentation such as Extract Data Stores for SCM and the BIVO-to-Database Mappings such as Rel13_25B_BICC_FSCM_Database_Mapping_with_ViewObjects.xlsx. However, I still find myself in the time consuming loop of finding a good candidate PVO, adding it to my offering, running an extract, downloading it, unzipping it, only to find it is either empty (perhaps a permission problem?) or the fields do not contain the values I was looking for. Using "Download Sample CSV File" helps to some degree, but often does not contain enough rows of data for me to determine if I've got the right object. Is there some other tool available that would be better for quickly exploring the PVOs and the data they contain in an ad hoc fashion? Do any of the reporting tools like OTBI make use of PVOs and would they make clear which PVO and attribute is being used? Thank you in advance for any tips or advice you might have for a BICC/PVO newbie.

Best Answer

  • Gianni Ceresa
    edited May 23, 2025 6:41PM Answer ✓

    Hi,

    Welcome to the Oracle Analytics community and forum.

    BICC is not an Oracle Analytics product or feature, it is part of Fusion.

    Fusion, and BICC, PVOs and any other data question about Fusion or Fusion integration is covered in a different forum: https://community.oracle.com/customerconnect

    It's a fully separate forum, with lots of categories, therefore it can take a bit to find the right one, but most of the Fusion apps in there have a category or two about reporting and analytics.