Compensation
Discussion List
-
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 …Gail Langendorf-Oracle 60 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 2 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need to pass real time binding parameter dynamically to OTBI Reports.Summary: I have created OTBI Analysis report based on the Compensation -Workforce Compensation Real Time subject area. I have attached my OTBI report to View report sect…DHarry 22 views 6 comments 0 points Most recent by Gail Langendorf-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 35 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 22 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 12 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Table names/SQL query for Individual Compensation details in HCMSummary: Hi All, Can you please share me the Table names/SQL query for Individual Compensation details in HCM. Thanks, Janardhana Content (required): Version (include th…Janardhana K 380 views 1 comment 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…Prabhakar Devineni 422 views 3 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 33 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 2 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 12 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 Maciel 2 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 12 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Subject area for user defined columns under worksheet display (Compensation)Summary: Hi everyone - We have some criteria defined under one of our compensation plans in a user-defined column for the worksheet. The user defined column contains the…
-
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 L Feyerherm 32 views 10 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How does your organization use Oracle to comply with the MN Wage Theft law?Summary: My organization is in the process of implementing Oracle and we’d like to understand if other MN-based organizations have a process in place related to MN Wage …Tammi Desens 2 views 0 comments 1 point Started by Tammi Desens Payroll and Global Payroll Interface (GPI)
-
How does your organization use Oracle to comply with the MN Wage Theft law?Summary: My organization is in the process of implementing Oracle and we’d like to understand if other MN-based organizations have a process in place related to MN Wage …
-
release statement to workerSummary: We would like to report on the field " release statement to worker" to check how many Line Managers have enabled this for their direct reports once comp cycle i…Manoj B. Cheruvathoor 2 views 2 comments 0 points Most recent by Manoj B. Cheruvathoor Reporting and Analytics for HCM
-
Is there a compensation event real time subject area similar to worker assignment event real time?Summary: Is there a compensation event real time subject area similar to worker assignment event real time? Content (required): We created a report using the worker assi…TerryM01 12 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Change LOV in Comp dashboardSummary: I am looking to add a LOV in the dropdown box for Out of the box dashboards available for managers under workforce compensation Content (required): Need to add …Manoj B. Cheruvathoor 12 views 2 comments 0 points Most recent by Manoj B. Cheruvathoor 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" …
-
SQL for Costing for ElementsSummary: We are working on SQL to fetch the Element Entry details with costing information. I am finding it difficult to fetch the costing information from the Element E…Mohan Murali 12 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Looking for a YTD payroll reportSummary: I need to create a report showing YTD payroll. Content (required): Report needs to contain employee demographic detail along with current pay rate, YTD earnings…Scott Conaway 58 views 2 comments 0 points Most recent by Scott Conaway Reporting and Analytics for HCM
-
Administration ReportsContent Hi - I have a business requirement to change some of the columns/fields/filters int he Administration Reports in My Workforce > Compensation. For example, on the…Prudence K 44 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Individual Compensation ReportSummary: We are using individual compensation plans to process additional overtime for the employee with defined approvals but approvers wanted to see analytics before t…Santhosh Kumar 2 views 8 comments 0 points Most recent by Santhosh Kumar Reporting and Analytics for HCM
-
How can I pull a terminated employee's last annual salary into an OTBI report?Summary: Terminated Employees salary is not returning the expected amount. Content (required): I'm trying to create an OTBI report to use for balancing my payroll. One o…Sheri Curtis 43 views 4 comments 1 point Most recent by Sheri Curtis Reporting and Analytics for HCM
-
OTBI to fetch vacant and filled positionsSummary: We have a requirement to create an OTBI report which will fetch position details alongwith Employees present in those positions. Besides that, we also want to f…User_Z94P0 116 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to Fetch Employee level details from comp worksheet and budget details in an OTBI reportSummary: We have a requirement to fetch comp worksheet details (i.e. Manager Recommendation amount based on department VS Budget Amount allocated for the employee manage…User_EJ1U2 12 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM