Compensation
Discussion List
-
Missing Salary Report on OTBIContent Hi all. I'm trying to build a simple report on OTBI that reports the employees who are missing salary at the current date. I tried to use both Compensation - sal…User_CLJBO 41 views 7 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
CONVERT FF to UDT creationContent hello Experts, I would like to ask for your assistance in converting fast formula - XX_RECOMMENDED_MAX_QUARTILE_FF to a user defined table. This FF is used in BP… -
Workforce Compensation Report -Acttion Required,Hierarchy Level,Manager statusContent In Workforce Compensation not able to find these columns Acttion Required,Hierarchy Level,Manager status Fields in OTBI (Compensation - Workforce Compensation Re…User_VR8E0 16 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Compensation--> Individual Compensation UI TablesSummary Compensation--> Individual Compensation UI TablesContent Hi, We are trying to get Compensation--> Individual Compensation UI data in extract. So Please help me i…Manvendra Singh 87 views 2 comments 0 points Most recent by User_5HU7Y Reporting and Analytics for HCM
-
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 23 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 40 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 12 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 19 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 21 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 27 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 12 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 222 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 17 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 54 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 44 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 255 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 23 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… -
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 173 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 80 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 53 views 0 comments 7 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 -
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 35 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 78 views 5 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM