Compensation
Discussion List
-
How can I pull a terminated employee's last annual salary into an OTBI report?Summary: Terminated Employees salary is not returning the expected amount. Content (required): I'm trying to create an OTBI report to use for balancing my payroll. One o…Sheri Curtis 481 views 8 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
hide an RTF hyperlink field on notification report conditionallySummary: Hi forum and BI Publisher Experts: i wish to hide a URL hyperlink only when ( 2 ) previous data model person number values (will not be shown on report) are equ… -
HCM report for monitoring access visibilityHi All, As a part of Executive and above (10,000+ employees) salary migration to the Fusion system, we are planning to introduce controls on salary visibility and access…Sachini 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Different Grade Rates as per CitySummary: Hi All, We have a requirement to have multiple grade rates for single legislation. Example: For China we have different grade rate, China- Beijing and China- Sh…Ankush_Arya 1 view 1 comment 0 points Most recent by Danny Cusnir-Oracle HCM Experience Design Studio: Autocomplete Rules -
Object Validation Rule for Salary Adjustment Percentage not supporting as expected.Summary: Object validation rule for Salary business object is triggering for conditions where Salary.Adjustment Percentage should generate error message. Condition is se…Gaurav Bhagwandas Bhojwani 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Preset Salary Basis components for each Salary BasisSummary: Hello, We've got a requirement to preset a constant values for each component of each Salary Basis, e.g. we have Salary Basis X1, X2, X3; each one of them have … -
OTBI Element Type Setup report with Costing not showing data if the element is not costedSummary: Hello. I'm trying to report on Element Type Setup with Costing details on OTBI using the "payroll - element enteries history real time" subject area. The report…Laura_Stewart_Sita 33 views 4 comments 0 points Most recent by Laura_Stewart_Sita Reporting and Analytics for HCM -
Validation message in Salary section for Change Salary is not workingSummary: Validation message in Salary section for Change Salary is not working Content (please ensure you mask any confidential information): Version (include the versio…Mridula Mitra Pal 11 views 0 comments 0 points Most recent by Mridula Mitra Pal Visual Builder Studio for HCM -
release statement to workerSummary: We would like to report on the field " release statement to worker" to check how many Line Managers have enabled this for their direct reports once comp cycle i…Manoj B. Cheruvathoor 1 view 3 comments 0 points Most recent by Saliha MAACHA Reporting and Analytics for HCM -
Way to hide hyperlink on Workflow Notification / BIP RTF template based on Security Role?Summary: My customer wants to have me hide a "View Attachments" hyperlink on a DoR notification (BI Pub - RTF template) based on specific AoR role. I don't see how to pi… -
Recurring Payments History - How to remove link from Start Date?Summary: Our purpose is to remove the link that we can see on the Start Date field on Recurring Payments History. Content (please ensure you mask any confidential inform…Giuseppe Casalino 1 view 0 comments 0 points Most recent by Giuseppe Casalino Visual Builder Studio for HCM -
Compensation - Access Level AuditSummary: Need to know how we can check who has changed the access level Content (please ensure you mask any confidential information): Line Manager » Workforce Compensat…ArunSolanki18 11 views 1 comment 0 points Most recent by Matt Houser Reporting and Analytics for HCM -
OTBI Analysis Report is not giving Salary Information as expectedWhen we are running the OTBI report, the salary information for the terminated employees is not displaying as expected, and for a few employees, salary details are getti…Paul D 101 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
salary formatted in rtf templateSummary: Hi everyone, We are customizing compensation letters for a client. We are having problems formatting the amount field for a certain bonus that should be paid to…Gerardo Peluso 141 views 3 comments 0 points Most recent by Chris O-Oracle Reporting and Analytics for HCM -
How to fetch CURRENT and PREVIOUS Salary using BIP?I need columns to compare the CURRENT and the PREVIOUS salary of employees in 1 row only. How to construct the BIP report using SQL?Welsey 812 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Is it possible to report on Workforce Compensation Change Statement Volumes executed by managers?Summary: We have our Compensation Change statements configured to Printed and delivered by managers, we would like to monitor and report on how many managers are accessi…Adam_Cantwell 11 views 1 comment 0 points Most recent by Adam_Cantwell Reporting and Analytics for HCM -
How to display column label values dynamically in a Matrix report using BI PublisherHi, We have a Matrix report requirement using BI Publisher where we need to bring across the row and column label values dynamically (as values are not constant) as per …Tejashree S 101 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Transfer Workforce Compensation to Payroll - element entry reason for Bonus element?Summary: In the compensation module in either the workforce compensation plan or in the transfer to Payroll process, is there a way to populate the reason field to show … -
Which Table Holds "Access level" From The Compensation Worksheet ?Summary: SQL query to fetch Access Level in report. Content (please ensure you mask any confidential information): I need to fetch "Access level" From The Compensation W…Tamseel Aijaz 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Create Report to Include Sign On Bonus from Offer LetterSummary: I have an analysis report that list candidates that we had hired. However, I need to add Sign On Bonus amount into the report. I found the "Other Compensation" … -
HCM table to fetch eligibility status of compensation plan.Looking for HCM table to fetch eligibility status of compensation plan as "Eligible" or "Limited".Tamseel Aijaz 11 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Progression Ladder for a bi_query_reportSummary: how to join rates to per_grade_ladder_f and per_grade_steps_f for a bi_query_report to show Progression Ladder > Grades that belong to Ladder > Steps in Grade >… -
BI tables to retrieve Compensation Plan Status and track compensation plan approval flowSummary: Content (please ensure you mask any confidential information): Hello experts, we need to track manager compensation plan status (i.e Submitted; Work In Progress…Valerio Curzi 41 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to pull data from Additional Compensation in BIP ReportsHello Experts, Does anyone know how to or who has available SQL to fetch these data from Additional Compensation ThanksJoliver Caangay 1 view 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
ICP start date in fast formulaSummary: How to restrict start date in ICP page. We want to restrict employee entering the back dated changes for their pension contributions. Have any one done these ty…SivaKumarRajan 31 views 4 comments 0 points Most recent by SivaKumarRajan Reporting and Analytics for HCM