Compensation
Discussion List
-
Compensation Details (Top of Stack) when End DatedSummary: Hi - We are looking to create a report where we are able to audit active employees where their salary was incorrectly end dated. The problem is that when the sa…Kyle Norris 71 views 1 comment 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
BI Tables for compensation planSummary: Content (required): Hello experts, do you know which BI tables allows me to extract workforce compensation plan data? Thanks in advance for your time! Kind Rega…Valerio Curzi 51 views 6 comments 0 points Most recent by Valerio Curzi Reporting and Analytics for HCM -
Is it possible to retrieve compensation component amounts entered in closed compensation campaigns?Summary: Content (required): Hello experts, our customer wants to add in compensation plan some columns retrieving compensation amounts entered in past campaigns. Is it …Valerio Curzi 1 view 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How do I suppress trailing zeros in my RTF template for comp statementSummary: How do I suppress trailing zeros in my RTF template for comp statement Content (required): I have tried both ’999.999999’ and ’D999999’. If a number has 6 decim…TerryM01 31 views 2 comments 0 points Most recent by Indra Sardana-Oracle Reporting and Analytics for HCM -
Salary Range Report ALL Jobs (Active and Inactive)Summary: I have a requirement to produce the below OTBI report but if I use the Compensation Salary Detail Real Time, it only shows data if an employee is assigned to th…JHaden3 101 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Reporting on ICD/Manage Personal Contribution Requests that have been SavedSummary: Content (required): We use Individual Compensation Distributions for our employees to claim for irregular payments (overtime worked etc.) as we are not yet usin…Leanne W 41 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Table and field references for compensation manager hierarchySummary: Content (required): Hello experts, for this compensation campaign we should change the manager hierarchy workflow and we set the primary hierarchy as in the att…Valerio Curzi 51 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Need A Dynamic way of setting Date Parameters to begin with the 01st AprilSummary: Hi, I need to schedule an OTBI report that looks at changes made to a salary from the 01st April to the last day of the previous month. For example the report s…
-
Is it possible to build workforce compensation approval workflow by OTBI or BI?Summary: Hello experts, our customer would like to represent the workforce compensation approval workflow by report. Do you know if it is possible to do it by OTBI or BI…Valerio Curzi 21 views 4 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
SQL for compa ratioSummary: Need correct SQL to find Compa Ratio Content (required): Hello, I am writing a report for the business that includes the compa ratio as one of the columns. And …SeanWesche 51 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Looking for table for salary change action and reasonSummary: Looking for table for salary change action and reason Content (required): Which table holds the salary change reason and action? This is not the same table whic…Parag Hiremath 761 views 7 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
Restrict Participation in Another Plan Fast FormulaSummary: Content (required): Hello everyone, I'm currently trying to create a Fast Formula that will restrict population's eligibility for Compensation Plan B if they ar…Maria Xydopoulou 31 views 0 comments 0 points Started by Maria Xydopoulou Reporting and Analytics for HCM -
Compensation Amount (Filtered by Team) field OTBI Subject Area in CompensationSummary Compensation Amount (Filtered by Team) field OTBI Subject Area in CompensationContent Hi All, Could you please suggest in which Subject Area/Attribute or BIP tab…
-
Reports - Page options available to the user environment?Hello, I have been asked to find a way to make available the page options of the analytics to the Reports tab. To be more specific, we need the gear icon from the analyt…Ioannis Adamou 51 views 6 comments 1 point Most recent by Ioannis Adamou Reporting and Analytics for HCM
-
Hourly Rate FormulaSummary: I have a report using the subject area Compensation – Salary Details Real Time and need to add a formula that calculates a base hourly rate. Here is what I'm lo…JHaden3 101 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Most recent salary record (Active and Termed)Summary: I have a report using the subject area Compensation – Salary History Details Real Time. I need the report to display only the most recent salary record for both…
-
Create Individual Compensation History reportSummary: I need to create a report of historical individual comp data, to include only additional comp like bonuses and such - No regular salary needed. I’d prefer to do…
-
What table are the 'Performance Rating' values in the Workforce Compensation worksheet stored?Hi All, I'd like to know if where are the values of 'Current Performance Rating' (highlighted below) is coming from? Thanks!notautomni9 41 views 1 comment 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for HCM -
restrict salary report by security profileSummary: We created a security profile for salary access based on department hierarchy (secured by aor) and assigned this security profile to specific custom roles. In t… -
How to paste or copy an XML; How to Edit an Existing Analysis in a DashboardSummary Explains how to paste an XML Content 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 su…Gail Langendorf-Oracle 79 views 2 comments 4 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Hours and WagesSummary: FEMA Reporting Needs Content (required): Hello! Is anyone familiar with a subject area that I would be able to get wage and hour information for a given period …Liz McAllister 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Query to get statement of earningsSummary: Can someone share query to get all the balances on statement of earnings screen along with its element and values. I wrote a where I am getting the expected val…Jaeyshree Kumaran Kalpana 261 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
How can I display talent information with job, salary informationSummary: I need to pull current job code and title, salary, salary grade for associates and combine it with their most recent talent meeting results (i.e., date of meeti…Wendy Dayton 51 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to create custom deeplink in oracle cloud hcm ?Summary: Content (required): Hello Dears , We are looking for custom deeplinks and we need to know if that applicable to create or not ? Thank You. Version (include the …Nariman Moussa 81 views 2 comments 0 points Most recent by Gail Langendorf-Oracle 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…Kyle Norris 81 views 15 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Creating analysis using user defined fields in Workforce CompWe are trying to create some reports using the Compensation-Workforce Compensation Real Time subject area and was under the impression this subject area would pull data …Jamie_B 11 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Need to get the latest Salary fromSummary: I need to get the latest salary for all employees who have left. Content (required): I am using the Compensation - Salary History Details Real Time subject area…GJ79 31 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to create a report for worker and theirs Individual CompensationSummary: Im trying to create a report to follow individual compensations for workers, but using the subject area i couldnt create any report, when combine the worker fou…Lucas B Maciel 11 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
FTE and Salary - Compensation Salary Details Real Time Subject areaSummary: The FTE and Annualized Full Time Salary appear to be sourcing the FTE from the Assignment instead of the Salary row Content (required): I'm digging into an erro…Rob F 41 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM