Compensation
Discussion List
-
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 295 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 343 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 76 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 52 views 7 comments 0 points Most recent by Santhosh Kumar 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…Sovan Mishra-Oracle 1.1K 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 42 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Analysis from Compensation - Salary details real time returns double the annual salarySummary: While creating analysis from Compensation - Salary details real time, the report returns double the amount of the annual salary for few employees. Have anyone e…Hem 43 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
HCM User Interface to OTBI Subject Area MappingSummary: Hi all, I am always grateful to the invaluable assistance, insight and support of the customer connect community. I have no idea if this will be of use and this…User_2025-02-11-05-19-35-410 32 views 1 comment 3 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Compensation Zones in OTBISummary Is it possible to report on compensation zone configuration in OTBIContent Is it possible to pull compensation zone information into an OTBI analysis? Based on t…Anton Rzhanov 72 views 8 comments 0 points Most recent by Anton Rzhanov Reporting and Analytics for HCM
-
OTBI Analysis takes about 20 minutes to return results, how to improve performance?Summary: OTBI Analysis for Master Headcount Report takes 20 minutes to display results. Content (required): Our client is migrating from EBS to HCM Cloud. Currently they…Vinay Hardas 64 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Not getting any data when opening the reportSummary: Content (required): Hi Expert, We have built a report and it is an Individual Compensation report, I have all the roles but when I am assigning payroll admin an…Faizan Rashid 31 views 11 comments 0 points Most recent by Faizan Rashid Reporting and Analytics for HCM -
OTBI reports to replicate delivered reports in Workforce Compensation > Pay for PerformanceSummary: Workaround solution following 21D release "improvement" Content (required): It has been decided by Oracle to disable reports in order to improve the performance…Amandine C-Oracle 32 views 1 comment 2 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Workforce Compensation Page Parameters for EL ExpressionsContent Hello experts, is there an Oracle official documentation which can allow me to have all compensation module parameters (i.e. ManagerId; PlanId; etc.) in order to…Valerio Curzi 32 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to find 'User Defined Column' within Compensation PlanSummary: Can anyone help locate this field within a Compensation Plan. I need to find "Numeric Column 18", preferably within a Subject Area or if it's only within a tabl…Andrew_Schmitz 33 views 5 comments 1 point Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
Average Salary for Job over TimeSummary: Need average salary for a job code over time Content (required): Is it possible to look at average salary for a job code month over month? Version (include the …Riti Malhotra 21 views 12 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Termination Report Unable to Pull In SalariesSummary Trying to pull a historical report of terminations in a certain location with salary amount at time of termContent Hi - I have looked into a number of posts rega…Kyle Norris 64 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Privileges required to open Payroll Element Entries - Real Time subject areaSummary: Hello experts, do you know the privileges required to open Payroll Element Entries - Real Time subject area? Thanks in advance for your time! Kind Regards, Vale…Valerio Curzi 12 views 3 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Top 10 Percent PaidSummary Need to pull the top 10% paid US staff Content Hi, I need to create a query that shows me my top 10% paid staff. The legal definition is: "In determining which e…user6284475 32 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Seeded Data Model and Report For Grade Step ProgressionSummary Seeded Data Model and Report For Grade Step ProgressionContent Hi Team, Where do get the Seeded Data Model and Report for activity 'Grade Step Progression' scree…User_2025-02-01-03-43-13-079 112 views 13 comments 0 points Most recent by Vijay Gorania Reporting and Analytics for HCM
-
Where do we define additional Manager detailsSummary: Hi Everyone, I am trying to find out where can we define Manager details in Assignment screen. Attaching screenshot for referencce. Content (required): Version … -
Termed employee report with both Manager hierarchy AND final salarySummary: Has anyone written an OTBI report to pull termed employees and include both Manager hierarchy AND also final salary? Content (required): Has anyone written an O…User_2025-02-04-15-06-22-759 23 views 1 comment 3 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Fast formula - Oracle functionsContent Hi guys, I need to export a value from lookup tables through fast formula. Usually, I used the get_lookup_meaning function but this time I don't need the meaning…User_2025-01-28-21-18-09-074 116 views 1 comment 0 points Most recent by Pragati-Oracle Reporting and Analytics for HCM
-
how to sum two condition in e-text template on oracle fusion hcmSummary: When we add all 4 fields the output of the report comes blank. I am able to add Shift Pay+Incentive+Current Salary the output appears but when i add Lead Pay (w…
-
Salary & Assignment Changes JoinedSummary Report that pulls Salary and Assignment Changes Joined TogetherContent Hi all, Has anyone created a report that pulls both Salary and Assignment Changes joined t…User_2025-01-31-00-25-12-234 107 views 5 comments 2 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM
-
How to display the thousands separator point in the BI extraction tables for pay elements and goalsSummary How to display the thousands separator point in the BI extraction tables for pay elements and goalsContent Hi, We are experiencing an anomalous behavior. I enter…Alberto Barile 18 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Seeded Report Location for Worksheet ExportSummary Looking for seeded report location for Worksheet Export under compensation module.Content Hello Everyone, Does anyone know how to find the seeded report location…
-
Need details on right place to get each salary component exact value but not adjustmentSummary Need details on right place to get each salary component exact value but not adjustmentContent In current configuration, monthly salary basis is configured with …
-
Compensation Components table for BIContent Hello experts, do you know the Oracle tables to extract compensation components values and components name? Thanks in advance for your time! Kind Regards, ValerioValerio Curzi 36 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM