Global HR
Discussion List
-
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 12 views 1 comment 0 points Most recent by Rambabu Laveti-Support-Oracle Human Resources
-
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 21 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 11 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…Katherine Sprick 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 21 views 1 comment 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for HCM -
How to use an OTBI analysis to create a data model with a parameter (prompted?)Summary: I am trying to use an OTBI analysis to create a data model. My data model will be refrenced by Oracle Journeys so there is a requirement that I attach a specifi… -
Need inputs to handle NULL values in OTBISummary: Need inputs to handle NULL values in OTBI Content (required): In case if an employee doesn't have Visa permit record then we are getting value as 00--0 in the O…
-
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 12 views 2 comments 0 points Most recent by Tristan Aquino Reporting and Analytics for HCM -
Report for Position Attributes change HistorySummary Looking for a report whcih can give us history of position attribute changes.Content Hi I am looking for a report to track changes in all position attributes lik…Mohit Gupta-45440 22 views 6 comments 1 point Most recent by Jesus N 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 23 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… -
Position History ReportingSummary Is it possible to report on changes to positions themselves over a period of timeContent I have a requirement to report on historical changes to positions in OTB…
-
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 21 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…
-
Privilege required to see Home Phone and Home Email Address in BIP ReportSummary: Content (required): We have few BIP reports created to cater to the client requirement. We see that the report doesn't fetch the Home Email Addresses and Home N…Prajna Hegde 71 views 8 comments 0 points Most recent by Mandeep Gupta Reporting and Analytics for HCM
-
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 21 views 4 comments 0 points Most recent by Vasanthakumar Ravi Workforce Management