Popular Tags
- OTBI 1,445
- Reporting 1,392
- FDI 1,109
- Analysis and Data Visualization 984
- BI Publisher 852
- Analysis 680
- Oracle Fusion Analytics 583
- Administration 555
- OAC 447
- OBIEE 433
- Analytics 399
- BI Publisher Data Models 354
- Security 293
- HCM 265
- Answers 264
- BIP 263
- Analyses 255
- Developers 245
- Data Modelling and Datasets 228
- Data Connectivity 210
- ERP Analytics Content 208
- BI Publisher Report Templates 204
- Oracle Analytics Cloud 192
- Report Output 184
- Fusion Data Intelligence 174
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
BI Cloud Connector
Discussion List
-
Fusion to BI Publisher connectionHi everyone, I’m getting this error while using the BI Publisher connector in Fusion: The report definitely exists in that folder, and I can run it manually in BI Publis… -
Recommended frequency to extract the active primary keys/application dataWe are currently using BICC to extract FSCM, CRM, etc. data to build a data warehouse for analytics (one time full load followed by incremental loads). Noticed that BICC…Harishma 174 views 3 comments 0 points Most recent by LaurentDup Oracle Transactional Business Intelligence -
4Using BICC PVOs and need a method for identifying records that are deleted in Cloud FusionCurrently using BICC PVOs to extract Cloud Fusion data from different workstream areas (FSCM and HCM) to build a data store - used for reporting and analysis. We have no…RFong at PSJH 484 views 3 comments 4 points Most recent by Dave Kekish Oracle Fusion Data Intelligence Idea Lab
-
BICC : Last Extract Date for PVOs reset only if the Extract Schedule completed successfullySummary Update the logic to ensure Last Extract Date for PVOs resets only if the whole Extract Schedule completed successfully Content Currently, we have instances where…Yogesh Sureshkumar 54 views 1 comment 0 points Most recent by User_CC2I2 Oracle Transactional Business Intelligence
-
Talent review template name column subject area for otbiHi, We are in need of assistance to locate the OTBI subject area for the following columns: Talent Review Template name Selected Population Employee Name Selected Popula…Sujan Kumar Dash 18 views 3 comments 0 points Most recent by RVohra Oracle Transactional Business Intelligence
-
How to delete all jobs at once in BIACM/BICC?How to delete all jobs at once in BIACM/BICC? Thanks in advance.
-
The database mappings of some of the BICC VOs are not present in the list released by Oracle.We have configured Oracle BICC to extract HCM data. I am trying to find the mappings between VOs and tables. The below support note Doc ID 2506210.1 provides list of HCM…
-
11Option to rename the BICC Output file according to desired file naming conventionsOrganization Name : Nokia Sol. & Networks Oy Description : Currently the output generated through BICC extracts consist of a Manifest, json and Output files zipped with …User_5XOT1 113 views 3 comments 11 points Most recent by Vignesh Subramanian Oracle Transactional Business Intelligence Idea Lab
-
12BI Cloud Connector (BICC): Ability to join multiple data stores within BICC for a single file outputHello, We have a requirement to collect the Fusion Payables payment data incrementally from various data stores (PVO) of payments, invoice payments, invoices, invoice li…User_567A7 193 views 5 comments 12 points Most recent by AC-Shammi Meshram Oracle Transactional Business Intelligence Idea Lab
-
Initial synchronization for large tables using BICCOur implementation involves several large tables containing millions of transactional rows that need to be synchronized between SaaS and PaaS using BICC. While increment…SunilRamankutty 22 views 2 comments 0 points Most recent by SunilRamankutty Oracle Analytics Publisher
-
1Need PVO for fusion GOP tables MSC_HVGOP_DAILY_AVAIL_REPORT and MSC_HVGOP_WEEKLY_ALLOC_REPORTOur current requirement needs to capture the data in these tables and it is not possible to get the entire data using BIP in one go. Also the nature of data load to thes…Sridhar G 11 views 1 comment 1 point Most recent by Kausik Misra Oracle Fusion Data Intelligence Idea Lab
-
PVO for BICC SYNC - columns - TXN_XFACE_CTRL_ID and USER_BATCH_NAME Table PJC_EXP_ITEMS_ALLlooking for PVO for BICC SYNC having columns TXN_XFACE_CTRL_ID and USER_BATCH_NAME from Table PJC_EXP_ITEMS_ALL. Please help.Naved Khan 21 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Oracle Transactional Business Intelligence
-
BICC : Reset Last Extract Date at PVO LevelSummary To allow users to reset Last Extract Date to a specific date at PVO Level instead of the current across all offerings level Content Currently there are two ways …Yogesh Sureshkumar 1.1K views 5 comments 0 points Most recent by Antariksh Kar-Oracle Oracle Transactional Business Intelligence
-
26Ability to store output BI Publisher to object storage on OCIOrganization Name : Gemeente Rotterdam / City of Rotterdam Description (Required): We have an external datawarehouse and need to export the data from SaaS to that datawa…Pam Koertshuis 684 views 8 comments 26 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher Idea Lab
-
2Add Timestamp value in BICC PVO DateTime columns FscmTopModelAM.FinGlJrnlEntriesAM.JournalHeaderPVOCurrently the JrnlHdrPostedDateTime column and other similar DateTime columns have only Date datatype and value. It does not contain the timestamp value even though the …Abhilash Baggam 14 views 0 comments 2 points Started by Abhilash Baggam Oracle Analytics Cloud and Server Idea Lab
-
Why aren't all DFF attribute columns included in CrmExtractAM.OkcBiccExtractAM.ContractHeaderExtractWe’re currently looking to retrieve the Remit Address value from the base table OKC_K_HEADERS_VL, where this information is stored in the ATTRIBUTE1 column. It’s our und…hunter.mlady 12 views 1 comment 0 points Most recent by Subha_Tripathy-Oracle Oracle Fusion ERP Analytics -
Unable to find BICC PVO Names for tables OSS_ENT_PLAN_ESTIMATES , OSS_ENTITLEMENT_PLANSHello Everyone, I am currently working on a data extraction using Business Intelligence Cloud Connector (BICC) in Oracle Fusion. I need to extract data from the followin…Bhanu Priya 13 views 1 comment 0 points Most recent by Gianni Ceresa Oracle Business Intelligence Applications
-
I'm new to BICC - any PVO advice?I hope this is the right community. I couldn't find one specific to BICC. My background is in integration platforms such as OIC and BizTalk, so working with the Fusion &…Todd Hensley 61 views 1 comment 0 points Most recent by Gianni Ceresa Oracle Analytics Cloud and Server
-
metadata file for the PO Header and PO Line DFFsCan you provide a sample extract or schema definition for the PO Header and PO Line DFFs that lists both the column names and their data types? FscmTopModelAM.POLineDFFP…Sachin Shejwadkar 1 view 1 comment 0 points Most recent by Riyaz Ali-Oracle Oracle Transactional Business Intelligence
-
How to retrieve the BICC User Logs?We need your guidance on how to retrieve BICC user logs, specifically logs that capture details of when a user has modified offerings or job schedules. Our objective is …Imran Shaha 43 views 1 comment 0 points Most recent by Bhaskar Konar Oracle Business Intelligence Applications