Global HR
Discussion List
-
OTBI filter to compare two attributesHello, We're building an OTBI Analysis that compares, for each employee, the competency’s rating given by his/her line manager in a Performance Document and the minimum …gguittini 62 views 4 comments 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for HCM -
Most recent salary record (Active and Termed)Summary: I have a report using the subject area Compensation – Salary History Details Real Time. I need the report to display only the most recent salary record for both… -
Need inputs to display Dependent and other information side by side in OTBISummary: Need inputs to display Dependent and other information side by side in OTBI Content (required): We developed Benefit OTBI report. Currently if an employee is ha…
-
Adding People Group to Workforce Trends/Payroll Run Results Subject AreasSummary: Adding People Group to Workforce Trends/Payroll Run Results Subject Areas Content (required): Version (include the version you are using, if applicable): Code S…
-
Need to report on how long is it taking for managers to approve their tasks in a particular workflowSummary: We need a report from the workflow side of things to give us insight into how much is each manager taking to approve their tasks. Content (required): This is a …
-
XLA_TRANSACTION_ENTITIESSummary: Team, How to join XLA_TRANSACTION_ENTITIES with Payroll / Assignment Tables and Get Person Related Transactions. Any idea would be highly appreciated. Thanks in…
-
Assignment DFF - Approval/FYI NotificationHi all If a manager changes DFF's in an assignment, it is sent for approval to a specific role. Some of the people receiving the notification don't see the changed DFF's…Annelies Van Erom 33 views 1 comment 0 points Most recent by Rambabu Laveti-Support-Oracle Human Capital Management
-
how to create extract such that it should only give the record for which department has changed.Summary: how to create extract such that it should only give the record for which department has changed. Content (required): This is change only extract. I have created…
-
Need Employee wise data where Checklist Response Text and Response answer in same row using OTBITrying to create an OTBI report from a survey which consists of both Response answer type and Text answer type questions. The report should show employee details, checkl…
-
BIP: How to create 'Year' parameter?We have a requirement to provide Year parameter as a dropdown in BIP report. It should default to current year, and allow users to select any other year from the drop do…Anshul Rai 65 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
How to avoid overlap labels in BI Pie chart?Summary: Our customer is using HCM cloud and developed some dashboards and it has some pie chart and labels are overlapping each as shown in the attachment. How to fix t…Peoplesoft 52 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need help with CAST formulaSummary: I have a report using Subject Area Recruiting - Recruiting Real Time. I need to calculate the number of remaining openings (Number of Openings - Hired Count) mu…
-
AsofDate- presentation variableSummary: I created a report and used the presentation variable Asofdate in Calendar option. However, when I run the report, the filter takes hire date = Asofdate and ret…
-
Adding Manager Termination Comments to Pending Terms reportSummary Adding Manager Termination Comments to Pending Terms reportContent Hello, We have an analysis set up for our HRBPs to pull pending terminations. One of the busin…User_2025-02-07-16-42-37-187 11 views 3 comments 1 point Most recent by Scott Conaway Reporting and Analytics for HCM -
Reporting on Offer Start Date if date ChangesSummary: Reporting on start date from offer when start date changes in assignment later. Content (required): I have a report using the Recruiting Real Time subject area …
-
What table are the 'Performance Rating' values in the Workforce Compensation worksheet stored?Hi All, I'd like to know if where are the values of 'Current Performance Rating' (highlighted below) is coming from? Thanks!notautomni9 42 views 1 comment 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for HCM -
Hire HeadCount CalculationSummary: I am using a Turnover template and wanted to understand some of the calculations regarding Hire HeadCount from the Workforce Management - Worker Assignment Even…Tristan Aquino 54 views 2 comments 0 points Most recent by Tristan Aquino Reporting and Analytics for HCM -
How to build HR analytics using Payroll Period and Payroll Year as time dimensionSummary HR OTBI Analytics with Workforce Management - Worker Assignment Event Real Time subject area and Payroll Calendar as Time DimensionContent Workforce Management -…User_UM4C6 44 views 3 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
restrict salary report by security profileSummary: We created a security profile for salary access based on department hierarchy (secured by aor) and assigned this security profile to specific custom roles. In t… -
How can I Embed Links within BI Publisher Interactive View?Summary: How can I Embed Links within BI Publisher Interactive View? Content (required): Hi all, I have created a BI publisher data model that includes an html formatted… -
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…
-
BIP Report Bursting - Need to split a large file into multiple small filesSummary: Need to split a large file into multiple small files Content (required): We developed few reports to send data to 3rd party systems. For the initial run, these …
-
Run Assignment Name and Job Name Mismatch as OTBI ReportSummary: Currently in order to run this report I go through the "Run Diagnostic Test" select and run, is there a way I can create this as a report in OTBI and schedule i…Gail Wilmoth 43 views 4 comments 0 points Most recent by Gail Wilmoth Reporting and Analytics for HCM -
Are Quick Actions ReportableSummary: Is there a way to report on Quick Action data via OTBI? If not, how can you pull data related to Quick Actions? Content (required): Version (include the version…
-
How to rename the person image downloaded using rtf template in BI PublisherSummary: Requirement to download the person image (person photo) from Oracle cloud HCM. I am able to download it but not sure how to rename the default name of the photo…
-
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 221 views 0 comments 8 points Started by Cindy Klymov-Oracle 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 172 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 33 views 5 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
Error when using different subject areas in OTBI: Odbc driver returned an error (SQLExecDirectW)When I am trying to use different subject areas (Workforce Management-Checklist real time and Recruiting Real time), I am getting the below error in the Results. Odbc dr…Mohit-Sinha 51 views 6 comments 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for HCM