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 817 views 9 comments 0 points Most recent by Gail Langendorf-Oracle 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 104 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
-
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 13 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 45 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 1 view 1 comment 0 points Most recent by Gail Langendorf-Oracle 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…
-
Can we use the tool in Production to migrate personalizations? If not, why?Summary: Came across one of the FAQs where it was mentioned - "You should not use the tool directly in Production to migrate personalizations. This tool is expected to b…Nishnt 11 views 1 comment 0 points Most recent by Vijay Shanmugam-Oracle HCM Redwood Personalization Helper Tool
-
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 75 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 15 views 1 comment 2 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Unable to find Salary related fields in Redwood VBSSummary: Currently our Redwood customizations are deployed on Dev11 which is on 24D release. We are trying to configure a few fields on the Compensation Info & My Compen…MKS_1311 42 views 2 comments 1 point Most recent by Andreea_Nuck-Oracle Visual Builder Studio 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 268 views 0 comments 0 points Most recent 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 1 view 0 comments 0 points Most recent 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 944 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 -
How to hide Grade Ladder and Grade Step from My Compensation Redwood pageSummary: We need to hide the Grade Ladder and Grade Steps from the My Compensation page using Visual Builder. But it is still showing in the Preview and After Publishing…
-
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 11 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 31 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 1 view 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM