Sample Reports
Discussion List
-
How to remove null values in OTBI? If I change choice list to SQL, the Limit Values disappears.Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to compare output of two files in oracle fusionSummary: We've created a custom BIP report to get the salaries of each employee. This output from the publisher, we wanted to match with the document with same format wh…zafarkhan 17 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Need to report on Work schedule with attached work pattern and attached holidaySummary: Hi Every one, I need help to develop one absence report where we can see work schedule and attached exceptions and workday/non workday. Below is sample output:-…Krishna Manmohan 15 views 1 comment 0 points Most recent by Kumar -Oracle Reporting and Analytics for HCM
-
OTBI Element Type Setup report with Costing not showing data if the element is not costedSummary: Hello. I'm trying to report on Element Type Setup with Costing details on OTBI using the "payroll - element enteries history real time" subject area. The report…Laura_Stewart_Sita 10 views 0 comments 0 points Started by Laura_Stewart_Sita Reporting and Analytics for HCM
-
Optimizing Infolet Loading Time on the SpringboardHello Community, We’ve designed and implemented multiple infolets for employees, line managers, and HR, placing them on the springboard to provide quick access to releva…Harish Vummidi 10 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Request for Infolet Samples to Enhance User Experience in Core HR, Absence, ORC, OTL, and PayrollHello Community, I’m currently exploring ways to enhance the user experience for employees, line managers, and HR teams in Oracle Cloud by leveraging infolets effectivel…Harish Vummidi 13 views 0 comments 1 point Started by Harish Vummidi Reporting and Analytics for HCM
-
How to create a Bell Curve in OTBI reportSummary: Client team is expecting to show the Performance Rating Distribution results in a Bell curve model as shown in the attached screenshot. Could you please share a…Santhosh Gangishetty 265 views 14 comments 0 points Most recent by Gimhani Perera Reporting and Analytics for HCM
-
Time Change Request reportSummary: Hi All, Has anyone Developed a BI/OTBI Report on Capturing Details of Time Change Requests? We have a requirement and working on this. Appreciate if anyone can …Abhishek Bhaskar 22 views 3 comments 1 point Most recent by Peeyush Chandel Reporting and Analytics for HCM
-
Query to get REQUISTION NUMBER, REQUISITION NAME, CANDIDATE SELECTION PROCESS, REQUISITION STATUSSummary: Can anyone please help me in writing a Oracle SQL Query for BI Report to fetch columns like REQUISTION NUMBER, REQUISITION NAME, CANDIDATE SELECTION PROCESS, RE…
-
401K Annual Census ReportSummary: We are new to Oracle Cloud and looking for a 401(k) or 403(b) Annual Census file. It would include Name, SSN, DOB, Hire Date, Term Date, Status, Gross Earnings,…Dee Dee Deffez 43 views 3 comments 0 points Most recent by Dee Dee Deffez Reporting and Analytics for HCM
-
adding different manager types to analysis reportsHello there, I have prepared a report from the analysis and in this report I would like to see the types of managers that people are affiliated with, such as head and ex…Sinem Kara 25 views 4 comments 0 points Most recent by Girish Kushibi Reporting and Analytics for HCM
-
Submitted Timecard and Web Clock Details ReportSummary: Need to SQL query for view the detail of submitted timecard and web clock's reported hours and schedule deviation with custom attribute. Content (please ensure …Melek Cinar 331 views 6 comments 0 points Most recent by Melek Cinar Reporting and Analytics for HCM
-
report /audit to track any changes done to auto provisioning rules(HCM role provisioning rules)Summary: We need to get a report /audit for any changes done to auto provisioning rules(HCM role provisioning rules). Please help us on how to achieve this requirement. …
-
Position Occupancy ReportHi All, We have noticed that seeded Position Occupancy Report is not working as expected. Incumbent Headcount for all the positions is showing null though there are incu…
-
Position Hierarchy ReportContent (required): Looking for BI report to get the current logged in person's position and the positions under his hierarchy. Version (include the version you are usin…
-
Example Feedback Report query for BI Publisher based on Feedback requests and Questionnaire tablesSummary: Our requirement is to generate a report based on feedback requests and questionnaire (eg. Annual Performance Feedback) tables. Manager will submit Feedback Requ…MadhuLekkala 13 views 2 comments 0 points Most recent by MadhuLekkala Reporting and Analytics for HCM
-
Which table stores the details of benefit dependents and their ages in the Benefit tables or OTBI?Summary: I need to fetch the designated dependent name, relationship to the employee, gender, date of birth, and age for each benefit plan. Please help me understand how…Ketha Paramesh 41 views 3 comments 0 points Most recent by Andreea_Nuck-Oracle Reporting and Analytics for HCM
-
Opportunity Marketplace Out of the Box ReportingSummary: Opportunity Marketplace Out of the Box Reporting Content (please ensure you mask any confidential information): Are there any out of the box reporting for Oppor…
-
Absence Calendar Direct Reports Current Month not returning any valueHi Experts, When we are running the report "Absence Calendar Direct Reports Current Month" from Line manager Dashboard, It is coming as empty. I have checked then backen…Nivya M 77 views 8 comments 0 points Most recent by Gunasagar Thimmapuram-Oracle Reporting and Analytics for HCM
-
Creating a Unified Report for Job Application Details and Pre-screening ResponsesHello Cloud Customer Connect Community, I hope you're all doing well. I'm currently facing a challenge and would greatly appreciate your expert insights. I am in the pro…Harish Vummidi 41 views 2 comments 0 points Most recent by Harish Vummidi Reporting and Analytics for HCM
-
How to exclude null values in eText output using RTF templateSummary: Example: My output file is comma separated .txt file generated using RTF template for HCM extract. I have 25 columns, out of which first 5 columns are fixed i.e…Shilpa Varghese 44 views 3 comments 0 points Most recent by Kevin M-Oracle Reporting and Analytics for HCM
-
Query to get Report run History in Fusion HCMSummary: Query to get Report run History in Fusion HCM Content (required): Hi All, Can we get the detail who all have run the BI report, is there any query available. He…Swati U 1.3K views 11 comments 0 points Most recent by Punam Roy Karmokar-272206 Reporting and Analytics for HCM
-
Need to add Adjustments and Absences in two different columns. Please hep me with the querySummary: Hi Folks, I need to add Adjustments in one column and Absences in one column in the report in Absence Management. Please help me with the query. Content (please…Raj_540 3 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Dashboard error.Summary: Hi Expert, I am getting below error while running the dashboard. If I provide the some Active LE and LDG and location still getting same error. Waiting for prom…
-
OTBI Map exampleSummary: OTBI Map example Content (please ensure you mask any confidential information): Hello experts, does anyone have an example of an OTBI report with a Map view? Th…Oriana L. 2 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
An OTBI report that provides a historical record of all changes made to the employee's assignment.Hi, I need the details of the employee's assignment from hire to termination and I want to create a history report. For example like this, hire on '01.01.9999', promotio…Cansel Karasoy 619 views 6 comments 0 points Most recent by Karen Wilson Reporting and Analytics for HCM
-
Able to view logos/images from Documents of Records in HTML output in BIPSummary: Able to view logos/images from Documents of Records in HTML output in BIP Content (please ensure you mask any confidential information): We uploaded few logos/i…
-
Report that shows job requisition salary vs job offer salary.Hello I am trying to pull together a report that compares the requisition salary and the job offer salary filtering only on requisitions that are filled. I am unable to …
-
Physical Signature Example Report for JourneysSummary: In release 24B, Journeys introduces the ability for Physical Signatures to be captured in the Native Electronic Signature task types. Additionally, Native eSign…