Compensation
Discussion List
-
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… -
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 10 views 4 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…
-
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 2 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 321 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 1 view 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 28 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 21 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 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
What is Grade and Performance Log Tables in HCM ModuleSummary: Is it possible to get Grade and Performance from Audit table. I need the who accessed the Grade and Performance data. Content (please ensure you mask any confid…
-
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…Wouter.Schaap 21 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Getting Person ID of the direct reportee from a comp page for which the Manager is viewing the dataSummary: On the Compensation Info page, we have a requirement to embed a report with additional compensation information details and when a manager tries to click and vi…Rini_Varghese-Oracle 11 views 2 comments 0 points Most recent by Rini_Varghese-Oracle Reporting and Analytics for HCM -
Workflow Notification addition to DM and BI template not showing up on UI page (ManageCompensation)Summary: Hi Forum: on a Redwood-enabled workflow notification, our additional JobCode field we added in Employee Details section of ManageCompensation report/DM does not…
-
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…TC 66 views 5 comments 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
Employees Missing in Compensation – Salary Details Real Time when using Matrix Manager FieldsSummary: Using Compensation – Salary Details Real Time , I’m experiencing an issue where employees drop from the report when matrix manager fields are added. For example…Mike Wulf 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Converting PW to EMP future installments switched to paid on start date instead of staged future datSummary: When converting PWK to EMP, if there are multiple future Sign On Bonus installments, all element entries from the PWK record are removed. Additionally, all inst…Madhuja Bhaumik 11 views 1 comment 0 points Most recent by Rakesh Ghosh-Oracle Payroll and Global Payroll Interface (GPI)
-
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 …HCM_Dot 121 views 12 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Area of Responsibility in Redwood Compensation pages (Salary History, Change Salary)Summary: Hi Experts, We recently enabled Redwood in our test instance and it appears that the AOR is no longer being applied to some of the Compensation pages like Salar…
-
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 …
-
Need SQL to extract Individual Compensation entries prior to approvalSummary: Need SQL to extract Individual Compensation entry values prior to Approval Content (please ensure you mask any confidential information): We need to report on I…SRIROU 99 views 5 comments 0 points Most recent by Prasad Singamaneni-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 Kondaveeti 5.3K views 11 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Rate in OTBI Report displays as double the amountSummary: Rate in OTBI Report displays as double the amount Content (required): I created an OTBI analysis report to display information related to the salary history qui…Nick Henderson 121 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Query to retrieve employees with Termination Date nullSummary: Content (please ensure you mask any confidential information): Hello experts, please, could you share a query to retrieve employees without past and future actu…Valerio Curzi 71 views 6 comments 0 points Most recent by Ashraya S.N Reporting and Analytics for HCM -
Historic values for pay_bank_accounts tableSummary: Historic values for pay_bank_accounts table Content (please ensure you mask any confidential information): This table has MASKED_IBAN field but when I change it…Stefano_Mazzocca 11 views 0 comments 0 points Started by Stefano_Mazzocca 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…
-
FTE and salary doubling on union querySummary: Complex union query. Reports work find individually but union is doubling up FTE and salaries for some records (not all). Content (please ensure you mask any co…LTalbott2 22 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Compensation - Indvidual compensation real time not showing any detailsDespite of having the necessary roles I still don't have access to show data from this subject area I added everything from this document, Document 3052888.1 but still, …Joliver Caangay 22 views 4 comments 0 points Most recent by Joliver Caangay Reporting and Analytics for HCM
-
Cannot get specific element entry values from XML data cache column for pending transactionSummary: We are not able to get the accurate element entry value from XML data cache element entry rows data , we are only fetching values if they have in element entrie…Kaustubh Deshmukh 3 views 1 comment 0 points Most recent by Soumya Suravita Reporting and Analytics for HCM
-
OTBI Report shows wrong annualized salary and annualized full-time salarySummary: OTBI Report shows wrong annualized salary and annualized full-time salary Navigation Tools Reports and Analytics Catalog Created OTBI report based on "Compensat…Vincent T 21 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM