Category 81
Discussion List
-
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 24 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 529 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
OTBI Reports on agents and delivery recipientsSummary: Hi, any reports that can give you the report agents, including the schedule and the list of the recipients (by username or email address)? Thank you! Jenia Cont… -
No option to output format in excel 2007+ .xlsxSummary: Hello! From my online research online (I'm not an MS history expert) - "XLS and XLSX extensions represent popular Excel file formats that were introduced by Mic…Kevin M Storrie 42 views 5 comments 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM -
Looking for a sql query to get the absence plan and corresponding element name associatedSummary: Hi, We have a requirement to get the data of the Absence Plan and corresponding element data using the sql. If anyone has come across such requirement then plea…Peeyush Chandel 3.6K views 1 comment 0 points Most recent by Nagaraju Godasi Reporting and Analytics for HCM -
Issue: Unable to find Donation related Entry reason in Absence tableSummary: Unable to find Donation related Entry reason in Absence table Content (required): We can see the Additional Information stored in Adjustement_Reason but when it… -
Provide access to OTBI report by Area of Responsibility by BUSummary: Content (required): We have a requirement that the user will have only Employee and/or Line Manager Role and they should be able to fetch the employee records i…Vinay Gharge 254 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Sql Query to Fetch the Last Modification Date and Last Modified By Details of SSOSummary: Can any one please help with a sql query to get the last modification date, last modified by, Created by details for SSO configuration. Content (required): Vers…MilanMohanty 271 views 2 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
Email Address for Implementation Users in FusionSummary: Team, I would like to know the table in which the email address of the implementation users are stored. As they are not tagged to employee record, we will not b…Sumedh Kumar-Oracle 32 views 1 comment 0 points Most recent by Sumedh Kumar-Oracle Reporting and Analytics for HCM
-
Seeded HCM Extract for payrollHello, Is there a seeded HCM Extract to get total payroll balances per location/department? Thanks in advance!
-
Embed bursting report content in body of email?Summary: Embed bursting report content in body of email? Content (required): Hi all, Hoping someone can advise if it is possible to embed report content within the body …Luke.Findex 53 views 3 comments 0 points Most recent by Aaron Hager Associated Bank 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 588 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 …
-
Turnover- Last 3 monthsSummary: Content (required): trying to add a filter for the last three months but nothing is pulling - I tried several sql expressions and repository variables xml attac…Riti Malhotra 42 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Career Profile Dashboard: Filtering for Performance Tiles and Analysis Not WorkingSummary: We're creating a Career Profile dashboard and would like tiles/drill down analysis to display for employees whose career profile is In progress (1-8 out of 9 se…
-
Drill downs on DashboardSummary: Why does drill down report different numbers to dashboard when its the same report? Content (required): I've created a dashboard report for absence reasons, but… -
How to get SQL query details of BI Report data modelSummary: Hi , We need to identify list of Data models which is using a specific column in BI Report SQL query. We have two option , first is to verify manually all data …Niraj 2.3K views 2 comments 2 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Missing time card OTBI/BIP report or analysisSummary: Content (required): Is it possible to create an OTBI or BIP report to show employees who have not handed in their time cards? Either standard or customized repo…Nicolas Vahman 459 views 4 comments 1 point Most recent by user5969783 Reporting and Analytics for HCM
-
How to make the shown value of one column depend on the value of another column?Summary: How to make the shown value of one column depend on the value of another column? Content (required): I've made an analysis from the assignment real time subject…Matti Bugge 104 views 4 comments 0 points Most recent by Matti Bugge Reporting and Analytics for HCM -
Careers of Interest - ReportHi, Anyone has sample report for "Careers of Interest" which comes under development goals? Or can anyone help me with the tables? Regards, NivyaNivya Mathire 31 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Subject area for a person raceSummary: I need to add team member's race to a report, and I cannot for the life of me find the correct subject area to add! Please help Content (required): Version (inc…Jessica D 22 views 6 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Pull all active and terminated employee or single employee based on person numberSummary: I want to fetch all the records of active and terminated employees or single employees based on the person number parameter and history of all the employee chan…Deepak Bhatt 2.6K views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
OTBI: Custom message while opening DashboardSummary: Custom message while opening Dashboard Content (required): We have a requirement where cutomer wants to have custom message of dashboard prompt. Can we edit OOT…
-
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?
-
22B - Manager Resources Dashboard - white screen for around 15 seconds before loadingSummary: Since 22B deployment, our dashboards are taking around 10 - 15 seconds to load... Content (required): Has anyone else got an issue loading dashboards? Since 22B…Kevin M Storrie 62 views 7 comments 0 points Most recent by Bhaskar Konar 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 32 views 5 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
Job Requisition approval audit reportSummary: Please help with Requisition approval audit report sample. hanks in Advance. Content (required): Version (include the version you are using, if applicable): Cod…User_2025-02-12-21-07-06-233 52 views 3 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM
-
Getting error in Headcount OTBI ReportSummary: Hi all I am using the below Subject area Workforce Management – Worker Assignment Real Time Compensation – Salary Details Real Time Workforce Management – Perso…Deepak Bhatt 32 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM