BI Cloud Connector
Discussion List
-
Schedule a BI report with incremental dataSummary: Schedule a BI report with incremental data Content (please ensure you mask any confidential information): Hi Experts, I have a requirment, I need to scheduled a…Malak 21 views 4 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
What is the recommended tool to feed Data Warehouse from HCM CloudSummary: I would like to understand what the recommended tool is to feed Data warehouse from HCM Cloud. The BI Cloud Connector seems to me the best tool for this purpose…Jeroen.Broecheler 12 views 2 comments 0 points Most recent by Jeroen.Broecheler Reporting and Analytics for HCM -
How to get the gl account segment 'description' from BICC PVO extracts?Summary How do we get the gl account segment 'description' from BICC PVO extracts?Content How do we get the gl account segment 'description' from BICC PVO extracts? We a…User_2025-03-07-18-57-57-349 918 views 4 comments 2 points Most recent by Robert A Reporting and Analytics for ERP
-
Can we have a multiple bursting in one reportSummary Can we have a multiple bursting in one reportContent Hello, Can we have multiple bursting in one report, I can create multiple burstings within the data model an…Koteswararao Yenikepalli 732 views 3 comments 2 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP -
BI Cloud Connector (BICC) New featuresHi Does anyone know of any changes coming to BI Cloud connector with Fusion Application 22A upgrade. And can anyone help provide the link to the the New Features documen… -
BICC - Oracle AR Invoice Line extended amountSummary: Hi, We are extracting data from oracle fusion ERP using BICC. When extracting Receivables(AR) invoice lines, there is no column like 'extended_amount', basicall…
-
Bi Cloud Extract is returning different amount of lines with same parametersSummary: BICC Extract Difference in amount of lines using same parameters Content (please ensure you mask any confidential information): I'm using BI Cloud Connector, da…Andres Celis-Oracle 11 views 0 comments 0 points Most recent by Andres Celis-Oracle Reporting and Analytics for ERP -
Guidance on Business Intelligence Cloud Connector job orchestrationSummary: Guidance on Business Intelligence Cloud Connector job orchestration Content (please ensure you mask any confidential information): We need to execute JOURNAL_IN…Elisa Rossi 3 views 1 comment 0 points Most recent by Antima Rai-Oracle General Ledger & Intercompany
-
HcmTopModelAnalyticsGlobalAM.PersonAM.PersonDetailsPVO missing dataSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
BICC Privileges or data access sets required to query PVO ReceivingReceiptTransactionExtractPVOSummary: Need to query PVO FscmTopModelAM.ScmExtractAM.RcvBiccExtractAM.ReceivingReceiptTransactionExtractPVO via BI Cloud Connector. PVO is filtering data. Is there doc…Stéphane Lamy-Bouchard 12 views 0 comments 0 points Most recent by Stéphane Lamy-Bouchard Receivables & Collections
-
Which Data Store should be used to get Lookup information from BICC?Summary: Hi, We're using BICC to export data from Sales, however the lookup columns doesn't show the meaning, only the the codes. For example, "BR" instead of "Brazil" o…Max Prestes 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
BICC REST API to get last_extract_date of a PVOSummary: BICC REST API to get last_extract_date of a PVO Content (required): I am looking for BICC REST API to get last_extract_date of a PVO Version (include the versio…Naved Khan 462 views 6 comments 0 points Most recent by Antariksh Kar-Oracle Reporting and Analytics for ERP -
Locating PVOs and Data Stores for ar_batch_sources_all and ar_credit_memo_amounts Tables in BICCSummary: I am currently working on extracting BIP tables from BICC to UCM, but I am unable to locate the tables ar_batch_sources_all and ar_credit_memo_amounts within th…
-
Oracle BICC which PVO can be used ?Summary: In Rel13_25C_BICC_FSCM_Database_Mapping_with_ViewObjects there are GL PVO not described in 'Extract Data Stores for Financials' (https://docs.oracle.com/en/clou… -
BICC Manage Jobs to DatabricksSummary: Since we will be using managed jobs, and scheduling each job in Databricks by its job ID to invoke, upload, or export files from UCM, should we anticipate any i…Carlo Orolfo 34 views 2 comments 0 points Most recent by Carlo Orolfo Reporting & Analytics for Sales
-
Missing Columns in BICC PVO but columns available in the underlying Oracle database tablesSummary: While analyzing the BICC Object Views for sending the data to Traget System—similar to the BIP extracts—for the following three Oracle tables, I noticed that so…Anshul Bansal 51 views 1 comment 0 points Most recent by Sai Revanth Reporting and Analytics for ERP
-
The datatype of this column is NULL and such columns are not supported in the BICC schedule extractWe are facing error "The datatype of this column is NULL and such columns are not supported in the BICC schedule extract" for few columns in HcmTopModelAnalyticsGlobalAM…Prakash Maram 12 views 0 comments 0 points Most recent by Prakash Maram Reporting and Analytics for HCM
-
What is the default size of calculated columns in BICC extracts, and is any documentation available?While generating metadata using BICC R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping Spreadsheet (Rel13_25C_BICC_FSCM_Database_Mapping_with_ViewOb… -
Replace SQL Server Reporting DB with Paas DBWe currently have a daily extract (GL to subledger drill down) that gets loaded into a SQL Server DB and the business interrogate via an Excel SQL Server add in. We are …
-
How to get PVO path for custom (Non-Seeded) object?Summary: Unable to find out the the non seeded path for the custom object PVO. Content (please ensure you mask any confidential information): We created a new custom obj…Shiva Kumar Bandaru 262 views 9 comments 0 points Most recent by Shiva Kumar Bandaru Order Management
-
Is there a button we need to enable for Custom View ObjectsSummary: Can we confirm if there is a button or something we need to enable for Custom View Objects to be automatically added on the BICC Data Store list? Content (pleas…Carlo Orolfo 21 views 3 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales
-
The data extracted from BICC extract is in UTC timezone. Can we change that?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Surekha E PNC 21 views 2 comments 0 points Most recent by Yves_Guyon-Oracle Reporting and Analytics for ERP
-
BICC Extracts: how can i find out what attributes are used for each of the fields in the data storesI am looking to find out what attributes are used for each of the fields extracted within our BICC Extract data. Our data reporting teams need to understand if a field i…Tracy Collins 3 views 1 comment 1 point Most recent by Prabha.R Oracle-Oracle Reporting and Analytics for SCM
-
cannot add descriptive flexfield to Skill and qualification OTBI reportSummary: Hi all, I am creating a Data model report on OTBI to extract all info related to a section in Skill and Qualifications: I was able to retrieve all sections name…Silvia Stangarone CAI 1 view 1 comment 0 points Most recent by Mark Stoker Reporting and Analytics for HCM
-
Unable to find PVOs related to MSC(Planning Table)Summary: Hello, We need PVOs for following(Fusion) tables in BICC, as we couldn't find these in Data Lineage Sheet. If anyone has any idea on how to get those or any doc… -
Are Sourcing Rules (Table MSC_SR_ASSIGNMENTS) available in BICC?Summary: Which is the right PVO / Dataset to use for this in BICC Offering setup? Content (please ensure you mask any confidential information): We need to extract Sourc…Frank.Steinjan 41 views 2 comments 0 points Most recent by Todd Hensley Reporting and Analytics for SCM
-
How do you delete BICC UCM filesSummary: For data security, once the UCM files have been generated and the data has transferred to destination using BICC, how do we get the UCM content deleted. Content… -
Plsql procedure from a Saas Report or Saas page?Summary: Invoking pl-sql procedure from SaaS Report or through a SaaS link on a page Content (please ensure you mask any confidential information): We haven't OIC. We'd …Luca Nobili PWC 22 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to connect to Oracle HCM Cloud to Power BI using CDataSummary: We are trying to connect to Oracle HCM Cloud to Power BI using CData ( https://www.cdata.com/drivers/oraclehcm/powerbi/ ) So, our PowerBI developers can utilize…
-
How to check if there is a scheduled refresh on PVO in BICC?Summary: We need to check if there is a scheduled job that runs for a PVO to Full Refresh. Content (please ensure you mask any confidential information): Version (includ…Carlo Orolfo 13 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales