Compensation
Discussion List
-
Can we restrict Benefits/Compensation Specialist from accessing Element Entries?Summary: Element Entries in BI Publisher Reports Content (required): For a client, with different legal entities, in reports we are making use of secured views at assign…VDoolhur 24 views 2 comments 0 points Most recent by Ramona Popescu-Oracle Reporting and Analytics for HCM -
Report not pulling correct salary infoSummary: We have a requirement from our HR department to build an AAP report that includes salary information for employees. We've tried building this report using a few…Henry Imgrund 30 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
In Salary report midpoint and comp ratio but report showing wrong when Grade code changedSummary: Hi Team, have direct column in salary report, midpoint and comp ratio but report showing wrong when Grade code changed . please any on help me on ? https://us.v…AjayKumar Maddipati 28 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
what is difference between CMP_ASG_SALARY_V and cmp_salary ?Summary: Hi Team, what is difference between CMP_ASG_SALARY_V and cmp_salary because of still cmp_salary showing corrctly of cs.COMPA_RATIO and cs.RATE_MID_AMOUNT column…AjayKumar Maddipati 67 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Rest API to create individual compensation planSummary: Hi All, Is there any REST/SOAP API available to create individual compensation plan? Thanks, Venkatesan R Content (please ensure you mask any confidential infor…
-
Is it possible to schedule reports under My Client Groups > Compensation > View Administration Rpts?Summary: Is it possible to schedule any of the reports under My Client Groups > Compensation > View Administration Reports? Content (please ensure you mask any confident… -
Compensation OTBI Best PracticesSummary Technical brief discussing compensation related OTBI best practices Content Document 2571003.1 - Compensation OTBI Best Practices (July 2019)Gail Langendorf-Oracle 152 views 2 comments 8 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Total Compensation Statement OTBISummary: Analysis for Total Compensation Statement - Feedback Survey Content (required): Is there an analysis available in OTBI to pull data for the Total Compensation S…Shelly Feyerherm 85 views 13 comments 0 points Most recent by Art Cannon Reporting and Analytics for HCM -
Sql query or Table for Worksheet Display and Default Worksheet Display assigned to compensation planHi team, Sql query or Table where the information stored for Worksheet Display and Default Worksheet Display assigned to workforce compensation plan in HCM compensation …
-
Sql query or Table name for Workforce Compensation plan cycles assigned to planHi team, We are unable to find the table where the "Plan cycles" information stored for HCM compensation module. Could you please provide us the table or sql query to ge…Opkey PA 254 views 2 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Trying to find the job details from the grade table through valid grades tableSummary: We are developing the grade ladder report in that we need to get the job details for the grades. However, we get duplicates due to the multiple valid grade IDs …Rengaraj G 15 views 1 comment 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM
-
OTBI report for salary basis history exampleSummary: Content (please ensure you mask any confidential information): Hello experts, do you have a sample OTBI report tracking the employee salary basis history with a…Valerio Curzi 124 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Unable to see newly created elements in OTBI reportThere was an error rendering this rich post.Shanna Oppenheim 29 views 5 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Trying to create a BI report to fetch out the payroll element entry data for employee.Here the data is flowing from ORC to Individual Compensation.When the employee is hired he will be awarded with some "BONUS" with some additional fields these data's wil…Jebarsan Thangam John Durai Raj 106 views 10 comments 1 point Most recent by Shanna Oppenheim Reporting and Analytics for HCM
-
An internal assertion test couldn't be completed at location ReportUtils.validateArchiveDefn:2.Summary: Non - US payroll extract is giving the error in one of the scheduled runs in production: An internal assertion test couldn't be completed at location ReportUtil…Shilpa Varghese 212 views 4 comments 0 points Most recent by Shilpa Varghese Reporting and Analytics for HCM -
not able to fetch latest date even after using MAX functionHi team i am trying to fetch latest last update date record in below query but unable to do it.i am looking for 2022 as a latest date record but when i use max function …Chetana Pawar 18 views 1 comment 0 points Most recent by Rakesh Ghosh-Oracle Reporting and Analytics for HCM
-
Compensation Zones and Grade Differentials of an employee in BISummary: How can I get the Compensation Zone and Grade Differential an employee is assigned to? I saw from previous posts that the details are in the CMP_ADDRESS_ZONES t…Tom John Bontoyan 40 views 5 comments 0 points Most recent by Rajesh Jupudi -Oracle Reporting and Analytics for HCM
-
Missing Salary data post 24A upgradeSummary: Post 24A upgrade all OTBI reports failed to load salary data. We looked into each column added in the reports and noticed the issue is caused when there are col…Ridma Karunanathan 26 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Can we restrict managers doing calibration outside of Performance distribution?Summary: We have Performance Distribution added to a Profile rating model. In Calibration, same information is being used to display Bell Curve. Now, as an HR, if I am d… -
How can we replicate the Budget Analysis from Administration report in CompensationHi, We want to replicate as a OTBI Analysis the Budget Analysis from Administration report in Compensation in order to have information about the Overall Budget amount f…Crisenese 26 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Does anyone know which tables I need to use to retrieve the Bonus Amount from the Compensation ModueSummary: I have a requirement to show last years performance bonus amount in a report and I have built most of the information using SQL but I am unsure what tables I ne…User_2025-02-04-08-51-08-912 607 views 6 comments 0 points Most recent by Phils Reporting and Analytics for HCM -
HTML Markup values are not working after 23B updateSummary: Good afternoon, I am having issues while trying to save an edit of code within the sandbox > HTML Markup. When making the replacement, the system only saves par…Jorge_Trindade 65 views 8 comments 0 points Most recent by User_3MBEU Reporting and Analytics for HCM
-
OTBI report retrieving Base Salary amount and Annual Salary amountSummary: Content (please ensure you mask any confidential information): Hello experts, do we have a standard OTBI to retrieve Base Salary and Annual Salary amount? If so…
-
Sample OTBI report to track compensation plan approvalSummary: Content (please ensure you mask any confidential information): Hello experts, is there a sample OTBI report to track compensation plan approval status? I notice…Valerio Curzi 12 views 1 comment 0 points Most recent by Andreea_Nuck-Oracle Reporting and Analytics for HCM
-
Roles required to access compensation data in reportsSummary: What are the roles required to access compensation data in reports Content (please ensure you mask any confidential information): Version (include the version y…Gleamy Mishra 19 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Salary pay rates are incorrect for some employeesSummary: The OTBI report is showing incorrect pay rate data for some employees for HRA EX and Notional Special Allowance components. We cannot identify why this data is …Ridma Karunanathan 30 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Oracle BI tables to retrieve individual compensation plan nameSummary: Content (please ensure you mask any confidential information): Hello experts, we are building custom report. Do you know the BI table to retrieve Individual Com…Valerio Curzi 14 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Report for a Salary basis of the type "Salary amount is determined by simple components"Summary: We have a Salary Basis defined of the type "Salary amount is determined by simple components" and we have hired an employee with this salary basis. There are 5 …Sachin_Shirke 370 views 4 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Using 2 different subject areas (Salary and Performance Rating) - Getting split/merged cellsSummary: Hi Experts, I'm pretty much a beginner with reporting. My client wants an OTBI report that can pull salary details as well as latest performance ratings (overal…S Shree 89 views 9 comments 0 points Most recent by Reddykrishna Chidella-Oracle Reporting and Analytics for HCM
-
Days of service calculationHi Team, I am using "Workforce Managemnet - Work Relationship Real Time" subject area and I want to calculate "Days Of Service" only for Terminated employees. I want to …Raghu_Nandan 27 views 1 comment 0 points Most recent by BogdanFarcasanu-Oracle Reporting and Analytics for HCM