DataTerrain Logo DataTerrain Logo DataTerrain Logo
  • Home
  • Why DataTerrain
  • Reports Conversion
  • Talent Acquisition
  • Services
    • ETL Solutions ETL Solutions
    • Performed multiple ETL pipeline building and integrations.

    • Oracle HCM Cloud Service Menu Oracle HCM Analytics
    • 9 years of building Oracle HCM fusion analytics & reporting experience.

    • Data Lake Icon Data Lake
    • Experienced in building Data Lakes with Billions of records.

    • BI Products Menu BI products
    • Successfully delivered multiple BI product-based projects.

    • Legacy Scripts Menu Legacy scripts
    • Successfully transitioned legacy scripts from Mainframes to Cloud.

    • AI/ML Solutions Menu AI ML Consulting
    • Expertise in building innovative AI/ML-based projects.

  • Resources

    • Tools
    • Designed to facilitate data analysis and reporting processes.


    • Latest News
    • Explore the Latest Tech News and Innovations Today.


    • Blogs
    • Practical articles with Proven Productivity Tips.


    • Videos
    • Watch the engaging and Informative Video Resources.


    • Customer Stories
    • A journey that begins with your goals and ends with great outcomes.


    • Careers
    • Your career is a journey. Cherish the journey, and celebrate the wins.

  • Contact Us
  • Blogs
  • Report Conversion
  • How to generate BICC extracts from Oracle Fusion Application for effective Cloud Data Extraction?
  • 4 April 2024

How to generate BICC extracts from Oracle Fusion Application for effective Cloud Data Extraction?

Webi to OBIEE conversion
  • Share Post:
Extracting and managing data from Oracle Fusion Cloud using BICC and PVO. Efficient data transfer methods & the integration of Cloud Extracts with Universal Content Management and Cloud Storage Service.

How to extract and manage data from Oracle Fusion Cloud using the BICC and PVO?

Extract data, use the BI Cloud Connector (BICC) Console.

Schedule one-time or recurring Cloud Extracts for seamless data transfer to both Universal Content Management (UCM) and Cloud Storage Service.

1. Within BICC the public view object (PVO) is associated with the Oracle BI Applications (OBIA) offering. Each offering (Finance, HCM, SCM, etc.) contains multiple seeded PVOs. Each PVO within an offering extracts data from a group of tables.

2. For example, if you select HCM offering for the extract, it includes a view object named ‘oracle.apps.hcm.action.publicView.analytics.ActionReasonsPVO’ as one of its PVOs. This view object extracts data from tables PER_ACTION_REASONS_TL and PER_ACTION_REASONS_B.

3. The other PVOs seeded within Oracle HCM offering will extract data from a different group of tables.

4. To add more data sources to seeded PVOs, you can use Cloud Extract Configuration and Extraction UI. There are two options when adding a data store; Fact Group or Dimension Group.

5. Once the extract has been configured, you need to schedule using the ‘Manage Extract Schedules’ option.

6. The file created by the Fusion BI Cloud Connector tool can be consumed and loaded into the target database by Oracle Data Sync tool.

Dataterrain with years of experience and reliable experts, is ready to assist. We have served more than 200 plus customers in the US and an additional 60 plus customers worldwide. We are flexible in working hours and do not need any long-term binding contracts.

Categories
  • All482
  • BI Insights Hub125
  • Data Analytics16
  • ETL Tools26
  • Oracle HCM Insights328
  • Legacy Reports conversion24
Customer Storeis
  • All19
  • Data Analytics01
  • Legacy Reports01
  • Jaspersoft04
  • Oracle HCM07
Recent posts
  • Migrate Actuate BIRT Reports to Oracle...
  • Efficient Supply Chain Data Management...
  • Build Spark Scala pipelines in AWS for financial reporting
    Guide to Build Spark Scala Pipelines in AWS...
  • Jasper Reports Conversion, Automation...
  • Optimizing mainframe integration with SnapLogic ETL
    Optimizing Mainframe Integration with...
  • Benefits of using SQL override in Informatica
    Benefits of Using SQL Override in Informatica...
  • Data Protection in Amazon QuickSight ETL Tool 01
    Data Protection in Amazon QuickSight...
  • Developing Global and Local Repositories in Informatica 01
    Developing Global and Local Repositories...
  • Navigating Migration Challenges with DataTerrain 01
    Navigating Migration Challenges...
  • Legacy to Modern: Transitioning SQR Reports......
  • Creating BICC extracts from oracle fusion...
  • Crystal to Jasper 02
    Steps to create jaspersoft sub reports.
  • Passing page items from one page to...
Connect with Us
  • About
  • Careers
  • Privacy Policy
  • Terms and condtions
Sources
  • Customer stories
  • Blogs
  • Tools
  • News
  • Videos
  • Events
Services
  • Reports Conversion
  • ETL Solutions
  • Data Lake
  • Legacy Scripts
  • Oracle HCM Analytics
  • BI Products
  • AI ML Consulting
  • Data Analytics
Get in touch
  • connect@dataterrain.com
  • +1 650-701-1100

Subscribe to newsletter

Enter your email address for receiving valuable newsletters.

logo

© 2025 Copyright by DataTerrain Inc.

  • twitter