BI Cloud Connector
Discussion List
-
PVO BankAccountExtractPVO returns bank account data in OTBI - Issue SQL but no data via BICCNeed to identify missing privilege or profile. PVO FscmTopModelAM.FinExtractAM.CeBiccExtractAM.BankAccountExtractPVO not returning data via BICC. In Fusion > Tools > Rep…Stéphane Lamy-Bouchard 48 views 2 comments 0 points Most recent by fusionenthu Reporting and Analytics for ERP -
Is there a PVO (or combination of PVOs) that returns the accounting status of a Payables invoice?I need to return the accounting status (Accounted, Partially Accounted, Selected, Unaccounted) for a specific AP invoice but using PVOs. The column "ApInvoicesPostingSta…
-
BICC mapping documentation for a specific PVO missingSummary: Hi, we are doing BICC extracts on every day basis. One of the PVOs we are extracting and which is working fine is: FscmTopModelAM.PrcPoPublicViewAM.GlobalPurcha…Frank.Steinjan 91 views 2 comments 0 points Most recent by Frank.Steinjan Reporting and Analytics for ERP
-
Extract Transfer Order Line DFF using BICCHi, We have a reqiurement to extract the DFF information for Transfer Order lines using BICC. We could able to find the below PVO for extracting the transfer order line …
-
Is there any row level security delivered with BICC?Hello, We need to extract data for our local BI. We are on a Single International Instance, and we want to extract only our data. Is there a way (through security, or pe…
-
Send reminders to the employee based bip report burstingSummary: Send reminders to the employee based bip report bursting Content (please ensure you mask any confidential information): Hi Team, I have a requirement. I need to…
-
BIP attachment Query not accepting the parameterSummary: Hi, When I try to use attachment query with dynamic parameter(:P_DID) , i am not getting the UCM outputs. If I hardcode any UCM(DID) from revisions table then I…
-
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 11 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 921 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 730 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 1 view 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 18 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 12 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 461 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 61 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 274 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 22 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 1 view 1 comment 1 point Most recent by Prabha.R Oracle-Oracle Reporting and Analytics for SCM