Compensation
Discussion List
-
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 51 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 72 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
-
Compensation Change statementsSummary: We use Centrally managed and stored delivery options and Allow managers to do a staggered release of statements. We only give access to senior managers and abov…
-
Is the Release Statement to Workers flag available in OTBI and BI Tables?Summary: Content (please ensure you mask any confidential information): Hello experts, is the attached field available in Oracle HCM Reporting subject areas or BI Tables…Valerio Curzi 11 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Drill Down in Pivot table with BI PUBLISHERSummary I want to create a drill down from a result on a pivot table which will redirect you in another reportContent Hello, Someone know how can I crate a drill down in… -
SQL query to fetch number of direct reportees to a line managerSummary: I want to build a BI report where I need to fetch the count of direct reportees to the Line Manager. Content (please ensure you mask any confidential informatio…Tamseel Aijaz 671 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Secured List Views for compensation worksheet displaySummary: HCM table of Secured List Views for compensation worksheet display Content (please ensure you mask any confidential information): Version (include the version y…Tamseel Aijaz 1 view 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
REST API for Salary, Payroll elements and StocksSummary: Content (please ensure you mask any confidential information): Hello experts, do you know where retrieving REST API for Salary, Payroll Elements and Stocks? Kin…Valerio Curzi 21 views 7 comments 0 points Most recent by Shyam Rajbhar Reporting and Analytics for HCM
-
Restrict insertion of salary records with no changesSummary: Whenever we do transfers, promotions, and local/global transfers that do not have any changes to salary, salary records get inserted and the inserted record app…
-
Attempted to use REPLACE (name, chr(38)||amp;, '&') function to remove 'amp;' after & in DM SQLSummary: Hello Forum: We have & showing up in place of 'Apples & Oranges' i..e. 'Apples & Oranges whether in a Report or a native HCM Extract XML output (View En…
-
Sql query or Table to fetch Compensation Worksheet data in BIP report based on securitySummary: Sql query or Table to fetch Compensation Worksheet data in BIP report based on the roles assigned to the user. Content (please ensure you mask any confidential …
-
Oracle HCM BI Table to retrieve employees Eligible for a compensation planSummary: Content (please ensure you mask any confidential information): Hello experts, we are building custom BI reporting collecting compensation plan columns at the em…Valerio Curzi 41 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How does your organization use Oracle to comply with the MN Wage Theft law?Summary: My organization is in the process of implementing Oracle and we’d like to understand if other MN-based organizations have a process in place related to MN Wage …Tammi Desens 11 views 4 comments 1 point Most recent by Carolyn K Payroll and Global Payroll Interface (GPI)
-
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 471 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
-
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 -
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 32 views 4 comments 0 points Most recent by Laura_Stewart_Sita Reporting and Analytics 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…
-
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 91 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 751 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 92 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