Global HR
Discussion List
-
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… -
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…Arnabb 11 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
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 11 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… -
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 -
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 51 views 0 comments 3 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 41 views 10 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Cross subject area analysis - ErrorSummary: Content (required): Hello everyone, We are trying to create a cross analysis in OTBI using the following subject areas: Workforce Management - Person Real Time … -
Is it possible to have multiple organization trees active in core HR?Summary: Is it possible to have multiple organization trees active in core HR? What is the impact if the hierarchy is different? Does this affect reporting? Content (req…Pratyusha 41 views 8 comments 0 points Most recent by Julian Challenger-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… -
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-Oracle 31 views 6 comments 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for HCM
-
table to pull the error details from transaction console.Summary: Hi All, I'm trying to build a report and looking to pull the error details from transaction console. I tried searching tables but I'm not getting the info, can …vamshi krishna-283622 11 views 6 comments 0 points Most recent by vamshi krishna-283622 Reporting and Analytics for HCM
-
OTBI > Ability to get the work schedule assigned to Employee in reportContent Hello All, I will appreciate your support in the following issue: Do you have an idea if possible to get the work schedule assigned to employee in OTBI or via SQ…
-
Table to pull the Highest Education Level in BIPSummary: Need to determine the table that retrieves the Highest Education Level under Person details Content (required): Version (include the version you are using, if a…RenzelkeithCoquia 11 views 2 comments 0 points Most recent by Mandeep Gupta Reporting and Analytics for HCM