Global HR
Discussion List
-
Ability to report on modified approved future-dated absence entriesSummary: Content (required): Hi - is there a way to report on absences that have been modified by employees ? Example: On 11-Aug-2022, an employee applies for a 2 day ab… -
Manage Seniority Dates subject areaSummary Need to know the subject area for reporting the dates in the Manage Seniority Dates action menuContent I'm looking for the subject area that can be used to repor…User_2025-01-29-22-47-27-383 136 views 18 comments 0 points Most recent by Dannielle Dellucci Reporting and Analytics for HCM -
Seniority Dates V3Summary OTBI Subject Areas to Report on Seniority Dates V3Content Does anyone know if the Seniority Dates V3 are available in any OTBI Subject Area? We need to be able t…Lindsay Lamont 265 views 28 comments 0 points Most recent by Dannielle Dellucci Reporting and Analytics for HCM -
Usage of BI System RoleSummary: Usage of BI System Role Content (required): Hi Team, We would like to know the usage of BI System Role. Please share your knowledge on the same. Version (includ…Vasanthakumar Ravi 21 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
How to query the organizations in the Organization List of an Organization Security Profile?Summary: How to query the organizations in the Organization List of an Organization Security Profile? Content (required): The Organization List section of the Organizati…User_2025-01-25-06-00-22-809 531 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
How to query if a pending worker to EMP was converted with manual or auto conversion?Summary: Is there a query to determine how a pending worker was converted to EMP (ex: "include in auto conversion" or "quick convert")? Content (required): Is there a qu…Jessica DiCerbo 601 views 2 comments 0 points Most recent by Jessica DiCerbo Reporting and Analytics for HCM -
Is it expected that the previous salary in Salary History will be deleted after Mass Salary Update?Summary: After mass updating the salary, the previous salary in salary history was deleted. Is it the expected behavior or it should have retain the previous salary and …
-
Report on Temporary Global TransferHello Is it possible to report on the field 'When do you expect the new work relationship to end?' available on Temporary Global Transfer through OTBI?
-
Need to bulid a report for pending transaction.Summary It should have the following details: who has initiated and to whom it is in pending with. Can any one of you please share the catalog.User_2025-02-07-09-10-02-492 73 views 11 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM
-
New user account password reset statusSummary: Is there a way to fetch the new user account details if the password was reset successfully or not? Content (required): As part of Onboarding process, user acco…
-
Calculate time between interactions ORCSummary: Hello - we are trying to report on the time between interactions in ORC. We can pull in the creation dates for each interaction, but we are unsure how to calcul…Shanna Oppenheim 31 views 5 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
Data is not populated in HWR_WLNS_POINTS_REPORT tableSummary: Data is not populated in HWR_WLNS_POINTS_REPORT table Content (required): We have configured the Wellness activities and tasks and, employees have completed the…Jhansi K 31 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Where we can find predefined template for cloud hcm notifications ?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):priyankatriv 21 views 16 comments 0 points Most recent by Karla Dixon-Proactive Support SPA-Oracle Reporting and Analytics for HCM
-
Where is 'Elective Disbursement' details of Absence Plans stored?In the details of absence plans, which tables/lookups can I find values of this field? This is what it looks like in front-end: Thanks! -
Checklist Real Time not returning Pending Worker ChecklistsContent We are using Checklists for our Onboarding process, and these checklists and associated tasks are being assigned to Pending Workers automatically prior to their …User_2025-02-06-09-45-30-140 124 views 31 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
DD-MON-YYYY format is not workingSummary: We have a requirement to display the date format as "DD-MON-YYYY'. Ex. 14-FEB-2025. We are using RTF Template. In the query I am not doing any kind of formattin…
-
How to calculate Turnover percentage between count attributes in OTBI ?Summary: How to calculate Turnover percentage between two count attributes in OTBI ? Content (required): We are working on an OTBI report where we have to create a summa…
-
When we apply filter below for particular process not working on pending transactions reportSummary: Hi Team, we have developed pending transactions report in that all process are coming like change manger,'Resignation', location, and etc but we need only Resig…AjayKumar Maddipati 31 views 2 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
What tables store the representatives that are assigned to each employee?Summary: I have been tasked with creating either an OTBI analysis or BI Publisher report to pull all employees and the representatives that have been assigned/linked to …BeachDreamer 203 views 6 comments 0 points Most recent by User_2025-02-11-05-19-35-410 Reporting and Analytics for HCM -
Cross SA Employee Census results in errorSummary: In building out an analysis that gives me one row per active employee, I've run into this error: Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8…Kate V 21 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Table for Public Info (Me-> Directory-> My Public Info)Summary: We need to fetch the representatives information for an employee. I have tried with PER_ASG_RESPONSIBILITIES but unable to find the information. Please guide me…
-
in my below only getting for india data and one processSummary: Hi sir, for above query with out put country parameter or process name parameter only geting india and regination process ? when i scedule the report but i seei…AjayKumar Maddipati 1 view 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Report integration on a pageDear all I integrated a dashboard on a custom page. There are two open points fr which I can't find an answer at the moment: 1. The report is not fully shown. There is a…Annelies Van Erom 11 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
What is the Table that stores Oraganization EFF details.Summary: What is the Table that stores Oraganization EFF details. Content (required): What is the Table that stores Oraganization EFF details. Version (include the versi…User_2025-02-12-17-19-33-738 11 views 2 comments 0 points Most recent by User_2025-02-12-17-19-33-738 Reporting and Analytics for HCM
-
candidate profile hdl error?Summary: get a solution for hdl candidate profile data? Content (required): Hi all, while loading candidate profile hdl getting error as "File line couldn't be saved to …
-
Hiding Output TAB in Schedule Page of ReportSummary: Hiding Output TAB in Schedule Page of Report Content (required): Can we hide via Personalization or Role Duties and Privileges restriction hide the Output TAB i…C.R.Balaji 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need to schedule a BI Publisher report to run on interval of 15 daysSummary: Need to schedule a BI Publisher report to run on interval of 15 days. Content (required): Version (include the version you are using, if applicable): Code Snipp…Abhimanyu Kumar27 21 views 2 comments 0 points Most recent by Abhimanyu Kumar27 Reporting and Analytics for HCM
-
Include/Exclude column based on the ParameterSummary: We have requirement to Include/Exclude the column based on the parameter Content (required): We have a requirement to hide a column in the report output based o…Vasanthakumar Ravi 111 views 0 comments 0 points Started by Vasanthakumar Ravi Reporting and Analytics for HCM
-
Need to get the latest Salary fromSummary: I need to get the latest salary for all employees who have left. Content (required): I am using the Compensation - Salary History Details Real Time subject area…GJ79 31 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Age calculation on As-Of-DateSummary We need to build a report which shows the age of Worker on As-Of-DateContent We need to build a report with As-Of-Date variable so that it would also calculate t…Niko Hölttä 143 views 7 comments 5 points Most recent by Rahamathulla Rawther-274263 Reporting and Analytics for HCM