Compensation
Discussion List
-
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… -
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 17 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…
-
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 31 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 21 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 137 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…
-
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 204 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 6K 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 140 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 94 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 18 views 0 comments 0 points Started by Stefano_Mazzocca Reporting and Analytics for HCM -
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…LynneLBL 27 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 26 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 12 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 28 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Add custom logo in a Workflow NotificationHi, I customize the RTF of CmpWkstApproval Notification. I add an image in the RTF, the image is visible when i run the report but the image is not visible when the noti…Camilla Crescenzi 105 views 4 comments 0 points Most recent by AP0410 Reporting and Analytics for HCM
-
FTE in Compensation Subject Area is not correctSummary FTE value is showing 5 instead of 1Content Hi All, I need your help. I am getting two different values for FTE in OTBI. One comes from Compensation Subject Area …Alvaro Couto 47 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Annualized Full-Time Salary the same value as Annualized Salary for those with <1.0 FTESummary: Within the Compensation - Salary Details Real Time there is an option to pull in both the Annualized Salary and Annualized Full-Time Salary. When checking this …
-
How do we get the Pay Period Month , Year , Max Gross Pay MTD in OTBISummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Is There a Delivered Bonus Statement Feature in Oracle Incentive Compensation?Summary: Is there a similar feature or functionality in Oracle Incentive Compensation for generating a Bonus Details Statement? Currently, we are using a BI Publisher (B…
-
Is the Ranking field in a workforce compensation plan available for reporting (OTBI)?Summary: I don't see this field but wanted to confirm if the Ranking field in a workforce compensation plan is available in OTBI or not? And if not, anyone know why it h…Cathy 18 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Point in Time Headcount with Salary report - isolated doubling of salarySummary Our "point in time" report is mostly working. For a very small percentage, the salary amount is being doubledContent We have a report that is working fairly well…Cheryl Burwell 115 views 7 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM -
how to delete status processing rule using hdlSummary:How to delete status processing rule using hdl Content (please ensure you mask any confidential information): Version (include the version you are using, if appl…
-
Unable to see terminated employee's View Compensation HistorySummary: I am unable to view the compensation history for terminated employees. Is this standard functionality and behavior in Oracle HCM Cloud? Could anyone help clarif… -
Cannot open OTBI Report Workforce Compensation subject areaSummary: Content (please ensure you mask any confidential information): Hello experts, when opening the attached OTBI report the system doesn't return any value. However…Valerio Curzi 15 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Audit Trial for Workforce Compensation Approval taskSummary: Content (please ensure you mask any confidential information): Hello experts, when approving compensation plan (Approval task) the name of the last approver alw…
-
ELIGIBLE WORKERS FOR COMPENSATIONSummary: How can I extract the list of workers that concur to determine the number of eligible in the fields ELIG_COUNT_DIRECT of CMP_CWB_SUMMARY table?Gian Luca Triglia 16 views 1 comment 0 points Most recent by Gian Luca Triglia Reporting and Analytics for HCM
-
how to display salaries in arabic words in salary certificate?Summary: In salary certificate we display salaries in English and Arabic. For English we are using below code in template. For eg: For Arabic: In arabic…Deepthi Rai Mohandas 55 views 2 comments 0 points Most recent by Sahil Kathuria Reporting and Analytics for HCM
-
Tables to pull the data for the eligibility profiles under compensation profile usage.Hello Team, The requirement is to pull the data for the eligibility profiles under compensation profile usage which are assigned to grade ladder. Please suggest the tabl…Saurabh_Mharolkar 70 views 15 comments 0 points Most recent by NinaF Reporting and Analytics for HCM