Reports
Discussion List
-
Skills and Certifcation Report but issue is will get one Extra Empty rowSummary: Hi Team, We have Skills and Certifcation Report but issue is will get one Extra Empty row how can we overcome the thta row. Thanks, Ajay https://us.v-cdn.net/60…AjayKumar Maddipati 21 views 6 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
PVO hcm extracts what types should be used and how ?Hello , We would like to use PVO extracts of Oracle of HCM type. Purpose -to get the worker (employee) details including their current manager, location, assignments, et…Revital Mefano 21 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Need help on combining these two analysisSummary: Hi, I have to create an OTBI report(attached screenshot) where I have to show voluntary termination/active HC and total termination (vol+invol)/active HC in one…Shreya Datir 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Sql to get period end active head countSummary: Hi Does anyone have sql to get active head count at the end of each month/quarter? Thanks in advance. Content (please ensure you mask any confidential informati…
-
How to put formula with text data in Management reporting?How to put formula with text data in Management reporting? The Formula is: [IF(E9="PRE",I9*6,I9*6*85%)] [E9 & I9 are cell values and "PRE" is Text data to be picked by t…
-
How can I pull Job Families and Jobs, including Job Families not linked to Jobs?Summary: How to display "blank values"? Content (please ensure you mask any confidential information): From the Worker Assignment Real Time subject area, I can pull the …Arnaud Bory 64 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Multiple conditions are not working while defining Conditional suppressionHi, I am trying to define multiple conditions in the conditional suppression but it seems only 1st condition is working , others are not working. Is there any error in d…JyotiSharma 12 views 2 comments 0 points Most recent by JyotiSharma Financial Consolidation and Close
-
Custom Font on OTBI Dashboard?Is it possible to use a custom font with OTBI Dashboards/Analyses? We would like to develop a "theme" for our Dashboards and use our company's font. The only information…
-
Payroll Flow Pattern ReportSummary: Payroll Flow Pattern Report Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there a way to find out the programs which are…Parag Hiremath 52 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Trying to create a BI report to fetch out the payroll element entry data for employee.Here the data is flowing from ORC to Individual Compensation.When the employee is hired he will be awarded with some "BONUS" with some additional fields these data's wil…Jebarsan Thangam John Durai Raj 101 views 10 comments 1 point Most recent by Shanna Oppenheim Reporting and Analytics for HCM
-
Location for EPM/FCCS SOC reportsSummary: Our auditors are asking for copies of the SOC 1 and 2 reports for EPM. However we cannot see specific EPM specific ones in the Compliance folder via IDCS even t…Jeremy Stubbs 201 views 1 comment 0 points Most recent by Komala Reddy-Oracle Financial Consolidation and Close -
Need SQL to extract the amount and periodicity of worker element entriesSummary: Hi Experts, Could you please provide SQL code that extracts the amount and periodicity of worker element entries? I need help with this requirement. Written thi…Hiba Ghoualmia 133 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
OTBI > Permissions > HR Specialist cannot open DashboardContent Hello All, I will appreciate your support on the issue below: The HR Specialist with Data Role “AUIB Human Resource Specialist” cannot open the Dashboard (File “…
-
Creating a report from BI Workflow Correction Notification in HCMSummary: A client is looking to create a report of all of the correction notifications they receive in order to better analyze the data. Is this possible? Ex. Correction…
-
How do I Round Down my TIMESTAMPDIFF formulaSummary: I have a TIMESTAMPDIFF formula to calculate the number of years but it rounds it up in OTBI, and I need it to round down to show completed years. Content (pleas…
-
Need example for Bursting Query in case of Multiple data setsContent Hi, Can anyone explain how to write Bursting query in case of Multiple Data Sets? Thanks in advance. JyotiUser_2025-02-06-14-37-05-233 296 views 11 comments 0 points Most recent by Darshan K N Reporting and Analytics for HCM -
Need help configuring BPM Workflow Task for Issue NotificationsSummary: I have tried to customize the Issue Notifications Catalog workflow template for the Create Issues task under Project Management, but it is not reflecting my new…
-
Need help on the Attrition % formulaSummary: I am trying to create an analysis where I have to show Attrition % for month which can be calculated as (No. of vol terms in that month / Active headcount in th…Shreya Datir 62 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report for PC log in vs Mobile log in on browser vs Mobile log in on the appHi there, Is there a report, or which tables could we use to build a report, that identifies whether a user log in to HCM is from a PC or mobile. We found "Device_Type" …
-
Table name for pending workerSummary Table name where pending worker details are storedContent Hi Oracle experts, I have created a Pending worker from Taleo to Fusion using the delivered integration…
-
Need a query that combines both termination transaction details with the employee details.Hi I need to create a custom query that combines both the transaction console details for terminations with the employee details (i.e. job name, department and pay) for … -
Issue getting most recent/max date for "Offer Extended" Recruiting EventSummary I have an ORC report where I need to return only the most recent/latest date for a specific recruiting event (offer extended) but I am getting multiple rows retu…User_2025-02-04-23-22-13-274 113 views 9 comments 0 points Most recent by Maryellen_Gancena Reporting and Analytics for HCM
-
Report with Multiple Prompts or Current POVSummary: I want the user to be able to select their POV for more than one dimension. Content (please ensure you mask any confidential information): I'm trying to create … -
The limit of 6000000 rows in the report is before suppression or after?I am using the descendants function for two dimension combinations in rows which creates a lot of rows and the number goes above 6000000. But most of the rows at these c…
-
Sickness Absence - Working Days LostSummary: Hi Is there any way to calculate Working Days Lost in OTBI for sickness absence? We are using the Absence Real Time subject area and have Calendar Days Lost cal…stusc 51 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Timecard Layout ReportTeam, We have a requirement to build many timecard reports and would like to understand the table structure to develop the same. We are using hwm_tm_rpt_entry_v view to …