Global HR
Discussion List
-
OTBI Report with manager details and Counts of Direct and Indirect ReporteesSummary: OTBI Report with manager details and Counts of Direct and Indirect Reportees Content (please ensure you mask any confidential information): We are able to get c…MadhuLekkala 61 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Number of Direct Reports that are ManagersSummary Need to generate a report that shows, for a manager, which one of their direct reports is also a manager.Content * There is a requirement to get, for a manager, …Bradley Gray 58 views 23 comments 1 point Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Ability to report on auto provisioning rules?Summary: Is there a way to report on all the auto provision rules we have set up within the Manage HCM Role Provisioning Rules task? Or some way to report on all securit…Karlie Backman 131 views 2 comments 0 points Most recent by Satyabrata Nanda Reporting and Analytics for HCM -
AbcdAbcdShyam Rajbhar 31 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
AOR Areas of Responsibilities in OTBIContent Hi All, Can someone help, which Subject area I can find Assigned Areas of Responsibility details in OTBI? Thanks, VijayUser_2025-02-07-19-03-14-525 1.2K views 11 comments 0 points Most recent by Natalie A. Reporting and Analytics for HCM -
Permission - BI ReportSummary: We need an audit report with information about which user made the changes to the report's permissions in analytics.Mayara Fulquim 21 views 1 comment 2 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Need query to get who submitted resignation in last 24hourswe have a requirement to get the report of employees who submitted resignation. Can anyone share me the query to get employees data or atleast how can we get data of emp…Dara Nagasai 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to fetch PREVIOUS Grade and Grade Step using BIP?I need to pull the latest previous Grade/Grade Step in a single row because we don't need to back track all the changes on their Grade/Grade Step. How to construct the B…
-
HCM Infolet Tab unavailableSummary The HCM Infolet tab is missing from the pageContent Hi, I am having trouble in adding an infolet to the HCM infolet tab. The Service Infolet tab is present but I…Ian Rumble 206 views 14 comments 0 points Most recent by SUBHRASISH KANTHA Reporting and Analytics for HCM -
How to report on Owner Person Email in Workforce Management - Checklist Real Time subject areaSummary: Content (please ensure you mask any confidential information): We are building an OTBI report to display Journey tasks metrics using the Workforce Management - …Giuseppe Cannova 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Created new Measure with conditions incorrect result, Workforce Management - Workforce Assignment RTSummary: Hello all, I have created a new measure - Count of Female Managers - FILTER("Worker Assignment"."Assignment Count" USING ((DESCRIPTOR_IDOF("Workforce Management…Ian.Gooderham 11 views 2 comments 0 points Most recent by Ian.Gooderham Reporting and Analytics for HCM
-
Ability to Hide Future Hire Recored for Line Manager viewSummary: Future hire records who all are considered as sensitive hires are needs to be hidden fro Line Manager's view before theire DOJ Content (please ensure you mask a…Maran Aswin 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Person address data not displaying for user - BI reportSummary: I created one BI report and it has SSN and person details including address. When I ran the report, it shows all the details. When user ran it, the address fiel…Peoplesoft 31 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
What is the DBI for getting the latest payroll frequency start dateSummary: What is the DBI for getting the latest payroll frequency start date Content (required): Hi Team, Greetings! What is the DBI for getting the latest payroll frequ… -
Conditional Formatting in OTBI AnaylsisSummary Conditional Formatting in OTBI AnaylsisContent Hello, I am using conditional formatting to show when a field is NULL by changing the color of the field box. I ha…Shanna Oppenheim 58 views 7 comments 0 points Most recent by Ivony Ann Paula Salango Reporting and Analytics for HCM -
OTBI Questionnaire text column how to set the questions inproper to order ?Summary: Hi Team, We were developed new report by using Check list real time subject area to get onbaording Questionnaire text of employees but issue questions are inpro…AjayKumar Maddipati 31 views 12 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Request to provide the PVO and VO attribute name corresponding to the Fusion Table and ColumnHi Team, I need the column "Newly Separated Veteran Discharge Date" from to OTBI to FAW. I am trying to achieve it by Data Augmentation route by extending dimension. The…
-
How to sort the Questions in order using OTBI report?Summary: I'm currently creating an OTBI report under this Subject Area: Workforce Management - Checklist Real Time I want to display the Questions under the Questionnair…Welsey 71 views 6 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
3rd Substring from a Field in OTBISummary: Need 3rd Substring from "Job"."Job Name" Content (please ensure you mask any confidential information): I have "Job"."Job Name" field and the data looks like "U…Pradnya_Pampatwar 1 view 2 comments 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM
-
Report to show Employees serving Probation PeriodSELECT Command for extracting Employees that are serving probation period.
-
Need 2 Date Fields having Case or Filter functionality in OTBI ReportSummary: Interim Review Date ("Performance Document"."Performance Document Period Name" like '%Interim%') and Final Review Date ("Performance Document"."Performance Docu…Pradnya_Pampatwar 41 views 9 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
BIP report or data model for fetching the data of all the employees with their Hire date, terminatioSummary Can anyone help me with BIP report or data model for fetching the data of all the employees with their Hire date, termination date, rehire date along with depart…User_2025-01-29-01-34-30-592 192 views 2 comments 0 points Most recent by Becki Willard Reporting and Analytics for HCM
-
How to Create Custom User Entity for HCM ExtractNeed to create Custom User Entity for Custom HCM Extract, please provide your inputs on how to create custom UE.
-
Pull birthdays in the next 90 days in OTBI.Summary: Hello all, How to pull birthdays in the next 90 days in OTBI. The logic I currently use is to pull birthdays that fall between WEEK OF YEAR ( CURRENT_DATE) and …
-
How to calculate Age with Person Date of Birth and Effective Date variableSummary: Calculating Age using Person Date of Birth and the Effective Date variable based on a date entered in the prompt. Content (required): I need to calculate Age us…GJ79 642 views 7 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Remove Year from Date in OTBI ReportSummary: I need to set up a scheduled report to go out and not reflect the year of the birth dates. I know how to change the format in the Column Format, but once the re…Jessica D 81 views 6 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
how to read webcenter files using python script and extract informationcan we read the files which we uploaded through bi reports bursting into webcenter servers. while i'm the downloading the files in the webcenters they are not readable.Dara Nagasai 11 views 3 comments 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM
-
How to customize change personal information workflow notification?Summary: How to customize change personal information workflow notification? Content (required): Hi All, Need to customize the change personal information WF notificatio…
-
is there a way to get data from tables?Apologies for the basic question but is there a way to get data from the Geog Trees, calendar events, work patterns and work schedules please? This is from the backgroun… -
Error on Submitting ExtractSummary: I created a Extract and when i submit it, it throws below error. Please find the screen shot. How to solve this? Content (please ensure you mask any confidentia…