BI Cloud Connector
Discussion List
-
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 28.9K views 111 comments 28 points Most recent by Kammarapalli Venkatesh-Oracle Reporting and Analytics for ERP -
Do we have BICC PVOs for ERP’s Audit logs?The client has enabled Audit in the ERP Cloud as per regulatory requirement. I would like to understand if we got these audit logs in PVO's for BICC extraction. Can you …Keerthana Rajagopal-Oracle 20 views 0 comments 0 points Started by Keerthana Rajagopal-Oracle Reporting and Analytics for ERP
-
How to call an OIC integration from BIP reportSummary: I have created an app driven integration with two request parameter. How can I submit the integration from BIP report? Content (required): I got a blog https://…Ananya Sadhukhan 834 views 11 comments 0 points Most recent by Rohit Agarwal-Oracle Reporting and Analytics for ERP
-
Can we call OTBI/Analytics dashboard using SOAP/REST webservices in oracle fusion?Hi , We have a requirement to run/submit the analytics/OTBI dashboard using rest/soap webservices. Please share your inputs. Appreciate your help. Thanks in advance.Bhavani Rikkula 33 views 2 comments 0 points Most recent by Bhavani Rikkula Reporting and Analytics for ERP
-
PVO for GL Secondary Balancing Segment KFF?Summary: On a quest for chart of account segment descriptive labels (KFFs) for secondary balancing segment. Content (please ensure you mask any confidential information)…Josh Vincent 25 views 2 comments 0 points Most recent by Josh Vincent Reporting and Analytics for ERP -
Does BICC support Extensible Flexfields (EFF) ? How do we extract information from EFFs ?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Oracle Business Intelligence Cloud Co…
-
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 224 views 3 comments 1 point Most recent by Vinod Menon-Oracle Reporting and Analytics for ERP
-
Using BICC with UCM - Expected CostSummary: I am intending to use BICC (Business Intelligence Cloud Connector) in combination with UCM as an external Storage. What are the costs I can expect related to th…FusionAnalyst_95 23 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
ERP Cloud - Export Table Using Saved QuerySummary: is there functionality in ERP Cloud similar to OTM Cloud Export Table using query? Content (required): OTM has ability to run custom SQL query and extract resul…Roman Havrylyak 31 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP -
Need PVO details for PER_ROLES_DN? Not able to find one in BICC mapping to Finance/HCM listSummary: I am looking BICC Tag for PER_USER, PER_USER_ROLES , PER_ROLES_DN HAve found following for PER_USER and PER_USER_ROLES and not for PER_ROLES_DN HcmTopModelAnaly…Antony P Patrick -Oracle 75 views 4 comments 0 points Most recent by Waleed Fetoh Reporting and Analytics for ERP
-
Is there any alternative if table is not available for BICC extractionHi, I was working to do an extraction using BICC and not able to get the PVO for some tables like: RCV_SUPPLY, WSH_FREIGHT_COST_TYPES etc. Is there any work around avail… -
BICC - Customization migrationSummary: BICC - Customization migration Content (required): I want to migrate one custom offering from one environment to another environment. BICC is giving an option t…
-
Can BICC write CSV files to Object storage or UCM without zippingSummary: Can BICC write CSV files to Object storage or UCM without zipping Content (required): Currently BICC writes CSV files with zipping onto Object storage or UCM. S…V Bikki 35 views 3 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
PO Change Order Amount Changed column detailsSummary PO Change Order Amount Changed column detailsContent Hi Friends, Can you please help me to get Amount Changed column details when PO Change Order action performe… -
Error in accessing BICC URL ending fusion pod /biacmSummary: Hi Team, We are getting error while trying to access BICC using url - fusion POD /biacm. Anyone faced similar issue, so need help in resolution of same. ADF_FAC…raban 52 views 4 comments 0 points Most recent by SiddharthDang-Oracle Reporting and Analytics for ERP
-
SQL Query for bypass Approval transactions of the BPM workflowSummary: The Client is asking to build a report based on the bypass Approval transactions of the BPM workflow. (without Approval). Content (required): we need to build t… -
How tables are joined for a View ObjectSummary: Is there any document or Oracle Cloud Application embedded method to figure out how the Database Tables are joined for a View Object? Content (required): Versio…
-
BICC offering on specific EntitySummary: I have configured the BICC on UAT and created the offering for AP Invoice and Line. I need to know how to extract the data only for specific legal entity (we ha…Milind Shelar 23 views 3 comments 0 points Most recent by Milind Shelar Reporting and Analytics for ERP
-
Archive/Unarchive buttons missing in Catalog ReportsSummary Archive/Unarchive buttons missing in Catalog ReportsContent Hi All, Archive/Unarchive buttons missing in Catalog Reports Thanks, Dev Thota. Version 21BDevendra Thota 185 views 3 comments 3 points Most recent by Skolli-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 145 views 3 comments 0 points Most recent by User_0H2MW Reporting and Analytics for ERP
-
Custom fields in Customized report not displayed in XML when report is run but appears in Data ModelSummary: Hi Team, We have customized the Journal approval workflow notification in Oracle Fusion to add custom fields and logic. The customizations for Journal Headers d…Abhilash K - Deloitte USI 25 views 0 comments 1 point Started by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
How to encode etext output file from UTF-8 to ANSI in OracleSummary: We have custom etext payment file for Citi Bank EFT. the output of Etext file is .txt and it is encoded in UTF-8 by default. how can i convert this text file fr…SireeshaJaladi 56 views 0 comments 0 points Started by SireeshaJaladi Reporting and Analytics for ERP
-
Issue SQL against PVOSummary: Is it possible to issue SQL against a data store extract PVO like "FscmTopModelAM.PrcExtractAM.PozBiccExtractAM.SupplierExtractPVO" Content (required): Version …Rohith Thomas 63 views 2 comments 0 points Most recent by Rohith Thomas Reporting and Analytics for ERP -
OTBI report generating several months in 1 reportDear All I am trying to create an OTBI report that can give me a sequence of months in 1 report I have the PPM module I want to know for each month the cost and the reve…mickel rmeily 53 views 4 comments 0 points Most recent by mickel rmeily Reporting and Analytics for ERP -
How can i connect to Essbase in PowerBISummary: We used oracle fusion cloud and able to connect to Essbase using Smartview in Microsoft Excel but when i try to connect to PowerBI using url it gives me error. …Ibrar.bajwa 127 views 2 comments 2 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
BICC costs to extract PVO from other serviceHi, As I am not sure on how particularly Oracle handles this area, I am trying to figure out the following scenario: we are trying to extract some data from Fusion using… -
Is there a way to report which report is used how frequently for BI/OTBI/BICC/FRS?Summary: Hi Team, We are looking for providing a metrics on usage of reports and wanted a way to report which report is used how frequently for BI/OTBI/BICC/FRS? Content…Abhilash K - Deloitte USI 63 views 3 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
ISO Format for the positive pay templateSummary ISO Format for the positive pay templateContent Hello All, We got a requirement for the positive pay in the ISO format but as of now we have only an etext seeded…Koteswararao Yenikepalli 86 views 3 comments 1 point Most recent by Mohamed Sadik -Oracle Reporting and Analytics for ERP -
What are the steps to enable & implement SAML authentication in Oracle fusion & also at client sideSummary: We are using SOAP APIs host://idcws/GenericSoapPort operations - GET_FILE, GET_SEARCH_RESULTS, UPDATE_DOCINFO for consuming data from UCM that is extracted via … -
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 73 views 5 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP