BI Cloud Connector
Discussion List
-
How to enable Support Incremental Checkbox on a PVO on BICCSummary: How to enable Support Incremental Checkbox on a PVO on BICC? We currently do not have the option to enable this. Content (please ensure you mask any confidentia…Carlo Orolfo 54 views 4 comments 0 points Most recent by Sai Revanth Reporting & Analytics for Sales -
BI Cloud Connector (BICC) do all incremental last_update_date columns need to be selected for PVOSummary: When there is more than one last_update_date object included in a PVO should all be included/selected for the extraction file. For example, with most of the 'vi…User_2025-03-07-18-57-57-349 72 views 2 comments 0 points Most recent by Sai Revanth Reporting and Analytics for ERP
-
R13.x CX BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 CX BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter Develo…Rashmi M-Oracle 9.8K views 11 comments 15 points Most recent by Dave Kekish Reporting & Analytics for Sales
-
How to Format a Date Column to include Time Stamp in BICC Extract OutputSummary: Hi, I am trying to extract fusion table data using BICC, and I am seeing when the data is exported the date fields doesn't have the time values in it even thoug…Ragul Halan 35 views 2 comments 0 points Most recent by Deputy Birara-Oracle Reporting and Analytics for ERP
-
Oracle BI Cloud Connector (BICC) to Flexfields data from HCMSummary: We are using Oracle BI Cloud Connector (BICC) to extract data from HCM using a third party tool (FIvetran). However, we have a need for a couple columns of data… -
BICC Downloading Files from UCMSummary: We are investigating using BICC to schedule extract from Oracle ERP rather than relying upon our existing process of using Custom BI Publisher Reports then burs…
-
Getting 401 Unauthorized error code while calling an OIC integration from BIP reportSummary: I have created an app-driven integration that has - trigger REST connection with security policy: OAuth 2.0 - the REST trigger configures multiple resources - m…Nermin Khaled-Oracle 584 views 7 comments 0 points Most recent by Youssef_Antoury Reporting and Analytics for ERP -
Unable to find PVOs in BICCContent Hello, We need PVOs of following tables in BICC but we couldn't find these in Lineage Sheet. If anyone has any idea on how to get those or any workaround would r…Vinay Gharge 157 views 8 comments 2 points Most recent by User_0GZ7K Reporting and Analytics for ERP -
BICC PVOs with Offer DFFsSummary: We're looking to extract the Offer DFFs from HCM into Incorta, but are not able to find them within any of the PVOs. Has anyone successfully done this? If so, p…Maryellen_Gancena 1 view 0 comments 0 points Most recent by Maryellen_Gancena Reporting and Analytics for HCM
-
BICC PVO HcmApprovalsTaskP1 Missing Pending Approval Tasks (Learning Requests / HCM Approvals)Hello Team, We have a query from Oracle to retrieve approval details for a Learning Request. We are working in OBICC (Oracle Business Intelligence Cloud Connector Consol…Andriampeno Odilon 12 views 0 comments 0 points Most recent by Andriampeno Odilon Reporting and Analytics for HCM -
What Caused the seeded Payroll Activity report to be updated on 11/27/2025?Summary: Want to understand why the seeded Payroll Activity Report has a Last Modified Date of 11/27/2025? and Owwner is System Account Content (please ensure you mask a…
-
BICC multiple file generation naming convention.We’ve observed that when multiple files are generated in BICC, they are currently being saved with identical names, without any versioning suffixes like _1, _2, etc. Thi…
-
Data replication from Oracle Fusion, OTM and WMS to external data warehouseWe have a requirement to replicate Oracle Fusion, OTM and WMS data (full load and incremental) to an external datawarehouse/ data lake at Microsoft Fabric on nightly bas…
-
FscmTopModelAM.FinVrmRRSharedPublicModelAM.PerfObligationLinDistsPVO- Duplicates for primary keyACTUAL BEHAVIOR Running BICC extract to extract information from PVO FscmTopModelAM.FinVrmRRSharedPublicModelAM.PerfObligationLinDistsPVO in BICC. PERFOBLIGATIONLINEDIST…Prabhjeet Kaur 51 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Can we data mask certain fields within BICCSummary: As Oracle provides BICC as a tool to extract data from Oracle Fusion Cloud through UCM for customers to further analyze or report this data. We have a legal req…
-
Which BICC PVO Stocked Purchase Order Receipts Information?Summary: Maybe someone knows or can give a hint where to find Stocked Purchase Order Receipts Information like Receipt Date in BICC extracts. So which PVO to use for thi…Frank.Steinjan 2 views 0 comments 0 points Most recent by Frank.Steinjan Reporting and Analytics for ERP
-
How can I join the hz_parties table to a project number or contract number table using sql.Hi everyone, I'm creating a work-in-progress report that tracks project costs and needs your help joining several Oracle tables efficiently. I'm working with: PJF_PROJEC…
-
BI Cloud Connector (BICC): ElementEntryPVO vs ElementEntrySummary: Both ElementEntryPVO and ElementEntry are sourced from the same view PAY_ELEMENT_ENTRIES_VL. However, when performing a full extract with the Effective Date Fil…Dennis Paredes 12 views 0 comments 0 points Most recent by Dennis Paredes Reporting and Analytics for ERP -
Availability of sales order tax information (DOO_ORDER_TAX_DETAILS) in PVOs?For SCM analytics, I am looking for information on tax details at the sales order level (which table-wise seems to be in DOO_ORDER_TAX_DETAILS), for calculations pertain…Or Shoham 11 views 3 comments 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Oracle Fusion (HCM) Allow a Link to Microsoft Power BI to get dashboards?We are currently implementing Oracle Fusion HCM and the client has several dashboards already developed in Microsoft Power BI. These dashboards are published in Power BI…daniel.valdovinos 41 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
not able to locate any PVOs that expose the DFFs for Transfer Order Header and LineSummary: In the 25B release, I’m trying to create a BICC data extract job for Transfer Order Headers and Transfer Order Lines, including their Descriptive Flexfields (DF…User_CK3H0 41 views 2 comments 0 points Most recent by Janakrm-Oracle Reporting and Analytics for SCM
-
How to connect Cloud Database to VS Code via Oracle Developer Tools for VS CodeSummary: We want to know if we can use Oracle Developer Tools for Visual Studio Code (SQL and PLSQL) extension to connect to Oracle HCM Cloud database. We are exploring …MaeHCM 75 views 2 comments 0 points Most recent by kollipara Bindu Bhargav Reporting and Analytics for HCM -
Extract all data from PAY_RUN_RESULT_VALUES and PAY_RUN_BALANCES tablesSummary: We have a requirement to extract all data from PAY_RUN_RESULT_VALUES and PAY_RUN_BALANCES tables since go live. We tried to build a BIP Report and running them …Phaneendra Vallapu 153 views 6 comments 0 points Most recent by Hemanth Kumar Muthyala Reporting and Analytics for HCM
-
Import Error BICC JobsSummary: Hello Team, we are getting an error when importing the BICC Jobs from UAT to PROD and it is erroring with attached error. Tried manual creation and it is workin…PrasadN 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
MSC_SYSTEM_ITEMS vs. EGP_SYSTEM_ITEMS_BI have a need to cross reference MSC_SYSTEM_ITEMS and EGP_SYSTEM_ITEMS_B to abstract away query complexity for certain users. This is a Data Warehousing scenario. How ca…Cameron Campbell 101 views 4 comments 0 points Most recent by Cameron Campbell Reporting and Analytics for SCM
-
In the BI Report Need to remove the schedule, jobs and jobs history from the setting option.In the BI Report Need to remove the schedule, jobs and jobs history from the setting option.
-
Need BICC PVO to get per_location_details_f tables Additional attributesSummary: Need BICC PVO to get per_location_details_f tables Additional attributes Content (please ensure you mask any confidential information): Version (include the ver…Nishanth B Jain 41 views 5 comments 0 points Most recent by Nishanth B Jain Reporting and Analytics for ERP -
How to identify Specific Column used Reports in BIPSummary: Hello Everyone, Is there any query we to fetch all BIP reports which are using specific column? Eg: Person_Number (Per_all_people_f) Can we pull all BIP Reports… -
Which BICC PVO should be used to extract Supplier/Vendor 'Name' to match to BICC Invoice Headers extContent Which BICC PVO should be used to extract Supplier/Vendor 'Name' to match to BICC Invoice Headers extract PVO? Version 21_BUser_2025-03-07-18-57-57-349 428 views 3 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to extract data from Flexfields in Fusion HCM via Data Stores in BICC?Summary How to extract data from Flexfields in Fusion HCM via Data Stores in BICC?Content Dear all, we extract data from Fusion HCM via Data Stores configured in BICC (B…User_2025-01-28-05-44-16-446 109 views 3 comments 0 points Most recent by M Nguyen Reporting and Analytics for HCM