Popular Tags
- OTBI 1,482
- Reporting 1,408
- FDI 1,216
- Fusion AI Data Platform 1,043
- Analysis and Data Visualization 1,011
- BI Publisher 879
- Analysis 691
- Oracle Fusion Analytics 618
- Administration 556
- OAC 548
- OBIEE 437
- Fusion HCM Analytics 428
- Analytics 427
- Fusion ERP Analytics 413
- BI Publisher Data Models 362
- Security 303
- HCM 287
- BIP 268
- Answers 266
- Analyses 256
- Oracle Analytics Cloud 255
- Developers 248
- Data Modelling and Datasets 235
- Fusion Data Intelligence 219
- ERP Analytics Content 217
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
BI Cloud Connector
Discussion List
-
34Ability 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 800 views 13 comments 34 points Most recent by User_G3G4V Oracle Analytics Publisher Idea Lab -
2Fetch Fields via BICCWe have a need for a couple columns of data to be extracted that aren't natively exposed via BICC: PER_ALL_ASSIGNMENTS_M.ASS_ATTRIBUTE_NUMBER1 PER_SENIORITY_DATES_F.SENI…Devanshi Desai 1 view 0 comments 2 points Most recent by Devanshi Desai Oracle Analytics Publisher Idea Lab -
23Setting Prune time for each and every PVO and Job Level in BICCOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Description (Required): As we need to…Vivek Gautam 162 views 5 comments 23 points Most recent by Praveen Thota Oracle Transactional Business Intelligence Idea Lab -
4BICC - Enabling Audit LogsHi team, We have been trying to determine if there are audit logs for BICC that capture user actions on the UI. For example, when a BICC job is edited, are those actions…Harishma 51 views 4 comments 4 points Most recent by User_RQJA8 Oracle Transactional Business Intelligence Idea Lab -
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…Chandra Chappidi 492 views 4 comments 1 point Most recent by User_E5M99 Oracle Fusion AI Data Platform Forum -
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 542 views 4 comments 4 points Most recent by IteSel Oracle Fusion AI Data Platform Idea Lab -
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… -
17Need attribute (DFF) columns included in supplied PVOsOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Jacobs Technology Inc Description (Re…Kazeem 401 views 5 comments 17 points Most recent by Pankaj Dhoopar Oracle Transactional Business Intelligence Idea Lab -
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 201 views 3 comments 0 points Most recent by LaurentDup Oracle Transactional Business Intelligence Forum -
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 61 views 1 comment 0 points Most recent by User_CC2I2 Oracle Transactional Business Intelligence Forum -
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 32 views 3 comments 0 points Most recent by RVohra Oracle Transactional Business Intelligence Forum -
How to delete all jobs at once in BIACM/BICC?How to delete all jobs at once in BIACM/BICC? Thanks in advance.MohanPothuri 88 views 4 comments 0 points Most recent by RVohra Oracle Fusion AI Data Platform Forum -
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 156 views 3 comments 11 points Most recent by Vignesh Subramanian Oracle Transactional Business Intelligence Idea Lab -
13BI 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 221 views 5 comments 13 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 31 views 2 comments 0 points Most recent by SunilRamankutty Oracle Analytics Publisher Forum -
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 AI Data Platform 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 Forum -
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.2K views 5 comments 0 points Most recent by Antariksh Kar-Oracle Oracle Transactional Business Intelligence Forum -
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 12 views 0 comments 2 points Most recent by Abhilash Baggam Oracle Analytics 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 11 views 1 comment 0 points Most recent by Subha_Tripathy-Oracle Oracle Fusion AI Data Platform Forum