BI Cloud Connector
Discussion List
-
Extract Fusion Spend Classification Data using BICCSummary: How to extract Spend Classification Data from Fusion? Content (required): As per Fusion 21C, Oracle has introduced Spend Classification Oracle Procurement Cloud…Guillaume Lecouteux. 12 views 1 comment 0 points Most recent by Guillaume Lecouteux. Reporting and Analytics for ERP -
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 …Rohan Lobo-Oracle 13.2K views 76 comments 24 points Most recent by User_3ORPJ Reporting and Analytics for ERP -
What data store contains DFF fields for Enterprise Contracts header record?Summary: Content (required): We are trying to extract Enterprise Contract Header DFFs but cannot find a data store that contains these. Version (include the version you …
-
BICC - ability to product a single CSV output merging data from many data stores/VO'sSummary: Does BICC support selecting columns from different data stores/PVO's and apply query filter? Content (required): We have a business requirement to extract large…Arun N-OC 52 views 8 comments 2 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for ERP
-
Is it possible to set up triggers for BICC extractsSummary: Is it possible to trigger a BICC extract to occur only when data has changed? Content (required): We would like to extract data stores that don't support increm…Holly Wells 21 views 2 comments 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for ERP
-
Is there a setting in BICC so that data store extracts handle special characters correctly?Summary: We are finding that special characters are not being exported correctly in our data store extracts. Is there something we can do to export the characters correc…
-
Calling BICC Rest API Service in ODISummary: Calling BICC Rest API Service in ODI 12c Content (required): Need help to know the step by step configuration for calling BICC Rest API services from ODI . How …Mandar -Oracle 14 views 0 comments 0 points Started by Mandar -Oracle Reporting and Analytics for ERP
-
Which PVO's have location level details (e.g., names, codes, address information)Summary: Which pvo should be used to join to in order to get the location information for the deliver_to_location_id for each purchase order distribution line? Content (…JeannieMoore 1 view 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for ERP
-
positioning FAW on top of Supply Chain Planning Cloud (Demand Management Cloud, Supply Planning ClouSummary: Has anyone built FAW analytics using Supply Chain Planning Cloud and EBS (Procurement, Financials, Inventory, Order Management) data with drill down/deep link c…Vishnuvarth Subramanian-Oracle 1 view 0 comments 0 points Started by Vishnuvarth Subramanian-Oracle Reporting and Analytics for ERP
-
positioning FAW on top of Supply Chain Planning Cloud (Demand Management Cloud, Supply Planning ClouSummary: Has anyone built FAW analytics using Supply Chain Planning Cloud and EBS (Procurement, Financials, Inventory, Order Management) data with drill down/deep link c…Vishnuvarth Subramanian-Oracle 1 view 0 comments 0 points Started by Vishnuvarth Subramanian-Oracle Reporting and Analytics for ERP
-
oracle report to google sheet directlyis there any way to connect oracle BI and OTBI reports with online google sheet or offline excel file ? ThanksSandeep Nihalani 11 views 2 comments 0 points Most recent by Melissa G Reporting and Analytics for ERP
-
Bursting Enabled or DisabledHi Team, We wanted to check if we have a table or sql query to check how many reports have bursting enabled so a report or list can be prepared for the same. Please let …Swapnil Kashid 21 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
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…Jahnavi-Oracle 11 views 0 comments 0 points Started by Jahnavi-Oracle Reporting and Analytics for ERP -
BI Cloud Connector (BICC) - Only limited columns selected by default in PVOSummary: While configuring data extract from BICCC, we notice that within a particular PVO, only limited columns are selected by default. While we can customize and sele…Amit Garg-Oracle 1 view 2 comments 0 points Most recent by SukantaBarari-Oracle Reporting and Analytics for ERP
-
BICC - I'm looking for the link to the list of potential deprecated PVO's or objects for Release 22ASummary: BICC - I'm looking for the link to the list of potential deprecated PVO's or objects for Release 22A Content (required): BICC - I'm looking for the link to the …JeannieMoore 1 view 1 comment 0 points Most recent by Umamaheswara Reddy Karri 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…Fongang 1 view 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP -
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…
-
BICC - How do you remove a datastore/pvo from a job?Summary: How do I remove a datastore from a job; disassociate it. I have a custom offering where I had added a datastore/pvo that I no longer want included in the job th…
-
Dynamic Logo in RTF Template in FusionContent Hello Team, Could you please let us know how can we use the Dynamic Logo in RTF Template in Oracle Cloud/Fusion. Same logo is called in many other reports and ou… -
Using BICC PVO in data model for BI publisher reportingSummary: is there way to configure data model to use BICC PVO? we need some custom reporting built and would like to leverage BICC PVO in data model Content (required): …Roman Havrylyak 1 view 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Do BICC and OTBI have access to the same data?Summary Wondering if there any differences in what data can be accessed via BICC vs OTBIContent Am wondering if there any differences in what data can be accessed via BI…Jeff Hare CPA CISA CIA 34 views 3 comments 3 points Most recent by Nathan CCC Reporting and Analytics for ERP -
BICC - Get Full Extract on every scheduled runSummary: BICC - Get Full Extract on every scheduled run Content (required): We have a requirement where we need to schedule a PVO on a daily basis. And the output of the…Saunak Mitra 22 views 2 comments 1 point Most recent by Roman Havrylyak Reporting and Analytics for ERP
-
What is the best BICC PVO that matches to HR_LOCATIONS_ALL?Summary: Need BICC PVO that best aligns with on-prem table HR_LOCATIONS_ALL. I've looked at the most recent lineage mapping spreadsheet and the closest one I see is: Con…
-
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…
-
Refreshes P2T - Should BICC jobs be copied during a PROD to Test refresh?Summary Refreshes P2T - Should BICC jobs be copied during a PROD to Test refresh?Content Refreshes P2T - Should BICC jobs be copied during a PROD to Test refresh?JeannieMoore 5 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
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…JeannieMoore 164 views 2 comments 2 points Most recent by Waleed Fetoh Reporting and Analytics for ERP
-
List of seeded reports & analyses for Procurement Contracts/ Enterprise Contracts module in oracle fSummary List of seeded reports & analyses for Procurement Contracts/ Enterprise Contracts module in oracle fusionContent Hi, Is there any way to get the list of all the …Aman Vasishtha-Oracle 11 views 1 comment 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
Procure to Pay dashboard not displaying invoice amount on Invoices tabContent We have just discovered the Procure to Pay dashboard and are very interested in the Invoices charts and metrics however every reference to a display which involv…
-
BICC Extract job timestamp used to extract data when there is a failureSummary What extract timestamp is used for each incremental job after a failureContent When there is a failure in BICC incremental job which timestamp is used to start t…JeannieMoore 15 views 4 comments 1 point Most recent by AnkitR Gupta Reporting and Analytics for ERP
-
What is the risk of copy any seeded report, add two columns on a table already in the data model, keSummary What is the risk of copy any seeded report, add two columns on a table already in the data model, keeping in the custom folder with a new name and new ESS Job on…Sam Samaddar 17 views 4 comments 1 point Most recent by Sam Samaddar Reporting and Analytics for ERP