Global HR
Discussion List
-
How to add multiple filters in HCM Extract Filter CriteriaSummary: We want to add another filter under HCM Extract Data Group Filter Criteria to filter out terminated employees who has been rehired later from our result set. Co…GauravGupta39 576 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
how to add a manager email as cc in a bursting report sqlSummary: I have a report which i'm trying to schedule, but i'm stuck at the cc part. i need to add the manager in the cc field. below is my sql, how do get the manager v…
-
ODBC Error - ADFService11g on OTBI AnalysisSummary: After 22B went into our Test environment, a report built on a few subject areas no longer works. It is giving us the following error: State: HY000. Code: 77031.…
-
Hourly Rate FormulaSummary: I have a report using the subject area Compensation – Salary Details Real Time and need to add a formula that calculates a base hourly rate. Here is what I'm lo…JHaden3 114 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Date Match Formula ErrorSummary: Date match formula errors when I run the report. CASE WHEN "Work Relationship Details"."PER_PPS_LEG_DDF_ST_BS_SR_STRT_T_" = "Workforce Management - Worker Assig…
-
OTBI Report Performance IssueSummary: OTBI Report Performance Issue Content (required): Hi Team, We have developed the turnover dashboard using "Workforce Management - Workforce Trend Real Time" sub…Vasanthakumar Ravi 78 views 1 comment 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for HCM -
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 34 views 1 comment 0 points Most recent by Rambabu Laveti-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 64 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 53 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 13 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 43 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 52 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 42 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…