Global HR
Discussion List
-
BI Report to achieve SANDWICH ABSENT DAYS CASES.Summary BI Report to achieve SANDWICH ABSENT DAYS CASES.Content BI Report to achieve SANDWICH ABSENT DAYS CASES. Please Kindly Help us to achieve these scenarios in BI R…Radhika Yalamanchili 26 views 2 comments 0 points Most recent by Radhika Yalamanchili Reporting and Analytics for HCM -
GenerateHead Error when writing Employee Changes ReportContent I have an employee changes report that runs fine until I try to add two additional fields to it (Cost Center and Manager Name). Now I'm getting a GenerateHead er…Lauren Owen 26 views 3 comments 0 points Most recent by Parthiban Vaithiyanathan Reporting and Analytics for HCM
-
OTBI Reporting of the new Onboarding FeaturesContent We are looking at alternative designs for OTBI support for the new Onboarding feature and we'd appreciate your input. The existing Workforce Management - Checkli…Julian Challenger-Oracle 137 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need BI SQL to fetch previous row assignment and salary details of employeesSummary I need to fetch previous row details based on latest row effective end dateContent In My BI Report, if i passed effective end date as a parameter , then employee…User_6U8NQ 261 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Assignment Name vs Job NameSummary Report comparing Assignment Name and Job Name to list differencesContent The Oracle bug where Assignment Name and Job Title (Name) are different causes our downs…User_2025-01-23-21-24-21-434 62 views 10 comments 0 points Most recent by Debo Reporting and Analytics for HCM -
Sub Folder for Requisition field in Workforce ModellingContent Hi Guys, I'm creating a proof of concept for the reporting that can be done out of the workforce modelling area and can't seem to locate the field 'Requisition'.…Ivy__Valverde 36 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Manager Self Service MetricsSummary Manager Self Service MetricsContent I would like a report that displays metrics on how often managers are initiating employee data changes in Oracle. Also, I wou… -
Can we report on Workflow TransactionsContent Hi All, I am trying to see if we can report on Workflow Transactions. I am able to query fa_fusion_soainfra.WFTASK table which seems to have workflow data in HCM…Vibha Pandey - Oracle 228 views 9 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM
-
BI Report to achieve SANDWICH ABSENT LEAVE CASES.Summary BI Report to achieve SANDWICH ABSENT LEAVE CASES.Content Please Kindly Help us to achieve these scenarios in BI Reports. Here below are the two scenarios, We are…Ravikanth Rao Thota 37 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Table to get the currency listContent I need to find a table to get the currency list maintain in manage currency task.' And I could not able to find in Tables and Views page. Appreciate your ideas.Ayesha Thilakarathna 50 views 3 comments 0 points Most recent by Ayesha Thilakarathna Reporting and Analytics for HCM -
BIP SQL Query for Previous Assignment Information, Updated Assignment Information, Previous Person ISummary BIP SQL Query for Previous Assignment Information Updated Assignment Information Previous Person Information Updated Person Information Previous Bank Information…User_2025-02-01-06-07-07-886 489 views 4 comments 0 points Most recent by User_2025-02-01-06-07-07-886 Reporting and Analytics for HCM
-
Determining # of direct reports at time of terminationSummary How can we determine how many direct reports someone had as of their term date?Content We have received a request to pull together a report of terminations over …Cheryl Burwell 33 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Error Password Protecting Excel Templates in BIPSummary Trying to password protect BIP reports that were built using the excel add in, but incorrect file type is showing up.Content Hi all, I'm having some issues with …User_2025-01-31-00-25-12-234 40 views 2 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
Is it possible to create OTBI analysis that should reports person numbers for alternate Managers andSummary We are trying to create an OTBI analysis that should reports person number for alternate Managers and Line managers both.Content Requirement- Need to create an O…User_F89L9 79 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Direct Report - OTBI Report CatalogContent Hello from Columbus, Ohio! Does anyone have a nice Direct Report with Managers and Direct Reports listed? I'm looking for an .xml catalog file that I can share i…User_2025-02-04-11-13-27-138 92 views 3 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM
-
Area of Expertise - Subject AreaContent Hi, I am trying to create Skills and Qualifications report from below subject area. --Workforce Profiles - Person Profile Real Time I wanted to add "Area of Expe…User_2025-01-30-00-14-06-021 114 views 5 comments 0 points Most recent by User_2025-01-30-00-14-06-021 Reporting and Analytics for HCM
-
Department Tree - Father and two Child Levels of a Department in inputContent Hello everyone, I'm trying to create a OTBI Report to extract Father and two Child Levels of a Department given in input. Extracting the Father of a Department i…User_2025-01-31-00-30-34-540 86 views 2 comments 0 points Most recent by User_2025-01-31-00-30-34-540 Reporting and Analytics for HCM
-
Reporting on Worker Comp Change Statement ActionSummary Comp Change Statements can be enabled in ESSContent We need to know when a worker accepted/declined/signed statements that are shared with them in ECC. Is there …Gala Meyerovich 57 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Need subject area for cost center and companySummary Need subject area for cost center and companyContent Hi, I assign cost center and company values at department level . Now I want subject area for extract detail…
-
Headcount by Business Unit and locationsSummary Headcount by Business Unit and locationsContent Hi Friends There are a couple of reports in which we get Headcount by Business Unit and locations. We have around…Mansur Khalil 60 views 2 comments 0 points Most recent by User_2025-02-04-06-31-44-785 Reporting and Analytics for HCM -
Reports Filtered by Action Approval/Completion Date?Content Hi All, Has anyone found a way to filter a term report or employee changes report by date the corresponding action was approved? For example; we send a term repo…
-
Workforce Management - Absence Real TimeSummary Issue with Absence DashboardContent Hi, I am trying to create a OTBI report based on Subject Area - Workforce Management - Absence Real Time. Currently we have a…Shail Parekh 242 views 14 comments 1 point Most recent by Rambo Jacob Reporting and Analytics for HCM -
OTBI Employee report - how to stop delegated employees appearing on it ?Summary OTBI Employee report - how to stop delegated employees appearing on it ?Content I have a OTBI manager report that managers can use to see their direct reports ho…Ruzwan Akram 47 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
SUCCESSION PLAN CANDIDATE READINESSSummary SUCCESSION PLAN CANDIDATE READINESS column detailsContent Hello Everyone, How to find current active record for the succession plan candidate readiness, as per o…VarunG 70 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Time to First PromotionContent Hi All, We're trying to measure time to first promotion (or the tenure an employee has on average before they're first promoted). Wondered if anyone has had luck…Lauren Owen 55 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Turnover Calculation in OTBISummary What is the formula for the out of the box turnover calculation in OTBI?Content What is the formula for the out of the box turnover calculation in OTBI? Thanks, …User_2025-02-05-04-33-50-822 114 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is there any subject area is available which shows the inprocess/complete/initiated resignation infoSummary Is there any subject area is available which shows the inprocess/complete/initiated resignation informationContent Is there any subject area is available which s…User_2025-02-05-01-04-36-989 26 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
HR can't see all HR Action valuesSummary We have analysis and HR can't see all HR Action values.Content Hi All, In our analysis we see who left the company, why and dates, actions etc. In HR Action we h…User_2025-02-04-18-26-11-309 41 views 2 comments 0 points Most recent by User_2025-02-04-18-26-11-309 Reporting and Analytics for HCM
-
Need Subject area to get the Person Identifier number for external applicationsSummary Need Subject area to get the Person Identifier number for external applicationsContent Hi Team, Does any one have an idea on which subject area to use for gettin…User_2025-02-04-07-00-18-658 139 views 2 comments 0 points Most recent by User_2025-02-04-07-00-18-658 Reporting and Analytics for HCM
-
Report for users with current rolesSummary Not able to pull all users for above reportContent Hello Folks - We have been using below report to satisfy one of our downstream system for periodic audits. Req…User_2025-01-25-04-02-13-126 49 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM