Compensation
Discussion List
-
Workforce Compensation BI Publisher Add Ins not functioning for Word or ExcelSummary: MSWord & MSExcel - BI Publisher Add Ins no longer functioning. Have uninstalled, reinstalled. Still not functioning. Content (please ensure you mask any confide…Lisa O'Kelley 14 views 2 comments 0 points Most recent by Lisa O'Kelley Reporting and Analytics for HCM -
How to disable the download option of Increment Letter posted in DORSummary: We have requirement to post the Increment letter from custom BIP via extract to post in the DOR of employee. However we would like to have the option of downloa…Shruthi T 40 views 3 comments 2 points Most recent by Adarsrs-Oracle Reporting and Analytics for HCM
-
EU Pay Transparency Report Startup PackSummary: In webinar it was told that oracle has Startup packs for Reporting, How we can get them? Pay Transparency Webinar - Oracle Video Hub Content (please ensure you …Ilmars K. 22 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
EU Pay transparancySummary: We looking for a report to analyze the pay transparance between genders as requested by EU. Has anyone seen or created a report showing variances in payment per…
-
Poor Query Performance of CMP_ASG_SALARY_VSummary: A simple query on this view runs 40+ minutes. We are experiencing poor performance with the CMP_ASG_SALARY_V HCM view. When doing a simple SELECT statement with…
-
BI tables for standard compensation plan columns regarding salarySummary: Content (please ensure you mask any confidential information): Hello experts, which BI tables store the following standard compensation plan column fields? New …Valerio Curzi 31 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
SQL code to fetch Overtime, bonus, commissions, merit increases, and locality pay for employeesSummary: Hi Experts, Please provide the SQL code to fetch overtime, bonus, commissions, merit increases, and locality pay for employees. Thanks. Content (please ensure y…
-
How to fetch data from transaction console table for ICP entry which is not approved ?We are trying to fetch details of ICPs which are in submitted status(not yet approved).The details which we are trying fetch is person details, ICP type, option , date w…
-
how to calculate average percentage of Budget Utilization in workforce compensation module?Summary: My requirement is to find out the average percentage of Budget Utilization in workforce compensation module. How can I derive that? Content (please ensure you m…Pritha 18 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Headcount and salary report with as of date using Workforce Assignment Salary History Real TimeSummary: Objective: To create an analysis with headcount (aka assignment) and salary data. Issue summary: We believe [Compensation - Workforce Assignment Salary History …bwdata 75 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
We Need a table for the Configure Worksheet Display -Detail Table in Workforce compensation planSummary: Hi, We Need a table for the below highlighted fields under the Configure Worksheet Display -Detail Table in Workforce compensation plan Content (please ensure y…
-
write a sql query to fetch average cycle time for each compensation planSummary: write a sql query to fetch average cycle time for each compensation plan Content (please ensure you mask any confidential information): write a sql query to fet…Pritha 14 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI Dashboard passing prompts with url link.Hi, I am creating a OTBI dashboard and i want to generate a link with an url which would be passed through tthe prompt directly. i tried this link but it did not work…MYassikaya 22 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
No results if no filter is appliedSummary: Hi, We have an HR role with access to a compensation OTBI report. In order for the results to be displayed, HR must filter by at least one BU. However, if I ass…
-
BI Report for compensation budgetSummary: I need to develop a report with compensation budget aggregated by country. Content: In a BI report (I can't use OTBI) I need to show the following data: Country…Gian Luca Triglia 10 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Tables Name to Access to the employee's Compensation historySummary: Tables Name to Access to the employee's Compensation history Content (please ensure you mask any confidential information): Hi, we are looking for the tables wh…Barile Alberto 27 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Need SQL query or table to get Worker details column under configure worksheet page layout.Summary: Hi, Need SQL query or table to get Worker details column under configure worksheet page layout in compensation We need the table where these highlighted(Yellow,…
-
SQL query or Table for Allocation Methods under Configure Modeling in CompensationSummary: I need a table or SQL query to get Allocation Methods under Configure Modeling in Compensation. Table for below fields in highlighted box. Content (please ensur…
-
Required Table or SQL query to get Criteria under Manage Statement Groups in Workforce compensationSummary: Hi, We are stuck to get the details for Criteria details under Manage Statement Groups in Workforce compensation plan in Compensation Module. Please help us to …Opkey PA 18 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
SQL query or Table for Dynamic Columns data under Configure Assignment Segments in CompensationSummary: Hi, We could not find the tables name or query for Dynamic Columns data under Configure Assignment Segments in Worforce Compensation plan What is the table name…Opkey PA 24 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Custom Budget Report - Hierarchy LevelHi, We're creating a custom budget report to convert the currency values according to the user preference. But when capturing the Hierarchy Level column with a manager t…Khel 17 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
We Need a table for the Default Values Configure Worksheet Display -Detail TableSummary: Hi We need a table for the below fields under Configure Worksheet Display -Detail Table in workforce compensation plan Content (please ensure you mask any confi…Opkey PA 29 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Looking for Employee Salary and STIP report either OTBI or BIP report sql.Summary: I am looking for a report that would capture every salary and STIP eligibility percentage an employee had during the course of a year. For some employees, that …
-
Sample Report: Workforce Compensation Market CompositesSummary: Sample report showing how you can report on market composites within Compensation - Workforce Compensation Real Time Content (please ensure you mask any confide…Gail Langendorf-Oracle 21 views 0 comments 0 points Started by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Sample Report: Workforce Compensation Budget Subject AreaSummary Workforce Compensation Budget Subject Area by levelContent Workforce Compensation Budget Subject AreaThis is part of a series of sample reports to use in your cl…Gail Langendorf-Oracle 381 views 15 comments 2 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
HOW TO GET ELIGIBILITY PROFILE Name in compensation through querySummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…User_RTHRD 8 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
[nQSError: 60009] The user request exceeded the maximum query governing execution time.Hi All, We have an OTBI report ,with "payroll-Element Entries history real time" subject area, when user run the report with date parameter they get the following error.…Sushant95-Oracle 134 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Reports under Workforce Compensation planSummary: Hello experts, Please let me know where can I find the details of delivered reports available under Workforce Compensation and related data models. Thanks, Cont…Vaishnavi Agrawal 33 views 6 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
OTBI Report shows wrong annualized salary and annualized full-time salaryOTBI Report shows wrong annualized salary and annualized full-time salary Navigation Tools Reports and Analytics Catalog Created OTBI report based on "Compensation - Sal…Kiran Devraj-Oracle 18 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM