Reports
Discussion List
-
Which Table Assignment Hours Details StoredSummary: Which Table Assignment Hours Details Stored Content (required): Hi Team, Please guide me to get the table name which stored assignment hours details. Please fin…Vasanthakumar Ravi 23 views 4 comments 0 points Most recent by Vasanthakumar Ravi Workforce Management -
New Bite-Size Learning Videos Published for HCM AnalyticsSummary: Need to learn how to modify OTBI analytics? Please check out the new Bite Size Learning videos just published to the Oracle Help Center Bite-Size Library page: …Cindy Klymov-Oracle 222 views 0 comments 8 points Started by Cindy Klymov-Oracle Reporting and Analytics for HCM -
How do I find which assignment categories and termination types are included in our turnover report?Summary: Content (required): My company utilizes the dashboard functionality to capture turnover. In addition, a department completes a turnover report separate from the… -
How to create a printable report?Summary: Content (required): Hello everyone, We are trying to understand what are the needed steps to give the opportunity to the users to print the performance report. …Agapi 23 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Difference between SQL Data Sources?Summary: Content (required): Hello everyone, We are trying to create a new Data Model for Performance Management in HCM by using an SQL Query. However, we are not sure w…Agapi 51 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need Output as a XML for generate payslip process in Flow patternSummary Need Output as a XML for generate payslip process in Flow patternContent Hi Team, we have a requirement to get the payslip xml from generate payslip process , we…User_2025-02-04-07-00-18-658 61 views 3 comments 0 points Most recent by Naramsetty Ashok Reporting and Analytics for HCM -
How to find missing privilege to get archive and unarchive options on reportsSummary: How to find missing privilege to get archive and unarchive options on reports Content (required): Hi Team Greetings! The archive and unarchive options are not s…Parag Hiremath 135 views 10 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Work Relationship Last Update Date vs Current DateSummary: Hello - we are trying to create a Termination report that will be scheduled to run daily with the condition that the termination date equals Current Date OR the…Shanna Oppenheim 31 views 5 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
Unable to find Pension Calendar year to date column tableSummary: I am unable to find pension Calendar Year to date column for Annual Pension Initial loaded data in only available in PAY_BAL_BATCH_LINES Table Content (required…Ashutosh12 22 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Query to Fetch withdrawn assignments in LearningSummary: I am trying to fetch the learners who got withdrawn from the courses in Learning. Content (required): We discover that thousands of learning assignment records …Thulasi Ram 71 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
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 750 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Audit log or report for configuration changes to the systemSummary: Is there a report or change log that can be obtained from system on application configuration changes ? Does anyone know of an audit log or report for configura…MilanMohanty 694 views 4 comments 2 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Query to get statement of earningsSummary: Can someone share query to get all the balances on statement of earnings screen along with its element and values. I wrote a where I am getting the expected val…Jaeyshree Kumaran Kalpana 497 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Report for Performance DocumentSummary: Hi Folks, I would like to access a report that will display any 'transferred' performance documents within the Performance System. We would also like to filter …Sowmiya Velusamy 43 views 3 comments 0 points Most recent by Raghavendra Raghunath-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 66 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 89 views 11 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to obtain Source System ID for absence entriesSummary: Content (required): I have a requirement to use HDL to delete and then re-submit a large quantity of annual leave absence entries. I have an HDL file that I can…
-
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 23 views 2 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Query to find All grade Rate values with Grade codeSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Sowmiya Velusamy 2.7K views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Learning ProgressContent we are trying to mimic the reporting for learning on the front end that shows progress (1/5) for the specialization or course but I can't find this field. see sc…Riti Malhotra 51 views 3 comments 1 point Most recent by Lanette Frank-Oracle Reporting and Analytics for HCM
-
Does anyone how to saved search in BIP parameter?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Hazel De Castro 22 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
How to put the information into one row and limit the duplications?Hi All, I've been working on building a report to show the employee's personal information (address, contact number etc) and include their emergency contact information …
-
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
-
Union for 2 reportsSummary: How can I combine the output of 2 reports into one output Content (required): I have two reports, both using the same 2 Subject Areas (Workforce Management - Wo…Joe Dorrian 32 views 4 comments 0 points Most recent by Julian Challenger-Oracle 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 25 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
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 -
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 276 views 2 comments 0 points Most recent by MilanMohanty 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