BI Cloud Connector
Discussion List
-
Unable to establish secure FTP connection with carriers, The Firewall is blocking port 10022Summary: While creating secure FTP connection with carriers, The Firewall is blocking port 10022, How to whitelist this port ? Content (please ensure you mask any confid… -
Extract the UCM content server attachments through BI ReportsSummary Extract the UCM content server attachments through BI ReportsContent Hi, PDC attachments(File formats like PDF,Excel,JPG etc) currently placed in UCM content ser… -
AR Transaction Approval QuerySummary: Hi Team, Please help to get table that stores AR transaction approval History.User_S5U61 10 views 1 comment 0 points Most recent by Vighnesh Khade Reporting and Analytics for ERP -
Missing informations in FscmTopModelAM.PrcExtractAM.PozBiccExtractAM.SupplierExtractPVOSummary: Why ZX_PARTY_TAX_PROFILE Informations regarding Suppliers are not in the PVO 'FscmTopModelAM.PrcExtractAM.PozBiccExtractAM.SupplierExtractPVO' but only in the o… -
How to pull data in Power BI from Oracle Fusion/ATP TablesSummary: How to pull data in Power BI from Oracle Fusion Content (please ensure you mask any confidential information): We are looking to pull data in Power BI from Orac…Abhishek Sinha 123 views 2 comments 0 points Most recent by User_DXIFI Reporting & Analytics for Sales -
Request Documentation on Critical PVOs for Oracle Fusion HCM Integration with Data LakeDear Team, We have recently implemented Oracle Fusion HCM and are now working on integrating it with our Data Lake. To better understand the critical PVOs required for t…
-
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…MaheshRayudu7 58 views 2 comments 0 points Most recent by User_G9ACJ Reporting and Analytics for HCM -
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 21.8K views 23 comments 11 points Most recent by Jae.L Reporting and Analytics for HCM -
Prune Time for Hourly BICC ExtractsSummary: We have BICC Extracts running hourly and prune time set to 60. But the downstream applications have issues with the number of duplicates generated in every run.… -
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 25 views 1 comment 0 points Most recent by Shradhanjali_Oracle-Oracle Reporting and Analytics for ERP -
Seeded Process/Report/Data Model customizationSummary: Once we did customization of seeded Process/Report/Data Model, after applied any patch/upgrade then the customization changes will override. Content (please ens… -
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… -
BICC columns with numeric datatype fetching incorrect decimal values.Summary: We observed that an issue with BICC extract for columns with numeric datatypes. We noticed that columns with numeric datatype, for decimal values, its fetching …Joel Prakash-Oracle 14 views 1 comment 0 points Most recent by SankarBalu Reporting and Analytics for ERP -
Oracle Business Analytics Reporting OverviewSummary Watch this video to learn about using Oracle Business Analytics for Supply Chain Management.Content Link to the video: https://www.youtube.com/watch?v=DSRvYKS2wG…Pankaj Mongia-Oracle 531 views 2 comments 11 points Most recent by Mohammed Rafi Reporting and Analytics for SCM -
Customisation of Expense Approval Workflow Notification using BIPSummary Issues persist even while following expense config document step by stepContent Hi,We are trying to implement customized expense approval workflow notifications … -
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 61.9K views 147 comments 33 points Most recent by YevgenyM Reporting and Analytics for ERP -
Regarding - Alerts Failure during Bulk LoadSummary: We have implemented multiple custom BI Publisher–based alerts that are triggered on specific business scenarios and scoped to particular Business Units. During …Abdul Raqueeb 2 views 0 comments 0 points Most recent by Abdul Raqueeb Reporting and Analytics for HCM -
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 objects 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… -
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 49 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 78 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.4K 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 426 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 158 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 13 views 0 comments 0 points Most recent by Andriampeno Odilon Reporting and Analytics for HCM