Global HR
Discussion List
-
OTBI > Ability to get the work schedule assigned to Employee in reportContent Hello All, I will appreciate your support in the following issue: Do you have an idea if possible to get the work schedule assigned to employee in OTBI or via SQ… -
Table to pull the Highest Education Level in BIPSummary: Need to determine the table that retrieves the Highest Education Level under Person details Content (required): Version (include the version you are using, if a…RenzelkeithCoquia 779 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Report on Alerts Composer Notification ReportingSummary: I'm looking to see if there are any OTBI subject areas that can be used to report on the various event notifications that are sent out using the Alert Composer …Rohan Fernandes 31 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Work Schedules for non-primary assignments in Person Real Time Subject AreaSummary: I'm trying to report on the work schedules for employees with multiple assignments. However the OTBI Person Real Time Subject Area / Person Schedule Assignment …Richard Kemp-Eyre 64 views 2 comments 0 points Most recent by Richard Kemp-Eyre Reporting and Analytics for HCM -
Oracle Standard Reports - Who to ContactContent Hi all - who do we contact about making an adjustment on the Oracle delivered standard reports? Our team was looking at the Line Manager Dashboard (Shared Folder…Prudence K 88 views 11 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Getting error when person extra info flexfield is pulled in OTBI reportSummary: Getting error when person extra info flexfield is pulled in OTBI report Content (required): I am getting following error when I dragged and dropped one of the p…Swati U 21 views 2 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
How to create custom deeplink in oracle cloud hcm ?Summary: Content (required): Hello Dears , We are looking for custom deeplinks and we need to know if that applicable to create or not ? Thank You. Version (include the …Nariman Moussa 82 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI challenges rendering null valuesSummary: OTBI challenges rendering null values. Content (required): Hi experts, We experiencing challenges to come up with a solution to correctly show the data in the O…Volodymyr Faranosov 111 views 4 comments 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM -
Need subject area to get the manager name of inactive employeesSummary: Need subject area to get the manager name of inactive employees Content (required): Hi, I need subject area to get the manager name of inactive employees. For e…
-
Where to check if employee received a pager unit and their on-call premium?Summary: I'm trying to look where in HCM this information can be visible: Employee received a pager unit and their on-call premium. Thanks!notautomni9 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
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 538 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 628 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 213 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