Reports
Discussion List
-
Can I use text in IFTHEN function?Content I am trying to apply following formula in oracle but it does not work. it seems that we can't use text (or anything in quotation mark) as an argument in IfThen f…User_2025-02-10-15-49-56-251 48 views 4 comments 0 points Most recent by Dave Roberts_-Oracle Narrative Reporting -
Identify retro changes on absence entriesSummary Identify retro changes on absence entriesContent How do we identify retro changes on absence entries? For example. employee A applies for leave from 10/1/2020 to…Sowdha Murugan 39 views 3 comments 1 point Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Date Prompts with Italian InterfaceSummary Invalid Date format when using a date prompt in ItalianContent Hello! I've recently encountered a new problem and I'm hopeful that someone out there has figured …Rob F 27 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting and Analytics for HCM -
Pivot Table helpSummary Trying to split two values in pivot tableContent Hi, I am trying to get my pivot table to show the sum of all National & International contracts by Business Unit…User_2025-02-05-22-44-35-842 37 views 3 comments 1 point Most recent by Ellen Manthei Reporting and Analytics for HCM
-
Editing Delivered DashboardSummary Trying to edit the delivered Line Manger Dashboard but received error on saveContent Hi, I am trying to edit the delivered Line Manager Dashboard, I want to upda… -
When creating a dashboard how to you not show the refresh optionContent I am creating a dashboard and depending on the prompt values some of my reports that are in the dashboard sections don't have any information to display. I have …Mario B 25 views 6 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Prompted Bar Graphs for custom fields with case statementsSummary Prompted Bar Graphs for custom fields with case statementsContent We have a bar graph with a couple of custom fields derived using case statements. The fields on…User_2025-02-10-08-27-16-805 25 views 6 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Creating new Employee report with Expense Account InformationSummary What is the field and record to pull in the Employee Expense Account InformationContent We are building a new employee report and have a requirement to add the '…Jennifer Wolfe 41 views 4 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP -
How to fetch the Locked accounts of active employees in security consoleContent At present in the system, there is no table to fetch the active accounts which are all locked in security console. Kindly let me know is there is any table or qu… -
Data level security on OTBI reportSummary Can we apply data level security on OTBI reportContent Hello Everyone, Can we able to apply a data level security on OTBI report such as applying logic on data e…VarunG 59 views 5 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BIP Report running for everSummary Existing BIP report is running for ever with recent upgradeContent Hello Everyone, We have report which was running fine without any issues for 5 hours now with …
-
Calculation Help ReportContent Name Weight Numeric Rating * Weight / 100 Competencies 15. 0.45 17. 0.51 Goals 20. 0.6 25. 0.75 30. 0.9 I have a report that spits out like this. The last column…Mike Borghoff 38 views 4 comments 0 points Most recent by Mike Borghoff Reporting and Analytics for HCM
-
Limitations of OTBI reportsContent Can someone please share the limitations on OTBI reporting compared to BI reporting. I'll inputs regarding the performance, number of records/columns that can be…User_2025-02-08-08-48-00-058 626 views 5 comments 0 points Most recent by User_2025-02-08-08-48-00-058 Reporting and Analytics for ERP
-
Table name and column for Cost ExpenditureTypeSummary Table name and column for Cost ExpenditureTypeContent Dear Champs, I am looking to find the amount of each expenditure type I wanted to check if ACCT_BURDENED_CO…
-
RTF Template : Hide Row based on SUM() after complex RegroupingSummary Has anyone tried to Hide a row after regrouping the data and the conditions should be based on the SUM() of a column obtained after groupingContent The XML data …Balachander G-Oracle 57 views 1 comment 0 points Most recent by Amrit Reporting and Analytics for ERP
-
Ability to enable Percentage of total on a line graphSummary Ability to enable Percentage of total on a line graphContent I am building a line graph and would like to set the data markers as a % of the total value instead …User_2025-02-10-08-27-16-805 14 views 9 comments 0 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM
-
Not-for-Profit Statement of ActivitiesSummary Seeking sample Statement of ActivitiesContent Statement of Activities quantifying revenue and expenses of our not-for-profit entity for a reporting period. The n…User_2025-02-11-03-09-13-126 22 views 0 comments 1 point Most recent by User_2025-02-11-03-09-13-126 Reporting and Analytics for ERP
-
Normal "Planner" Users seems to have Power User rightsContent Hi all, It seems that all normal "Planner" users are able to see all reports in EPBCS, when they navigate to explore repository they don't have access to the sam…
-
Termination Report using Workforce Management - Work Relationship Real TimeSummary Termination Report using Workforce Management - Work Relationship Real TimeContent Hello - we have been using the archived report attached for a while now, but i…Shanna Oppenheim 59 views 17 comments 0 points Most recent by Rahul.Yarlagadda-Oracle Reporting and Analytics for HCM -
Line Manager Dashboard - HeadcountSummary Female ManagersContent Hi All, Looking to Female Managers metric I can see the following logic: IFNULL(((FILTER(FILTER("Worker Assignment"."Head Count" USING (DE…Alvaro Couto 58 views 9 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
20D Known issue with OSHA Reporting?Summary 20D Known issue with OSHA Reporting?Content Is there a known issue with the "Environment Health and Safety - Incidents Real Time" Subject Area? Adding these colu…Andrew_Schmitz 33 views 5 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
Missing Photo AuditSummary Is there a field tied to the Photo for an employee in HCM?Content Does anyone know if there is a field to pull into a BI Analysis that would tell me if someone d…User_2025-01-28-20-43-56-568 91 views 10 comments 3 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM
-
Number of Subordinates ReportSummary To show how many subordinates the person hasContent Hi All, I'm not sure if anyone is able to but I have been trying to figure a way to count how many subordinat…Eric.C 47 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How can I report on top 5 reasons for short term sicknessSummary Want to adapt the seeded report to show absence reasons for duration limitContent Hi How can I show the top 5 reasons for an absence of less than 28 days duratio…LynneLBL 21 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Line Manager Dashboard - HeadcountSummary Part Time logicContent Hi All, I've created a custom version of the Line Manager Dashboard in order to fix a few metrics. One of them is the Part Time metric ava…Alvaro Couto 56 views 2 comments 0 points Most recent by Alvaro Couto Reporting and Analytics for HCM
-
OTBI GL Subject Area : 'General Ledger - Journal Real Time'Summary OTBI GL Subject Area : 'General Ledger - Journal Real Time'Content We are developing Analysis reports relating to Cloud General Ledger in Oracle Transaction Busi…Swaroop Mitta 162 views 2 comments 1 point Most recent by Renuka Nuguru-Oracle Reporting and Analytics for ERP