BI Cloud Connector
Discussion List
-
Is there a mapping between API entities and fields and BICC BIVO objectsSummary: I'm looking for a mapping between API entities and fields and BICC BIVO objects For example: I want to know which BIVO object matching the API for REST API for … -
Historical FTE values in BICCHi, The customer would like to extract assignment history data, including FTE, using BICC. I found that we can retrieve historical assignment data through HcmTopModelAna…
-
R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 FSCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter Deve…Rashmi M-Oracle 59.5K views 146 comments 33 points Most recent by Stéphane Lamy-Bouchard Reporting and Analytics for ERP
-
GL_FRC_REPORTS_B and Custom Folder and Report ListSummary GL_FRC_REPORTS_B is not listing all the reports that are created or modified; Should we run a process to populate the table or does the data in the table gets po…
-
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 44 views 4 comments 0 points Most recent by Sai Revanth Reporting & Analytics for Sales
-
Why certain BICC Public VOs do not support Incremental Load?Hello Team, We noticed that certain BICC Public View Objects do not support Incremental Load. Below are names of some of the VOs and screenshot showing 'Supports Increme…
-
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 61 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.1K 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 31 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… -
R13.x HCM BI Cloud Adapter BI View Object to Database Lineage Mapping Spreadsheethttps://us.v-cdn.net/6034893/uploads/XTAY0TAIX14K/rel13-24-x-bicc-hcm-database-mapping-with-viewobjects-xlsx.zip Summary This posting includes R13 HCM BI Cloud Adapter B…Rashmi M-Oracle 20.8K views 22 comments 11 points Most recent by Michael E Reporting and Analytics for HCM
-
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 257 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 Started by Maryellen_Gancena Reporting and Analytics for HCM
-
Connection Timeout (Error 404/504) when connecting BI Publisher to OIC File Server via Port 10134.Summary: Connection Timeout (Error 404/504) when connecting BI Publisher to OIC File Server via Port 10134. Content (please ensure you mask any confidential information)…Edward Villanueva 3 views 0 comments 0 points Started by Edward Villanueva Reporting and Analytics for ERP
-
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 Started 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 54 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…
-
Unable to deliver the file to SFTP serverHi Team, We have created SFTP server and while clicking on "Test Connection" the connection is showing as successful. But while we are scheduling the extract to the resp…
-
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 11 views 0 comments 0 points Started 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 33 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 71 views 2 comments 0 points Most recent by kollipara Bindu Bhargav Reporting and Analytics for HCM