Compensation
Discussion List
-
How to fetch CURRENT and PREVIOUS Salary using BIP?I need columns to compare the CURRENT and the PREVIOUS salary of employees in 1 row only. How to construct the BIP report using SQL?Welsey 598 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Is it possible to report on Workforce Compensation Change Statement Volumes executed by managers?Summary: We have our Compensation Change statements configured to Printed and delivered by managers, we would like to monitor and report on how many managers are accessi…Adam_Cantwell 13 views 1 comment 0 points Most recent by Adam_Cantwell Reporting and Analytics for HCM
-
How to display column label values dynamically in a Matrix report using BI PublisherHi, We have a Matrix report requirement using BI Publisher where we need to bring across the row and column label values dynamically (as values are not constant) as per …Tejashree S 55 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Transfer Workforce Compensation to Payroll - element entry reason for Bonus element?Summary: In the compensation module in either the workforce compensation plan or in the transfer to Payroll process, is there a way to populate the reason field to show …
-
Which Table Holds "Access level" From The Compensation Worksheet ?Summary: SQL query to fetch Access Level in report. Content (please ensure you mask any confidential information): I need to fetch "Access level" From The Compensation W…Tamseel Aijaz 12 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
SQL code to fetch Overtime, bonus, commissions, merit increases, and locality pay for employeesSummary: Hi Experts, Please provide the SQL code to fetch overtime, bonus, commissions, merit increases, and locality pay for employees. Thanks. Content (please ensure y…Arti_Priya 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Create Report to Include Sign On Bonus from Offer LetterSummary: I have an analysis report that list candidates that we had hired. However, I need to add Sign On Bonus amount into the report. I found the "Other Compensation" …
-
HCM table to fetch eligibility status of compensation plan.Looking for HCM table to fetch eligibility status of compensation plan as "Eligible" or "Limited".Tamseel Aijaz 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Progression Ladder for a bi_query_reportSummary: how to join rates to per_grade_ladder_f and per_grade_steps_f for a bi_query_report to show Progression Ladder > Grades that belong to Ladder > Steps in Grade >…
-
BI tables to retrieve Compensation Plan Status and track compensation plan approval flowSummary: Content (please ensure you mask any confidential information): Hello experts, we need to track manager compensation plan status (i.e Submitted; Work In Progress…Valerio Curzi 23 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to pull data from Additional Compensation in BIP ReportsHello Experts, Does anyone know how to or who has available SQL to fetch these data from Additional Compensation ThanksJoliver Caangay 3 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
ICP start date in fast formulaSummary: How to restrict start date in ICP page. We want to restrict employee entering the back dated changes for their pension contributions. Have any one done these ty…SivaKumarRajan 27 views 4 comments 0 points Most recent by SivaKumarRajan Reporting and Analytics for HCM
-
Getting merged and blank rows while trying to fetch Performance rating and Salary together in OTBISummary: Hi Peers, I am trying to build an OTBI analysis to fetch both the Performance rating and the Salary. I'm using Compensation - Salary Details Real Time and Workf…
-
Need to know the table that contains bonus amount in Individual compensation.Summary: I'm looking for the table that stores Bonus amounts entered through the Individual Compensation module. I need the table that stores the person_id, assignment_i…Prerna Mhaisane 54 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How can the seeded compensation dashboards below for managers be customized?Can anybody suggest the right way to edit these seeded dashboards and do the customization based on our company needs. The need is to Add/ remove parameters Add/ remove …Sameeksha MN 12 views 3 comments 0 points Most recent by Sameeksha MN Reporting and Analytics for HCM
-
Logical SQL With Dashboard PromptSummary: Hi - I am trying to build a logical SQL report that displays paycheck information along with current salary as an outer join from Compensation subject area. The…
-
Best Practices: OTBI Compensation - Compensation Stock Details Real Time subject areaSummary: This is part of a series for best practice tips to use in your cloud environments, created by Oracle BI and Product Management. Roles and Privileges Compensatio…Gail Langendorf-Oracle 14 views 1 comment 2 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Error : An application error occurred. See the incident log for more information.Summary: Is there any way to retrive log for error message : An application error occurred. See the incident log for more information. Content (please ensure you mask an…Muzammil Aman Siddiqui-Oracle 213 views 0 comments 0 points Started by Muzammil Aman Siddiqui-Oracle Reporting and Analytics for HCM
-
When the customer is trying to edit salary information from Salary History Page and then submittingSummary: When the customer is trying to edit salary information from Salary History Page and then submitting it they are getting error "" An application error occurred. …Muzammil Aman Siddiqui-Oracle 2 views 0 comments 0 points Started by Muzammil Aman Siddiqui-Oracle Reporting and Analytics for HCM
-
BI Publisher Report SQL Error : SQL or ORA exceptions caused due to invalide sql , database packageSummary: I've created a headcount report that combine all workforce informations based on per_all assignments, compensation data based on cmp_salary_v cmp_salary_v2... i…Ayoub AFRASS 826 views 5 comments 0 points Most recent by Juan Pablo Gonzales Reporting and Analytics for HCM
-
Employee displays in analysis for indirect leader they no longer report up toSummary: We've kicked off our workforce compensation cycle. I have an employee who changed managers earlier this year. The indirect manager they previously reported to i…Susan Anderson 21 views 2 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Redwood Compensation page for global and local transferSummary: On the redwood experience for Global & Local transfer 'Compensation' page, the recruiting assistant button is blocking the save button. Content (please ensure y…Bhuvaneswari Dharmaraj 14 views 2 comments 0 points Most recent by Bhuvaneswari Dharmaraj Compensation
-
BIP Report not retrieving data for single value in parameter, But same is working fine in DataModelSummary: BIP Report not retrieving any data when single value is selected in parameter, But the same is working fine in Data Model. Please help. Content (please ensure y…Mallikharjun Purilla-Oracle 22 views 2 comments 1 point Most recent by Hello123 Reporting and Analytics for HCM
-
Currency conversion rate not applied for monetary item in TCSThe currency conversion rate was expected to be applied to the equity data loaded through the external data screen in the TCS system. However, it appears that the system…Divyansh srivastava 1 view 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to alignment of text in TCS statement ?Summary: The text alignment in columns of TCS reports is inconsistent, with some columns using left alignment and others using right alignment. However, the alignment of…Divyansh srivastava 3 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
SQL to Get Grade and Grade and Grade Step details on a assignmentSummary: Hello Everyone, I'm new to SQL query building. Just getting hands on it. I am trying to create a Data model that will return salary detail including Grade and G…PRABHA_DEV 4.2K views 16 comments 0 points Most recent by Mohamed M. Faramawy-Oracle Reporting and Analytics for HCM
-
Annual salary not equal across different subject areasWe are having a problem with annual salary not being equal in Compensation - Salary Details Real Time and Compensation - Workforce Assignment Salary Real Time. It appear…
-
Employee job levelsSummary: Adding job level to employee report Content (please ensure you mask any confidential information): We have a requirement to show the employee job levels. When I…Ridma Karunanathan 59 views 4 comments 0 points Most recent by Ridma Karunanathan Reporting and Analytics for HCM
-
How to control the font size in TCS ?How to control the font size in TCS? The font size for the Total value in TCS is smaller than the font size used for tabular data.Divyansh srivastava 2 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI report for Average allocation by Rating is giving 'No Result; however working for managerSummary: We have created custom OTBI report to display the Rating v/s Average Allocation %. The OTBI dashboard is created and the report is added to the dashboard sectio…Shruthi T 32 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM