Reporting and Analytics
Discussion List
-
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 22 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Date prompt to pick dynamic date values from calender in BI Dashboard is not working.I have created a BI publisher report with date parameter and created a variable DB prompt with the Presentation variable as same parameter name, after adding both to Das…User_BUFJL 22 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 28 views 4 comments 0 points 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 16 views 2 comments 0 points Most recent by Radhika Abhyankar-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 14 views 1 comment 0 points Most recent by Radhika Abhyankar-Oracle Reporting & Analytics for Fusion Service -
Creating a Business Unit-Specific Lead and Opportunity Dashboard in Oracle FusionHi Community, I'm working on creating a dashboard in Oracle Fusion CX Sales to provide insights into lead and opportunity performance for specific business units. My goa…User_5FJ4I 43 views 4 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Essbase Cube, Report distribution, Oracle Fusion SaaS environmentWe are currently in Patch 24A getting ready to go to Patch 24B. We have Smart View and have build FRS WEB reports that users can run out of Financial Reporting Center. W…KeithM 4 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
How can I grant "GL users" access to the seeded "Payables Trial Balance Report"?We have a requirement in which "GL users" can generate the seeded "Payables Trial Balance Report" on their own to expedite their tasks. How can we configure this in Orac…Arsen Guevara-CITCO 25 views 3 comments 0 points Most recent by Sean Rogers Reporting and Analytics for ERP -
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 32 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 24 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting & Analytics for Fusion Service
-
How to get the Error Details of the Import Auto Invoice Execution Report through queryI am trying to create the join to abstract the Data from the tables used in the Auto Invoice Execution Report but not able to extract. Currently Using same Tables used i…
-
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 41 views 4 comments 0 points Most recent by Murugaganesh Reporting & Analytics for Fusion Service -
Payroll flow created for BI report is running into error "Dummy file is deleted"Executed the above remedy but getting the same error.User_BUFJL 12 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Need to schedule the ESS Job set in fusion to run on 1st business day of the month.We have a scenario where we need to run the ess job set on 1st business day of each month . is there any way apart from user schedule where we need to manually update th…
-
Barchart Label amount cannot show for some bars in EPM Cloud ReportIt was found that Barchart Label amount cannot show for some bars in EPM Cloud Report Check the "fixed_Barchart_Report" for Report. If print with HTML format, amount sho…Kenneth Kwok 11 views 1 comment 0 points Most recent by Dave Roberts_-Oracle EPM Platform and Freeform
-
How to restrict Inventory Items or On hand data based on User data access role in BIP Reports?Hi All, We have a requirement to restrict the Inventory Items or On-hand data based on User data access role Org assignments through BIP Reports. Currently, we have buil…Nagaraju Vandavasi 23 views 5 comments 0 points Most recent by Nagaraju Vandavasi Reporting and Analytics for SCM
-
REST API's related to projectPlanDetails (/fscmRestApi/resources/11.13.18.05/projectPlanDetails).Summary: Rest call (/fscmRestApi/resources/11.13.18.05/projectPlanDetails) returns forbidden error (HTTP-403) Content (please ensure you mask any confidential informatio…Prashant L 23 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
How can we enable audit in Fusion BIP layer to track who executed what query and when?As we do not have any way to restrict a user with Reporting and analytics access in Oracle Fusion to view data of certain tables. Hence, we're looking to explore the aud…PranjulG 35 views 1 comment 0 points Most recent by Swapnil Kashid Reporting & Analytics for Fusion Service
-
Printing the pdf Attachment in Oracle fusion BIP report output.Hello All , I have a pdf file added in the attachment at Sales order line item level. I would like to extract the attached pdf contents from the server and print it alon…
-
How to convert PERIOD NAME to Date data type?Hi I am using Between operator in Period Name and it is not working. Period Name is a Varchar type. How to convert it into Date data type so i can use between operator i…Khushi 46 views 6 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
IEX Fusion Essbase Data Integration QuestionHi All, We are currently reviewing ways to extract the metrics created in the IEX Essbase (Advanced Collections) for use in OAC. We thought to use Data Integration in EP…
-
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…
-
Oracle BIP Report Excel template output displaying Number values as TextHi, We have created the new custom BIP Report with Excel template and when we download the report output into Excel, then all Number values are displaying as text, these…Nagaraju Vandavasi 11 views 0 comments 0 points Started by Nagaraju Vandavasi Reporting and Analytics for ERP
-
BI Publisher template builder for Excel and Word Plugin in Microsoft integrated appsHi 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 Integrate…Murugaganesh 2 views 1 comment 0 points Most recent by Radhika Abhyankar-Oracle Reporting & Analytics for Fusion Service
-
We need a dynamic GIF Image send over emailWe need a dynamic GIF Image which is like a video image to be incorporated and send over email to employees on their birthday.Shaarif_Hussain 2 views 1 comment 0 points Most recent by Radhika Abhyankar-Oracle Reporting & Analytics for Fusion Service
-
Not able to print parameter values in BIP report, using if condition in Excel rtf templateUsing if condition in excel template had validated values if parameter is null , should return all as values selected is ALL, see below All But when i am populating spec…Shahid Qureshi 4 views 1 comment 0 points Most recent by Radhika Abhyankar-Oracle Reporting & Analytics for Fusion Service -
Need PVO's for below Tables for BICC ExtractSummary: Need PVO's for below mentioned tables for BICC Extract: 1) gl_coa_tree_versions_aggr_dtls 2) hr_operating_units 3) gl_seg_val_hier_rfNiharika Paramkusam-Oracle 12 views 1 comment 0 points Most recent by Radhika Abhyankar-Oracle Reporting & Analytics for Fusion Service
-
Need Information on Fusion tables related to REST APISummary: Would like to know which fusion tables are used to pull data for REST API /fscmRestApi/resources/11.13.18.05/projectPlanDetails. Content (please ensure you mask…Prashant L 11 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
How to download .PDF attachment from Contract through BIP report in fusionDears, We have a requirement to download .pdf attachment from contract. How we can download the above attachment (24000065-1 (1)نسخة التوقيع.pdf) from BI report. Thanks,…
-
Oracle Fusion Expense Report Attachment in a ReportIs it possible to provide link or access to the attachment uploaded to Expense Report within a BIP or OTBI report?