Global HR
Discussion List
-
BI Analytics - Which subject area contains Pension InformationContent Hi, I am trying to Analysis report and am looking to bring in Pension information held on the workers Assignment details, is this held in a specific Subject Area… -
County or District in OTBI AnalysisContent Can we get the County or District, which are additional attributes in Address, on an OTBI analysis.Vibha Pandey - Oracle 35 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Termination Report based off Entry DateSummary Business need to create a termination report based off of entry dateContent Hello, Has anyone created a Termination Report that looks off of the termination/acti…User_2025-01-31-00-25-12-234 98 views 9 comments 1 point Most recent by User_2025-01-28-20-36-10-715 Reporting and Analytics for HCM -
Need Local Information to DisplayContent I am looking for a way to generate a report for my local team in Asia that includes both the English (display name) and the local name in Chinese characters. I c…User_2025-01-28-18-57-50-126 59 views 18 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Employee Self Service: how do you show employees their salary history?Summary Employee Self Service: how do you show employees their salary history?Content Hi, Our team would like to display an employee's own salary history on the Personal…Matthew Grillo-95429 122 views 5 comments 1 point Most recent by Kalyan Amaravathi Reporting and Analytics for HCM
-
Reporting on inactive managersSummary Identifying employees with inactive managers.Content Can anybody share a report that shows employees along with the status of their line manager? Or tell me how …User_2025-01-28-05-34-59-339 62 views 5 comments 0 points Most recent by Debo Reporting and Analytics for HCM
-
Past terminations not appearing in reportsContent We added anyone who has left this year (prior to implementation) as basic records so we could report full year of leavers data and those basic records are not ap…Emily Robinson 47 views 4 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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 27 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 256 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 475 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 78 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 243 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