Category 81
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… -
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 …
-
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 22 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 555 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.8K 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 252 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 273 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 31 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 51 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 642 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 41 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.5K views 2 comments 3 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 498 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 106 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 34 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
-
Busting OTBI Myths - Using Agents to BurstContentMyth: OTBI doesn't support bursting, this is only possible in BI Publisher OTBI provides bursting via agents. Create an analysis that includes the lowercase compa…Julian Challenger-Oracle 451 views 18 comments 10 points Most recent by Raghavendra Raghunath-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.7K 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 61 views 7 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM