BI Cloud Connector
Discussion List
-
Use the ESS web service to schedule a job for running the BI cloud extractsSummary: We have been attempting to run a BICC based job from a SOAP\API call using something similar to the ErpIntegrationService submitESSJobRequest SOAP function but …AaronBaltimore 412 views 6 comments 0 points Most recent by LaurentDup Reporting and Analytics for ERP -
Which BICC PVO can be used specifically to extract data from PER_WORKING_HOURS_PATTERNS_F?Summary: Which BICC PVO can be used specifically to extract data from PER_WORKING_HOURS_PATTERNS_F? The lineage documentation (https://community.oracle.com/customerconne…
-
Ljava.lang.Object; is passed when multiple values are seleted in parameter in oracle BIP reportSummary: Hi Everyone, We have created a custom BIP report that will trigger the OIC integration from the Data model. We are passing a few parameters to the report. One o… -
NegotiationAwardAcceptancePVO via Data Transforms (Data Load) ORA-12899: value too large for columnCONTEXT Starting with Fusion 26B, we have started loading data from Fusion BICC PVO FscmTopModelAM.PrcExtractAM.PonBiccExtractAM.NegotiationAwardAcceptancePVO into Oracl…Stéphane Lamy-Bouchard 14 views 0 comments 1 point Started by Stéphane Lamy-Bouchard ERP Integrations
-
Can the column count of each BICC extract be captured?Summary: We have an ask from audit to confirm that each BICC extract contains the complete dataset for a period of time and that no data was missed and that the file is … -
HcmTopModelAnalyticsGlobalAM.PositionAM.PositionPVO dSummary: HcmTopModelAnalyticsGlobalAM.PositionAM.PositionPVO extract giving duplicate records Content (please ensure you mask any confidential information): HcmTopModelA…Pradeep Reddy 18 views 2 comments 0 points Most recent by Mark Di Ponio Reporting and Analytics for HCM
-
subject areas Distributed Order Orchestration - Fulfillment Lines Real Time and Shipping Real timeI need to create prompt in OTBI with Aging days having case function defined, when running i am getting the below error, can someone help me on this CASEWHEN Timestampdi…Shahid Qureshi 01 17 views 1 comment 0 points Most recent by AnushaDB-Oracle Reporting and Analytics for HCM
-
Item EFF/DFF public viewobject in BICCSummary: What is the BICC Public View Object to extract the Item EFF and DFF values from Fusion Cloud. I am unable to download the 26A version BICC extract files for HCM…
-
subject areas Distributed Order Orchestration - Fulfillment Lines Real Time and Shipping Real timeAs per the business custom requirement OTBI subject areas to be used are Distributed Order Orchestration - Fulfillment Lines Real Time and Shipping Real time which is cc…Shahid Qureshi 01 16 views 0 comments 0 points Started by Shahid Qureshi 01 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 …Mohak Kirtane 161 views 3 comments 1 point Most recent by Matthew - Town of Aurora Reporting and Analytics for ERP
-
BICC columns with numeric datatype fetching incorrect decimal values.Summary: We observed that an issue with BICC extract for columns with numeric datatypes. We noticed that columns with numeric datatype, for decimal values, its fetching …Joel Prakash-Oracle 29 views 2 comments 1 point Most recent by User_KBP71 Reporting and Analytics for ERP
-
Unable to establish secure FTP connection with carriers, The Firewall is blocking port 10022Summary: While creating secure FTP connection with carriers, The Firewall is blocking port 10022, How to whitelist this port ? Content (please ensure you mask any confid…
-
Extract the UCM content server attachments through BI ReportsSummary Extract the UCM content server attachments through BI ReportsContent Hi, PDC attachments(File formats like PDF,Excel,JPG etc) currently placed in UCM content ser…
-
AR Transaction Approval QuerySummary: Hi Team, Please help to get table that stores AR transaction approval History.User_S5U61 16 views 1 comment 0 points Most recent by Vighnesh Khade Reporting and Analytics for ERP
-
Missing informations in FscmTopModelAM.PrcExtractAM.PozBiccExtractAM.SupplierExtractPVOSummary: Why ZX_PARTY_TAX_PROFILE Informations regarding Suppliers are not in the PVO 'FscmTopModelAM.PrcExtractAM.PozBiccExtractAM.SupplierExtractPVO' but only in the o… -
How to pull data in Power BI from Oracle Fusion/ATP TablesSummary: How to pull data in Power BI from Oracle Fusion Content (please ensure you mask any confidential information): We are looking to pull data in Power BI from Orac…Abhishek Sinha 178 views 2 comments 0 points Most recent by User_DXIFI Reporting & Analytics for Sales
-
Request Documentation on Critical PVOs for Oracle Fusion HCM Integration with Data LakeDear Team, We have recently implemented Oracle Fusion HCM and are now working on integrating it with our Data Lake. To better understand the critical PVOs required for t… -
Prune Time for Hourly BICC ExtractsSummary: We have BICC Extracts running hourly and prune time set to 60. But the downstream applications have issues with the number of duplicates generated in every run.…
-
Connection Timeout (Error 404/504) when connecting BI Publisher to OIC File Server via Port 10134.Summary: Connection Timeout (Error 404/504) when connecting BI Publisher to OIC File Server via Port 10134. Content (please ensure you mask any confidential information)…Edward Villanueva 51 views 1 comment 0 points Most recent by Shradhanjali_Oracle-Oracle Reporting and Analytics for ERP
-
Seeded Process/Report/Data Model customizationSummary: Once we did customization of seeded Process/Report/Data Model, after applied any patch/upgrade then the customization changes will override. Content (please ens…
-
Why certain BICC Public VOs do not support Incremental Load?Hello Team, We noticed that certain BICC Public View Objects do not support Incremental Load. Below are names of some of the VOs and screenshot showing 'Supports Increme…
-
Oracle Business Analytics Reporting OverviewSummary Watch this video to learn about using Oracle Business Analytics for Supply Chain Management.Content Link to the video: https://www.youtube.com/watch?v=DSRvYKS2wG…Pankaj Mongia-Oracle 551 views 2 comments 11 points Most recent by Mohammed Rafi Reporting and Analytics for SCM -
Regarding - Alerts Failure during Bulk LoadSummary: We have implemented multiple custom BI Publisher–based alerts that are triggered on specific business scenarios and scoped to particular Business Units. During …Abdul Raqueeb 6 views 0 comments 0 points Most recent by Abdul Raqueeb Reporting and Analytics for HCM
-
Mapping between API entities and fields and BICC BIVO objectsSummary: I'm looking for a mapping between API entities and fields and BICC BIVO objects For example: I want to know which BIVO objects matching the API for REST API for…
-
Historical FTE values in BICCHi, The customer would like to extract assignment history data, including FTE, using BICC. I found that we can retrieve historical assignment data through HcmTopModelAna…
-
How to enable Support Incremental Checkbox on a PVO on BICCSummary: How to enable Support Incremental Checkbox on a PVO on BICC? We currently do not have the option to enable this. Content (please ensure you mask any confidentia…Carlo Orolfo 62 views 4 comments 0 points Most recent by Sai Revanth Reporting & Analytics for Sales
-
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…User_2025-03-07-18-57-57-349 73 views 2 comments 0 points Most recent by Sai Revanth Reporting and Analytics for ERP
-
R13.x CX BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 CX BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter Develo…Rashmi M-Oracle 10.4K views 11 comments 15 points Most recent by Dave Kekish Reporting & Analytics for Sales
-
How to Format a Date Column to include Time Stamp in BICC Extract OutputSummary: Hi, I am trying to extract fusion table data using BICC, and I am seeing when the data is exported the date fields doesn't have the time values in it even thoug…Ragul Halan 31 views 2 comments 0 points Most recent by Deputy Birara-Oracle Reporting and Analytics for ERP
-
Oracle BI Cloud Connector (BICC) to Flexfields data from HCMSummary: We are using Oracle BI Cloud Connector (BICC) to extract data from HCM using a third party tool (FIvetran). However, we have a need for a couple columns of data…