BI Cloud Connector
Discussion List
-
OTBI: Prompt Link not workingHello All, When prompt link is generated either from edge or chrome browser it error out as Bad Gateway. Any help would be appreciated! Thank you.Gail Wilmoth 21 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Is there a size limit to extract data from Fusion ERP?Summary: We will extract data out from Fusion ERP using BIP, BICC to Data warehouse. Is there a data limit? Will Oracle charge for outbound (egress) traffic? Content (pl…Jie Shen 176 views 3 comments 0 points Most recent by Madhavi.Godbole Reporting and Analytics for ERP -
How to get row count from PVOs in BICC?Summary: We have been asked to verify that the # of rows we have pulled out of Oracle via BICC is correct. When we attempt to do a COUNT(*) against some PVOs, we are get… -
What is mean by Translation information in the data tables?Summary: What is mean by Translation information in the data tables? Content (please ensure you mask any confidential information): Hi Team, I have a query. What is mean…
-
RTF Excel Output Merging CellsTeam, We have developed BI Report with RTF template. When user exporting the output in Excel output the cells are getting merged. Example B & C columns are merged. We ha…
-
How to get 'Email From Address' in query?Hi, Can someone help me to get the 'from email address' configured in BI server by sql? Regards, NivyaNivya Mathire 62 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
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 336 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 32 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…
-
Differance between data table ending with "_" and normal data table?Summary: Differance between same data tables but ending with "_" table? Content (please ensure you mask any confidential information): Hi Team, I have a query. what is t…
-
Differance between table and view?Summary: What is the differance between table and view? Content (please ensure you mask any confidential information): Hi Team, Can some one will help me the below query…
-
Types of keys in data tables?Summary: How many types of keys are there in data tables? Content (please ensure you mask any confidential information): Hi Team, I have some queries. How many keys are …
-
Adding two person types into one OTBI analysisSummary: According to our current practice when employees are retiring we change their person type into "retiree" in the system. I need to create an analysis to capture …Ayesha Iroshani 21 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
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 -
ORACLE FUSION SAAS CLOUD BI REPORT TIME OUT ISSUESummary: ORACLE FUSION SAAS CLOUD BI REPORT TIME OUT ISSUE Content (required): ORACLE FUSION SAAS CLOUD BI REPORT TIME OUT ISSUE IN DATA MODEL PROPERTY I HAVE INCREASED …RIfdhy Zain 31 views 4 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Identifying global transfer records, hire/rehire records from per_periods_of_serviceSummary: Identifying global transfer records, hire/rehire records from per_periods_of_service Content (please ensure you mask any confidential information): Hi All, Empl…Gayathri K M-Oracle 786 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Need to export Cost Center info using FiveTran. Does anyone know which object this exists on?Summary: I think it should be in an object called assignmentDFF (that is where it is found using Rest API), but I don't see a corresponding table. Content (please ensure…Derek Horrall 11 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
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… -
Backend table name for Role Code field for View ObjectSummary: We are going to create a Report for Monitoring and I would like to know the backend table name for Role Code field for View Object CrmAnalyticsAM.ResourcesAnaly…Carlo Orolfo 111 views 13 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
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… -
Connect Oracle cloud HCM to MS power BI reportSummary: Connect Oracle cloud HCM to MS power BI report Content (please ensure you mask any confidential information): Hi, Is it possible to connect Oracle HCM data sour…Bhavna-Civeo 71 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
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 61 views 3 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
Unable to find Organization goals Check Box in HCM tables.Summary: Dear , I want to know in oracle fusion which table I can find "Share this goal with your organization" .I was searched all goals tables but not found in table T…challa praveen 31 views 2 comments 0 points Most recent by challa praveen Reporting and Analytics for HCM
-
Choosing Position PVO from BICC - PositionPVO vs PositionPVOViewAllSummary: We are implementing a data warehouse and establishing BICC data extraction pipelines. In reviewing the available PVOs for HCM Position data, there are two relev…Josh Vincent 131 views 1 comment 1 point Most recent by Aaron Leggett Reporting and Analytics for HCM
-
Is there a report/subject area/table/view that pulls all role/data access auto-provisioning rules?Summary: I am in search of a way to pull in all of the active auto-provisioning role/data access rules (rule name, conditions, assignments (associated roles, associated …
-
How to retrieve the OLD payroll frequency and NEW Payroll frequency in the BIPHi ALL, Kindly support me to resolve below issue: I have a requirement to retrieve the OLD payroll frequency and NEW payroll frequency in BI report. Following with other…RamkumarKadhiravan 21 views 2 comments 0 points Most recent by RamkumarKadhiravan Reporting and Analytics for HCM -
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 61 views 4 comments 0 points Most recent by SiddharthDang-Oracle Reporting and Analytics for ERP
-
Expand Issuing comments in Document Record Notification email templateWe are currently working on expanding the comment box for document record email notifications and BPM work lists, as the current character limit does not align with the …
-
Needs feasible outputs from BICCSummary: We have a requirement where we are configuring object loads from BICC and consuming it at a third party system. The BICC output files are currently outputted as…Rajita Ganti 111 views 3 comments 0 points Most recent by Kammarapalli Venkatesh-Oracle Reporting & Analytics for Sales
-
how to use BICC for extracting large data from cloudSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):user12941432 21 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM