Reports
Discussion List
-
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 20DHarishVummidi 70 views 4 comments 0 points Most recent by HarishVummidi 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 112 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…User_VYO5Y 350 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 35 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…
-
Effective date for OTL Absences issueSummary Although an effective date is set via presentation variable values are counted by a different dateContent Hi everybody, I'm struggling with the following report …User_2025-01-31-17-16-46-301 86 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
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
-
Workforce Management - Documents of Record Real Time shows no dataSummary Even after having Human Resource Analyst and Line Manager roles, unable to view data in the Subject area
-
"Planner" Users unable to open new reportsContent Hi all, We are testing the new report functionalities, however it seems that Planner Users are not able to open the new report section: They get the following er…
-
Multi-selection parameter is not working for more than 1000 LOVsContent Hi All, I am using position name as parameter in my BI report. Syntax for using multi-selection parameter is- POS.NAME IN (:P_POSITION) OR 'All' IN (:P_POSITION …User_2025-02-06-14-37-05-233 78 views 8 comments 1 point Most recent by MaartenDIF Reporting and Analytics for HCM
-
Can we convert numbers into words in the Narrative Reporting?Summary We want to convert numbers into the words.Content Hello, We want to convert the numbers into the words e.g. If the Net Profit is 50000 then we want this amount i…
-
Issue with Posting Journals by Power UsersSummary Issue with Posting Journals by Power UsersContent Hi Friends- Just came across an issue - During monthly close, we have observed that power users are not able to…Amit Agarwal-158816 85 views 24 comments 1 point Most recent by User_2025-02-06-08-00-18-726 Financial Consolidation and Close -
Member Alias - Formatting IssuesContent We have cashflow report and data source is FCCS. We have created a report which is something like this: CY PY CF Profit/(Loss) for the Year CF Finance Cost Relat… -
Manager Department HierarchyContent I have been able to create a top down hierarchy in my report using Person Manager and CASE/WHEN statements however, I am now being asked to bring in the departme…
-
Gross Wage Report YTDSummary Detail Gross Wage Report YTDContent I am looking for a way or if there is already a predefined report for Gross Wages YTD broken down by each employee for exampl…Mike Householder 67 views 1 comment 1 point Most recent by Lisa Ridgely-Oracle Reporting and Analytics for HCM -
Date Parameter in BI Publisher ReportSummary Date Parameter in BI Publisher ReportContent Hi All Date Parameter in BI Publisher Report showing one day off in output, Tried setting of user time zone under My… -
OTBI Training, Documentation, FAQs and moreContent We have published knowledge article 2023155.1 which contains training, documentation, answers to commonly questions and frequently asked questions. You can find …Julian Challenger-Oracle 226 views 7 comments 6 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Analysis rearranging Column Order different in CVS and EXCELSummary OTBI Analysis Column Order different in CVS and EXCELContent Hello, When I create a report, the column order that shows in the 'Results' tab and also in Excel - …User_2025-02-04-15-06-22-759 372 views 5 comments 0 points Most recent by Elisa Ortiz Rincon Reporting and Analytics for HCM
-
Manager Flag - all employees returning no valuesSummary Manager Flag - all employees returning no valuesContent Workforce Manager - Worker Assignment Real Time > Worker Assignment Details > Manager Flag I was expectin…
-
BI Publisher Report filter with multiple criteriaSummary Needing to add multiple criteria to an OTBI report filter e.g. multiple business unitsContent When adding a filter to a report created in OTBI I need to add mult…Chris Ross-Smith 117 views 6 comments 0 points Most recent by Prudence K Reporting and Analytics for HCM
-
Union Field in Employee screenSummary Union Field in Employee screenContent Hello All , Can you please let us know where we can find "UNION" in which Oracle table. NAvigation is :- My Client Groups >…Lucky Sharma 39 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Project Invoice DistributionSummary Project Invoice DistributionContent Hello All, I want to know from which table we can get below information:-Lucky Sharma 61 views 3 comments 1 point Most recent by Nishanth B Jain Reporting and Analytics for ERP