Compensation
Discussion List
-
Annualized Salary is not populating on a OTBI reportContent When running an OTBI report the Annualized Salary value is not populating. The user has AoR's and when they view the salary details via the HR forms the details …Rebecca L Smith 22 views 4 comments 1 point Most recent by SantoshKumarB Reporting and Analytics for HCM -
Including Matrix Manager pulls wrong SalaryContent Hello, Has anyone created a report where you have included fields from both Worker Assignment Real Time -> Matrix Manager and Compensation Salary Details Real Ti…
-
Individual compensation plans subject areasContent Hello experts, I should create a payroll report in order to extract for each employee Individual Compensation Plans information. As a result, I need the followin…Valerio Curzi 39 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Business Unit Headcount vs recognitionContent I am trying to create a pivot table to show headcount of business unit against our recognition values which employees have been awarded. So I can clearerly see a…Melissa Christova 11 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Show Field Data in Column instead of in RowsSummary Working on this in OTBIContent Hi All, I am trying to pull in the last 2 dates an employee was paid. Currently the data appears as 2 separate rows. I am using ra…tiffnyc 18 views 5 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
User Prompt Results Causing ORA-01795 Error (IN statement 1000 expression max limit)Summary Need solution to get past ORA-01795 error caused by expressions returned from user prompts into an IN statement when selecting AllContent Hello, Appreciate any h…
-
Unable to get Min and Max values in Compensation OTBISummary We are struggling to use the min and max function to get proper valuesContent Hi folks, Trying this channel and hoping to find some help and support from custome…Hakim Slimani - AXA 20 views 2 comments 0 points Most recent by Hakim Slimani - AXA Reporting and Analytics for HCM -
Formula for Sum of aggregate salary change percent by person number?Content Hi Everyone, I am trying to determine the best way to write a formula to show the sum of salary change percent by person number. For example, I have an employee …Katherine Sprick 26 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Employees with Cumulative Salary Increase of >20% over a fiscal year reportSummary Employees with Cumulative Salary Increase of >20% over a fiscal year report for audit purposesContent Hi Oracle Team, We were just asked by our audit team to pro…Katherine Sprick 11 views 3 comments 0 points Most recent by Katherine Sprick Reporting and Analytics for HCM
-
Need help on Employee Personal Contribution report buildSummary Need help on Employee Personal Contribution report buildContent Hi Team, We are in the process of developing a report that report will be used to identify employ…Mahendra 17 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Missing direct deposit or personal payment end dateContent We are finding that we are deep into payroll processing before we recognize an employee forgot to enter their direct deposit information and a paper check is a r… -
Salary changes after a particular dateSummary I need a report which will identify employees that have saalry changes after a given dateContent When we apply a pay award (i.e. uplift grade rates) it does not …Esther Hess 17 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to add a BI Report to a Fusion PageSummary This document explains how to add a report to an HCM pageContent How to add a BI Report to a Fusion Page This document explains how to add a Salary Range Analyti…Gail Langendorf-Oracle 220 views 4 comments 6 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Not able to create dynamic Password PDF DocumentSummary Not able to create dynamic Password PDF DocumentContent Hello Everyone, we followed below steps: 1)Open the .rtf fil 2)Go to File - > Properties 3)Create a new c…Richa-154843 16 views 3 comments 0 points Most recent by MandeepKGupta Reporting and Analytics for HCM
-
Compensation with manager with access 'limited'Content hello, I have a question, on a compensation plan, if a manager is not eligible to a compensation plan but he manage someone inside the compensation plan, he have…Amaury Blanc 53 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to display grade from prior salary change on same lineSummary In a comp history analysis, I need to report on employee's grade as of the salary update immediately prior to the current salaryContent Subject Area: Compensatio…James Hoffmann 43 views 7 comments 0 points Most recent by James Hoffmann Reporting and Analytics for HCM
-
Sample Report: Salary Change Date Prompt (updated)Summary Sample salary change report using a date promptContent Salary Change Report Date Prompt This is part of the series of sample reports to use in your cloud environ…Gail Langendorf-Oracle 254 views 3 comments 3 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Pivot Salary Data For Employee PopulationSummary Want to display salary data for employee population without summing the dataContent Hi - I am trying to create a pivot table in OTBI that would show salary data …Kyle Norris 20 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Some employees are not listed in the Salary report created from "Compensation - Salary Details RealSummary The salary report is created from "Compensation - Salary Details Real Time" subject area and it does not have any filters that restrict employee information from…
-
How to paste an XMLSummary Explains how to paste an XMLContent Often you may see sample reports in this forum, and this how you copy and paste the XML. 1-select new analysis 2-select a sub…Gail Langendorf-Oracle 41 views 0 comments 4 points Started by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Salary reportSummary Salary reportContent I need a report which pulls current salary and previous salary details. Can any one have SQL to pull the data. PERSON_NUMBER OLD_SALARY_STAR…Reddykrishna 172 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Audit report for individual compensation dataSummary Audit report for individual compensation dataContent Hello, we are trying to run the Audit report (https://docs.oracle.com/en/cloud/saas/global-human-resources/1…
-
fields to use for employee bank account reportSummary what fields to use for employee bank account report?Content hi what are the correct fields and subject to use for getting a report of current employee bank accou…Doron de Jong-57089 79 views 11 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Compensation OTBI Best PracticesSummary White paper discussing compensation related OTBI best practicesContent Document 2571003.1 - Compensation OTBI Best Practices (July 2019)Gail Langendorf-Oracle 52 views 0 comments 6 points Started by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Need tables in fusion that store the Salary Details and Salary Component Breakup detailsSummary Need tables in fusion that store the Salary Details and Salary Component Breakup detailsContent Hi, Can anyone please provide me the table names that store the s…User_MC37Q 101 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Report to view workflow configuration in Fusion HCMSummary Report to view workflow configuration in Fusion HCMContent In Fusion HCM, we navigate to 'setup and maintenance' > 'Manage approvals for Human Capital Management…Naveen Bitra 223 views 8 comments 0 points Most recent by Linda Dunn Reporting and Analytics for HCM
-
Salaries in WordsSummary I Need to put in Word Template the Salaries in wordContent I need to put in template WORD (bi publisher) , the salary in full (Words) can someone help me?Jorge Donaire-229567 34 views 8 comments 1 point Most recent by Sahil Makhiza Reporting and Analytics for HCM
-
Salary and Assignment Changes ReportContent Hi all - I am working on a few changes reports, and the next one we are working on is assignment changes AND salary changes. I am very comfortable with doing an …Prudence K 76 views 5 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to delete duplicated records in OTBI AnalysisContent Hello experts, I have just created a custom OTBI Anaysis by using Compensation - Workforce Compensation Real Time subject area only. However, the analysis return…Valerio Curzi 19 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Salary in USDSummary Create a report which calculates Salary in USD from Local currencyContent Hi, Am try trying to create a OTBI report which converts Salary (in local currency) to …Manish Sharma-24619 23 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM