Compensation
Discussion List
-
How to compare Salary Minimum to Grade Rate MinimumSummary: I have an Analyses that uses Compensation - Salary Details Real Time and Workforce Management - Grade Rate Real Time subject areas. The requirement is to compar…JHaden3 14 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Query to extract the last effective start date record for payroll elementSummary: Content (required): Hello experts, Please, could you share the SQL query to extract the effective start date loaded for a specific element in the employee compe…Valerio Curzi 34 views 1 comment 0 points Most recent by Mandeep Gupta Reporting and Analytics for HCM -
OTBI report not fetching data while using columns from Comp manager / Comp worksheet manager foldersOTBI report built using "Workforce Compensation Budget Real Time Details " subject area is not fetching any results. Hello there, We have a requirement to build a Countr…Gudupu, Jaswanth Sai 45 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Annualized Salary for terminated employeesSummary: I wanted to create an analysis to get terminated employees annualized salary. Content (required): I used compensation salary history details real time object an…Ayesha Iroshani 34 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Tree Name Criteria Dropping out International & Non-EmployeesSummary: Hi - I am creating a report with a number of different fields pulling from the following subject areas: When I have all of my criteria EXCEPT for the tree name,…Kyle Norris 24 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report to view workflow configuration in Fusion HCMSummary Report to view workflow configuration in Fusion HCMContent In Fusion HCM, we navigate to 'setup and maintenance' > 'Manage approvals for Human Capital Management…
-
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…Shubham Shree 54 views 5 comments 0 points Most recent by Abhishek Dixit-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…Shubham Shree 54 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Employee Roster Report using subject area-Compensation Real TimeSummary: We are in need of an employee roster report built off of the Compensation-Real Time subject area, but to pull the grade and range from the Job Details area, ins…Tammy Hemmingson 34 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
FAST FORMULA PER_PERIODS_OF_sERVICE ATTRIBUTE_DATE1 DBII want to find the database item that the Attribute_date1 field in the per_periods_of_service table corresponds to for use in the Fast formula, but I couldn't find it. C…
-
OTBI:Individual Comp: Single row with Award Amount and Frequency in spite of data model constraints1- Below OTBI report has been built using "Compensation - Individual Compensation Real Time". It provides insights into the Awards awarded to an employee and the frequen…Abhishek Dixit-Oracle 46 views 2 comments 2 points Most recent by Sahithi Kolasani-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… -
Compensation Eligibility StatusSummary: Content (required): Hello everyone, I'm currently trying to create a Value Set that will get me the Compensation Plan ID and the Compensation Eligibility Status…Maria Xydopoulou 45 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Finding Reporting Fields - Compensation ModuleContent Hi all - my reporting team is working on finding some fields within our Compensation Module and are unsure how to best located them. For example, we are provided…Prudence K 96 views 9 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
CMP_PERS.CUSTOM_SEGMENT7 Oracle HCM table nameSummary: Content (required): Hello experts, in which Oracle HCM table can I find the attribute CMP_PERS.CUSTOM_SEGMENT7? Thanks in advance for your time! Kind Regards, V…Valerio Curzi 24 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Current performance calibration and overall target OTBISummary: Content (required): Hello everyone, We are having issues with an OTBI related to the performance dashboard for the Manager. In particular, the otbi "Current per…Gerardo Peluso 34 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
salary formatted in rtf templateSummary: Hi everyone, We are customizing compensation letters for a client. We are having problems formatting the amount field for a certain bonus that should be paid to…Gerardo Peluso 66 views 2 comments 0 points Most recent by HarishVummidi Reporting and Analytics for HCM
-
California Pay Data Reporting UpdateSummary: The California pay data reporting requirement is getting updated. Is Oracle developing an update to the delivered report to account for this? Content: Existing …
-
Why do some fields break a report in OTBI?Summary: trying to create a census report with fields from multiple subject areas and many fields work together but certain fields break the report Content (required): I…Monique Dias 54 views 8 comments 0 points Most recent by Monique Dias Reporting and Analytics for HCM
-
Succession Permission AuditSummary Succession Permission Audit ReportContent Is it possible in Oracle HCM to create a report showing all plans, and the individuals who have Succession permission f…
-
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 65 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 56 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 4 views 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 34 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 84 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Compensation Plan Worksheet with notesSummary: I have created a report to pull compensation worksheet with notes. I am facing the following issues: 1) It only picks up employees with Notes. I need to pull th…
-
Report that shows job requisition salary vs job offer salary.Hello I am trying to pull together a report that compares the requisition salary and the job offer salary filtering only on requisitions that are filled. I am unable to …Dorothy Leong 64 views 7 comments 0 points Most recent by Dorothy Leong 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 44 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 46 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…