Analytics
Discussion List
-
Is there any documentation for the setup of FDI/FAW Fusion Analytic ?FDI Fusion data intelligence FAW Fusion analytic warehouseOmran Zeaiter 43 views 1 comment 1 point Most recent by Cătălin Hurjui-Support-Oracle Reporting & Analytics for Fusion Service -
Effective date / Frozen date on FAW/OACHi guys, Our client is asking us to use this "effective date" parameter on FAW/OAC but with a specific requirement : They would like to have this "frozen date" every mon…Lauriane Massin Whitaker 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Fetch a SQL for requisition Progress SummaryAnyone please help me to fetch a Progress Summary details in ORC.Gowri Perumal 61 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Looking for linkage details for some of the Fusion HCM PVOsBelow is the list of PVOs which are missing in Rel13_24C_BICC_HCM_Database_Mapping_with_ViewObjects. If anyone happen to have these details please share. Hcmtopmodelanal…Vineeta Agarwal-Oracle 21 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Extract name field from transaction console pageTransaction table for extracting the Name field in transaction console. Please assist
-
Not able to add Budget Values(amount) column in FRS Report.We have an FRS Report for Profit & Loss Account where the accounted values are reflected. We have a requirement to add Budget Values also in the FRS, but we have tried e…Jagjit Singh Arora 31 views 4 comments 0 points Most recent by Jagjit Singh Arora Reporting and Analytics for ERP
-
How to get overridden account attribute from AP tables?Hello, I am not able to find attribute for Overridden account in any AP tables. I am using Oracle Fusion Cloud Applications 24B (11.13.24.04.0) and the tool i am using f…
-
Compare 2 Versions of BIP Report between 2 different instances in Oracle FusionHi All, We're exploring options to compare two versions of a BI Publisher (BIP) report, including both the data model and report definition, to identify changes between …Pooja K-Oracle 171 views 4 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting and Analytics for ERP
-
Send Email to multiple employees based on the region they belongHi Team, We have received requirement where we need to send the email to all pending workers who are based in an office, and provides important Day 1 information. There …Vinay_Raulwar -Oracle 11 views 0 comments 0 points Started by Vinay_Raulwar -Oracle Reporting and Analytics for HCM
-
Add otbi report in a DCS appContent Hi, We are trying to add OTBI reports in a DCS application. We tried using iframe using the analysis URL but are only able to view the report data if I am logged…ShreySH-Oracle 36 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
Chat report by Activity level by DaySummary: Is there a chat report that shows the most active time of day and can graph it for me? Content (required): Interval, month/.day/hour (not inclduing weekends) an…Marissa Gonzales 21 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
Truncate the Data size to avoid "ORA-12899: value too large for column" in ODISummary: We have a source a file that has more than 4000 char in one column and we trying to load data in ADW but the maximum varchar2 character limit is 4000 char only …Vivek Gautam 230 views 2 comments 1 point Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
Query to fetch approvers listWe are trying to customize performance seeded report and trying to fetch the list of approvers/managers who has approved the document. We are trying to get the details f…
-
What is the impact of renaming a Fusion Analytics DataWarehouse DBaaS Database?Summary: We've deployed Fusion Analytics Warehouse as a PaaS service (Version 24.R1.P3). As part of that deployment, the DBaaS instance is created simultaneously, but we…Clay T. 12 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Where can i find Item Drawing Number in Oracle Fusion ERP tables ?I Am trying to search for "Drawing Number" in oracle fusion ERP tables, it might be an Attribute but I am not getting in which table I can find this attribute. Please re…Dona Sengupta 11 views 2 comments 0 points Most recent by Dona Sengupta Reporting & Analytics for Fusion Service
-
How do we add Tasks, Reports and Analytics Panel to the Order Management PageSummary: How do we add Tasks, Reports and Analytics Panel to the Order Management Page Content (required): Business requirement is to add tasks, reports and analytics pa…kalyan gade 111 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
Is it possible to track BIP report logs where user has not submitted a report jobSummary: A user logs in to Report & Analytics and opens any custom BIP report to view/export output, without submitting a report job. We are looking to get table/report …Mayur_P 21 views 2 comments 0 points Most recent by Mayur_P Reporting & Analytics for Fusion Service
-
Contract duration is displaying no data on FAWHi, I've been trying to create a simple report to show the contract duration of the new hires in a company for a specific month. My reports should look like that where T…Lauriane Massin Whitaker 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Does SOC1 report also covers OTBI and BI PublisherDoes SOC1 report also covers Oracle Transaction Business Intelligence (OTBI) and Oracle Business Intelligence Publisher (BI Publisher)?Temi A. 13 views 3 comments 0 points Most recent by Temi A. Reporting & Analytics for Fusion Service
-
Unable to see the DFF attribute which are based on Table type value set in the OTBI subject areaHi All, We have created a few custom DFF attributes under Manage Customer Account Descriptive Flexfields. Few are based on independent value sets, and few use table-type…Gurujothi D 97 views 1 comment 0 points Most recent by Bodhisattwa Mukherjee-Oracle Reporting and Analytics for ERP
-
FDI Report AccessHi, I am currently unable to see any workbooks in the FDI environment but a different user is able to for the same environment. What would I need to change for my accoun…User_EO6AY 41 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Change the source environment for FAWHi, Our FAW dev instance is linked to an HCM test environment which has not been refreshed recently.., I'l like to change the source with another HCM test environment wh…Lauriane Massin Whitaker 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
FAW average assignment calculationHi, I have a report to produce using the assignment count KPI for different years. I've been struggling in FAW to create the calculation that would allow me to display t…Lauriane Massin Whitaker 21 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Best way to create reports from Oracle General Ledger data?What's the recommended approach for building custom reports from Oracle General Ledger data.I'm building a custom periodic trial balance report in Oracle. I need to incl…Omran Zeaiter 21 views 4 comments 1 point Most recent by Jagdish Kumar Arora General Ledger & Intercompany
-
Can we create custom folder in UCMHi Team, Can we create custom folder on UCM.vikram khengare 11 views 2 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Possibility to combine multiple rows into one cell in Oracle SQL data base.Summary: I have a query regarding the possibility to combine multiple rows into one cell in Oracle SQL data base. We have tried STRING_AGG, LISTAGG and WM_CONCAT, but no…Lizy Lazaro 13 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
Security and AOR Report: Inactive Assignment Locations IssueWe created a Security and AOR report that provides person roles and areas of responsibility. The expected result is when a user runs this report he should able to see al…Niranjan_1190 41 views 1 comment 0 points Most recent by Niranjan_1190 Reporting and Analytics for HCM
-
Is it possible to zip multiple template layout outputs from a single report into a single file?I'm looking to understand if there is a way to consolidate multiple template layout outputs from a single report into a single zipped file. If anyone has experience with…Omran Zeaiter 23 views 2 comments 1 point Most recent by Raghavan p-Oracle Reporting & Analytics for Fusion Service
-
FAW reportingHi everyone, I was wondering where I could find a list of all the kinds of reportings that can be done with FAW (in the fied of Human Resources )? Thank youLauriane Massin Whitaker 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
BI Publisher template builder for Excel and Word Plugin in Microsoft integrated appsSummary: Hi Everyone, Our customer is moving to Microsoft integrated apps where all manual plugins will go away. Which means any plugin will be handled in MS Office 365 …Murugaganesh 44 views 4 comments 0 points Most recent by Murugaganesh Reporting & Analytics for Fusion Service