Compensation
Discussion List
-
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… -
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 12 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 127 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 51 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 K 4.7K 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 111 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 62 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 21 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 21 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 1 view 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 12 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 82 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 41 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 11 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 109 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 11 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 11 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 41 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 53 views 15 comments 0 points Most recent by NinaF Reporting and Analytics for HCM
-
generate statement custom field values not picking from rtf templateSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…karthies 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM