Reports
Discussion List
-
Is there a way in which we can schedule reports in Narrative reportingContent Bursting option is available but do we have a way in which we can schedule reports (MR) in Narrative Reporting Version 21.02.85 -
Effective End Date not pulling in element reportSummary Effective End Date not pulling when reporting on element entriesContent Hi, I'm using the Payroll - Element Entries Real Time subject area to show pay element in… -
Analysis failing with error: Exceeded configured maximum number of allowed output prompts, sections,Content Hello Experts, I had built a dashboard using the Absence Calendar Details Real Time subject area having two sections - Summary and Detail Analysis reports. I had…Akash Kiran Jana 27 views 4 comments 0 points Most recent by Akash Kiran Jana Reporting and Analytics for HCM -
Infolet Dashboard to be Printed as a Page for Management ReportingSummary Infolet Dashboard to be Printed as a Page for Management ReportingContent We have built Risk Management Infolet section and Client wants to download this as a re…ArunMajumdar 25 views 3 comments 3 points Most recent by SantoshKumarBhairi Reporting and Analytics for ERP -
Financial Reporting Studio Desktop - DecommissionSummary Transition from Desktop to Web toolContent Hi, We are using Financial Reporting Studio Desktop tool since 5 years ago for development of ERP Financial Reports, a…Patricia Gonzalez 49 views 9 comments 4 points Most recent by Rich Merkel Reporting and Analytics for ERP -
Proper Case Function in OTBIContent Is there a function in OTBI that transforms character strings from their current state into PROPER case format? For example: 'JOHN SMITH' or 'John SMITH' to 'Joh…Dustin Dominic 42 views 2 comments 2 points Most recent by Dustin Dominic Reporting and Analytics for HCM -
Extract Cost Center from "Code Combination Description" field - (Procurement - Spend Real Time) subjSummary Extract Cost Center from "Code Combination Descpription" fieldContent I am using "Code Combination Description" field as one of my select columns from (Procureme…UjasB 252 views 5 comments 0 points Most recent by Anders W. Langholm Reporting and Analytics for ERP -
Dynamic printing of column labels in OTBI or BI PublisherSummary Dynamic printing of column labels in OTBI or BI PublisherContent Hi All Kindly share your experiences on how you have been dynamically creating reports with titl…User_2025-02-08-03-05-58-849 18 views 1 comment 2 points Most recent by User_VLBBP Reporting and Analytics for HCM -
Best practice for Developing Custom BIP reports and securing them in ERPSummary Looking for best practices for custom BIP reports for ERP which can be secured by Role and Data Access Sets similar to UIContent Hi, Our client has complex enter…Subhash Valiveti 395 views 15 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for ERP -
Org Tree Flatenned TablesSummary Org Tree Flatenned TablesContent Hi All, Can someone share the SQL if available handy to get Org tree (Bottom -> Up) details using Flatenned tables in HCM? Regar… -
Tables to query files imported to ERPSummary We want to create a report that list the files imported to the ERP from external systems for reconciliation purposes.Content Hello evryone, Anyone can hep me to …User_B9AX9 69 views 1 comment 0 points Most recent by Christian Guidibi Reporting and Analytics for ERP -
Transaction Query exampleSummary example of a GL Transaction query flexible to a range of parametersContent Seeking an Oracle Cloud example of a GL transaction query that returns line item detai…User_2025-02-11-03-09-13-126 357 views 6 comments 2 points Most recent by Sahil_Makhiza Reporting and Analytics for ERP -
Need to generate audit report for Person and Assignment EFFContent I need to be able to run the 'Generate audit Report' Scheduled Process for changes made to both an Assignment and Person EFF. I have turned it on and managed to …Jasmin S 53 views 18 comments 1 point Most recent by Jeff Hare CPA CISA CIA Reporting and Analytics for HCM -
Model Profile - Employee Level - FUSION OTBISummary Model Profile - Employee Level - FUSION OTBIContent Hello We have the attached Model Profile Information report that details all the Role Profiles, as well as th…Andrew Braid 118 views 4 comments 2 points Most recent by Aman Malik Reporting and Analytics for HCM -
Documents of Records data in ReportSummary Need to open DOR (Documents of Records) from BIP reportContent Hi All, We have a requirement to display DOR (Documents of Records) data in BIP report and need to… -
OTBI Report that shows the element details field "Description"Summary OTBI Report that shows the element details field "Description"Content I am trying to build a report where I can pull in the field 'Description' on an element. Fo… -
Query to display the Phases and States of the CSP in OBIContent Hi Experts, I am looking for a OBI query to display the Phases and States which are associated to the CSP. Regards, Harish Version 20DHarish Vummidi 75 views 4 comments 0 points Most recent by Harish Vummidi Reporting and Analytics for HCM -
Reporting mulitple Types of Managers in OTBI or BISummary Reporting mulitple Types of Managers in OTBI or BIContent Hello, We have three 'TYPES' of managers defined. I need to create a report for all employees showing a…User_2025-02-04-15-06-22-759 268 views 21 comments 0 points Most recent by User_2025-02-04-15-06-22-759 Reporting and Analytics for HCM -
Annualized Salary is not populating on a OTBI reportContent When running an OTBI report the Annualized Salary value is not populating. The user has AoR's and when they view the salary details via the HR forms the details …Rebecca L Smith 114 views 4 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Gauge chartSummary How to set maximum scale limit to a columnContent Hi I'm trying to build a simple gauge chart for infolet to show employee's accumulated learning hours. Each emp…Aslam Khuajah 19 views 4 comments 1 point Most recent by Aslam Khuajah Reporting and Analytics for HCM -
20D - Employee only see his own records when running reportsContent I'm sure this will be an easy fix for someone, but I have recently been tasked with setting up security access to allow a few of our employees to run reports/ana…Mike_McGrath 354 views 4 comments 1 point Most recent by Karen Waddell Reporting and Analytics for HCM -
OTBI report for BPM workflow task assigned through Project Status WorkflowSummary OTBI report for BPM workflow task assigned through Project Status Workflow?Content Hi, We have a Project Status workflow defined. Scenario ======= 1. Project Sta…
-
Issue with formula referring to another grid in same report in Narrative reportingContent There is a requirement in a report to refer values from one grid to another grid in the same report. The cell which has the formula to refer to another grid is n… -
Calculation on Pivot table resultsSummary Looking to perform calculation on pivot table results columnsContent Hi there, I'm looking to perform a calculation on a pivot table to insert a new column withi…Gary Miller-39965 36 views 9 comments 1 point Most recent by Gary Miller-39965 Reporting and Analytics for HCM -
Not all data in Data Model: Project Management - Project Resources Real TimeSummary OTBI report is only showing partial dataContent I have made a small OTBI analysis using 'Project Management - Project Resources Real Time' as the data model. I h… -
Talent Profile - Summary of RoleContent Hi all - I am trying to find the fields to create a report from our Talent Profile section. I am trying to find how to report on the area in Fusion going to Pers…Prudence K 93 views 13 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Can reports that are burst be generated in an Excel format instead of PDF?Summary I have a report created that needs to be burst by email monthly. Currently it is being sent in PDF format...any way to change the format of the report to a .csv?… -
custom calculation in calculating TurnoverSummary need help to put an custom calculation in Turnover calculationContent Hi Everyone, We have a requirement of customizing the delivered Turnover Dashboard with a c…User_2025-02-11-17-24-30-567 50 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM