BI Cloud Connector
Discussion List
-
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 … -
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 …Rashmi M-Oracle 21.3K views 89 comments 26 points Most recent by Dave Kekish Reporting and Analytics for ERP
-
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 31 views 5 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
Tables not available for BICCC extraction - what is the alternative?Summary: While configuring data extract from BICCC, we notice that within a data store many tables do not have equivalent PVO. Below are few examples where I could not f…Sharas Vitalapuram 21 views 2 comments 0 points Most recent by ravikiran goda-Oracle Reporting and Analytics for ERP
-
OTBI login based data will display but user id not matchedSummary: OTBI dash board /analysis based on login user name data will display if user name/display name not matched still they want data using custom session variable to…SivaKrishna-Oracle 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Getting the error 'ORA-31011: XML parsing failed' when calling the SAAS report through webserviceSummary: I am getting the below error when calling the SAAS report through webservice call from my pl/sql procedure. 400 Bad Request 400 Bad…
-
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 11 views 0 comments 0 points Started by Roman Havrylyak Reporting and Analytics for ERP -
Supplier Qualification Infolets page showing initiatives status graph by login baseSummary: Supplier Qualification have Infolets page showing initiatives status by graphical view by the login base and customer want to see the globally ,how many initiat…SivaKrishna-Oracle 11 views 3 comments 0 points Most recent by SivaKrishna-Oracle Reporting and Analytics for ERP
-
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…Naved Khan 21 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
Suggest Some Price List table in oracle fusionSummary Please suggest some price list table in oracle fusion and where can we find themContent Please suggest some price list table in oracle fusion and where can we fi…user12240811 10 views 3 comments 0 points Most recent by Waleed Fetoh 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 92 views 7 comments 0 points Most recent by Ananya Sadhukhan Reporting and Analytics for ERP
-
BICC Downloading Files from UCMSummary: We are investing using BICC to schedule extract from Oracle ERP rather than relying upon our existing process of using Custom BI Publisher Reports then bursting…Rob_C19 51 views 3 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
Bank Return Records BIP queryHi All, I m new to fusion finance module, we have a requirement to fetch all the bank return records through BIP query, Can anyone help us with SQL query or the table na…Yuvraj S-Oracle 21 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
need to connect oracle data from php or via MS power bi to retrieve dataSummary: need to connect oracle data from php or via MS power bi to retrieve data Content (required): need to connect oracle data from php or via MS power bi to retrieve…RIfdhy Zain 21 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Which BICC PVO should be used to extract Supplier/Vendor 'Name' to match to BICC Invoice Headers extContent Which BICC PVO should be used to extract Supplier/Vendor 'Name' to match to BICC Invoice Headers extract PVO? Version 21_BJeannieMoore 65 views 1 comment 1 point Most recent by Marc Vermeulen Reporting and Analytics for ERP
-
SOAP - Internal Server Error 500Hi Team, Can you please help in the below context SOAP - Internal Server Error 500 Thanks, Saurabh Singhal.SaurabhSinghal 31 views 5 comments 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for ERP
-
How to get the GL Segments Flex value set IDs for seeded and custom segments from EBS R12 DBSummary: EBS R12 SQL or base tables to fetch GL Segments Flex value set IDs for seeded and custom segments. Content (required): There is a need to fetch GL Segments Flex…Manu R-Oracle 31 views 1 comment 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
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 …
-
Oracle ERP Cloud - Data Extraction via BICCHi - We are building a cloud data warehouse using data from Oracle SCM Fusion Cloud 22d using Oracle Business Intelligence Cloud Connector (BICC) for data extraction usi…satya_nvs 221 views 7 comments 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
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…
-
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. 21 views 1 comment 0 points Most recent by Guillaume Lecouteux. 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 71 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 81 views 0 comments 1 point 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 11 views 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