Global HR
Discussion List
-
Metrics for News and Announcements?Content Is there anywhere we can see metrics for how many times people have clicked on News and Announcement articles? Many Thanks AmandaAmanda Butterfield 30 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OBTI Formula for January 1st of Current YearContent I need to get the age of the worker for the start of the year in an OBTI analysis. I have Oracle's formula to calculate age: TimeStampDiff(SQL_TSI_YEAR, "Worker"…Greg Bennett 98 views 8 comments 0 points Most recent by Greg Bennett Reporting and Analytics for HCM -
Issues on Termination report with datesSummary Termination report not showing correct amountsContent Hi, I have created Termination report using "Workforce Management - Worker Assignment Event Real Time" subj…Niko Hölttä 28 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Column to be added with option 'Created by' which should give information of Employee Name - While cSummary Column to be added with option 'Created by' which should give information of Employee Name - While creation on new Analysis in reportsContent Hi, While creating …User_2025-01-24-00-17-22-300 35 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI report to show records ONLY if there was a change in a particular fieldSummary OTBI report to show records ONLY if there was a change in a particular fieldContent Hello, I need to pull a report on a weekly basis if any employee got their Ma…User_2025-02-04-15-06-22-759 322 views 8 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Selection Steps/Filters per table in one reportContent Hi all, I'm wondering if it's possible to put different filters or selection steps per table, but within one report. I'm making some headcount reports and want t…User_2025-01-31-00-25-12-234 23 views 2 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
HDL- Can we load the Assignment DFF Values in ArabicSummary HDL- Can we load the Assignment DFF Values in ArabicContent Dear Team, For Saudi Arabia Legislation, we need to capture Contract - profession details. For that I…JoeKen-Oracle 38 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Workforce Management - Workforce Trend Real Time pulling current employee typeContent Hello, I'm working on making a headcount report using the Workforce Trend Subject Area, but I've noticed the subject area is pulling the current employee type ra…User_2025-01-31-00-25-12-234 23 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Report to identify loops in the line manager hierarchyContent Hello, Does anyone have a report that they could share that identifies a loop in the line manager hierarchy i.e. an employee lower down in the hierarchy also man… -
Employees with salary changeContent Hi, I have dashboard report with number of new hires, terminated employees, promotions, position changes as attached in screenshot. Similarly I would like to hav…Mohammed Rafi 42 views 1 comment 4 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Point in Time - Home Address for EmployeesSummary Point in Time - Home Address for EmployeesContent Does anyone know if it is possible to create a report that returns employee's home address as of a specific dat…Kathleen Nguyen 26 views 8 comments 1 point Most recent by Kathleen Nguyen Reporting and Analytics for HCM
-
Misalignment of DatesContent Hi all - I have an issue I've not experienced before. I have an LSQL for a changes report I am working on, and I am pulling in the Last Update Date for the assig… -
Subject Areas in Union analysisSummary Only the primary subject area is visible in a Union analysisContent Hi, We're busy building reports ahead of a not-too-distant implementation of Cloud for HCM & …User_2025-02-08-05-56-00-229 46 views 7 comments 0 points Most recent by User_2025-02-08-05-56-00-229 Reporting and Analytics for HCM
-
How to Add Worker Details to Job Details in a single report in OTBIContent Hello, I am trying to add the following under Workforce Management-Worker Assignment Real Time subject area: Job-> Job Name, Job Code and Level Worker-> Name Whe…User_2025-02-10-12-13-36-181 20 views 4 comments 0 points Most recent by User_2025-02-10-12-13-36-181 Reporting and Analytics for HCM
-
End Dated Scheduled ProcessesSummary End Dated Scheduled ProcessesContent Hi Team, We have observed some of the scheduled process got stopped in our production environment. this might be due to end …nitin Sharma 32 views 4 comments 2 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Scheduling ReportContent Hi, The OTBI reports works fine when run manually filtering the conditions but when it is scheduled to run (which is created as agent) it picks up all records ig…Mohammed Rafi 36 views 5 comments 3 points Most recent by Rahul Bedia Reporting and Analytics for HCM
-
Report OTBI based on role and delegationContent Hi All, Do you know if is it possible to create an OTBI report that extracts all delegations done through the functionality role and delegation? I saw that these…Valeria Longoni 81 views 5 comments 0 points Most recent by Steve_Wright Reporting and Analytics for HCM -
Error while using FILTER/DESCRIPTOR_IDOF in formula with multiple subject areasSummary The logical column referenced by DESCRIPTOR_IDOF does not specify a Descriptor ID columnContent I'm trying to summarize Headcount based on Gender, Ethnicity and …
-
Remove DuplicatesSummary Remove DuplicatesContent How to remove duplicates from Excel template? Regards, ReddykrishnaReddykrishna Chidella-Oracle 53 views 3 comments 0 points Most recent by Karen Costakes Reporting and Analytics for HCM -
Error in OTBI Analysis Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65PContent Hi All, I have a OTBI analysis with Graph. When I move my cursor over the graph I see Hand means it's clickable. When i click I get following error, Can someone …User_2025-02-07-19-03-14-525 204 views 4 comments 0 points Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM
-
Custom Dashboard HeadcountContent Hi, I have created custom Dashboard and created 3 different Headcount Analysis for 3 BU head count. When I run my dashboard first time it shows correct count for…User_2025-02-07-19-03-14-525 57 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Changes Report - What are your practices?Content Currently we are modifying the changes report that we had using BIP and we stumble this difficulty How's your company show changes in the changes report? We have…Rick Jason 38 views 7 comments 2 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
Resignation Submitted dateContent Hi All, We had a predefined report which use to give Resignation Submission date along with the Employee last working date. Few days back the report stopped work…Kiran Kancherla 38 views 4 comments 0 points Most recent by Kiran Kancherla Reporting and Analytics for HCM
-
Analysis Total is Rounding to ThousandContent Hi Champions, I have created Headcount Analysis in my Custom Dashbaord ( Like Count(worker.person_number) to get exact number of employees working in a particula…User_2025-02-07-19-03-14-525 8 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Compound sort in OTBIContent Hi All, Is it possible to do Sort on 2 columns in OTBI? Ex. First Sort on BU and second sort on LE in same report. Thanks, VijayUser_2025-02-07-19-03-14-525 39 views 2 comments 1 point Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM
-
Removing Nulls from Limited Dashboard PromptsSummary Limiting dashboard prompt by other values while removing the null optionContent Hello, I've created a dashboard prompt where we're trying to limit the values of …Rob F 37 views 3 comments 0 points Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM -
Dashboard runs a report that opens a new window when it shouldn'tSummary As the title says, we have a Dashboard that runs a BIP Report and the run process pops the information into a new window. We aren't looking for this functionalit… -
Report AuditSummary Report showing when a report was last ran and by whoContent Hi All, I thought I saw this on a webinar, but I don't really recall. Is there a report in OTBI that …
-
Multiple IF ELSE Conditions in BIP Excel TemplateSummary Multiple IF ELSE Conditions in BIP Excel TemplateContent Hi Experts, How to use multiple IF else condition BIP Excel Template. Example: IF Legislation_Code IN ('…Bala Kasineedi 81 views 1 comment 1 point Most recent by Raghavendra M Reporting and Analytics for HCM
-
Backend table name for error transactionsSummary Backend table name for error transactions generated from transaction ConsoleContent Hello Everyone, I'm trying to create a report to show data from the Transacti…