Category 81
Discussion List
-
Facing Issue with Multiple Adjusted Service DatesSummary: Trying to run service anniversary reports using our adjusted service dates. However employees have multiple adjusted service dates and need the report to only p…Dannielle Dellucci 13 views 2 comments 0 points Most recent by Dannielle Dellucci 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…
-
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 …
-
Table names/SQL query for Individual Compensation details in HCMSummary: Hi All, Can you please share me the Table names/SQL query for Individual Compensation details in HCM. Thanks, Janardhana Content (required): Version (include th…Janardhana 14 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
OTBI Analysis report for auditing changesSummary: Hello - we are looking for a report/audit tool that will help us monitor when changes have been made to OTBI analysis based reports. We are utilizing the functi… -
Cannot Modify Chart Properties on BI Publisher for WordSummary: I am trying to edit an rtf document using BI Publisher for Word to increase the size of the chart and the font. When double clicking on the graph/chart to displ…Johnna Balane 4 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Query to Retrieve All Privileges and Roles for All RolesSummary: We want to know the query/tables that will allow us to retrieve all Roles details including the assigned Functional and Aggregate Privileges Content (required):…Aahiri Sarma 18 views 1 comment 0 points Most recent by Julian Challenger-Oracle 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 10 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 8 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Candidate Date of Birth and NI Number not pulling through on OTBISummary: We have the Regulatory Response Date of Birth and Primary National Identifier Number Columns from Recruiting - Real Time in a report. I am testing applying as e…Alex Buckley 2 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Highest Education level not showing in OTBI person profile subject areaSummary: Hi Team, we have need to extract the report of each employee of highest education level but not coming in workforce profile - person profile real time . ANy one…AjayKumar Maddipati 8 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
how to enable https://www.google.com/jsapi'></script> at otbiSummary: I took from sharing center report for org char it is not working because I don't know how to enable the sceipt Content (required): window.onload = function(){…Yechiel 1 view 15 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
How can I display talent information with job, salary informationSummary: I need to pull current job code and title, salary, salary grade for associates and combine it with their most recent talent meeting results (i.e., date of meeti…Wendy Dayton 17 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Need query to get scheduled process details such as process name, scheduled time, parameters.Summary: Need query to get scheduled process details such as process name, scheduled time, parameters. Content (required): I need query where I can get count of active s…
-
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…ChuckM_23230 11 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Need query to get scheduled process details such as process name, scheduled time, parameters.Summary: Need query to get scheduled process details such as process name, scheduled time, parameters. Content (required): I need query where I can get count of active s…
-
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 15 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 13 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 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Requisition Template ReportSummary: Hello - We are looking to create a report which shows all jobs and the requisition template they are associated to based on the Job Details section. We are not …
-
How to display old and new cost center in HCM extractSummary: How to display old and new cost center in HCM extract Content (required): We are creating one HCM extract report to display old and new cost center. We are able…
-
Can we use case when condition in Parameter 1(To email address) while using burstingSummary: Can we use case when condition in Parameter 1 (To -email address) while bursting. Content (required): I need to deliver report to different email address as per…
-
Query to fetch Run Result Element Entries & Balances for particular time periodSummary: We have a requirement to pull element entries & balances from Run Results for the particular time period. I have written the below query but which is giving mul…
-
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 24 views 2 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
Create Temporary Table or View for complex agreement templateSummary: Seeking advice regarding BI publisher capabilities to create temporary data tables. Content (required): Hi team, I am seeking advice as to whether it is possibl…
-
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 16 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 27 views 3 comments 0 points Most recent by Aaron Hager Associated Bank Reporting and Analytics for HCM