Compensation
Discussion List
-
OTBI report for Average allocation by Rating is giving 'No Result; however working for managerSummary: We have created custom OTBI report to display the Rating v/s Average Allocation %. The OTBI dashboard is created and the report is added to the dashboard sectio…Shruthi T 31 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
HCM Compensation/Payroll Element Entries History Real Time Excluding Inactive / Terminated EmployeesSummary: Payroll - Element Entries History Real Time does not appear to be returning data if the employees latest assignment is inactive (the employee is terminated). Co…bwdata 71 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
BI table to retrieve Approval Status field in Workforce Compensation moduleSummary: Content (please ensure you mask any confidential information): Hello expert, do you know in which Compensation BI table is stored the highlighted value? Thanks …Valerio Curzi 11 views 2 comments 0 points Most recent by RWMATTHE-Oracle Reporting and Analytics for HCM -
How to modify the message in view compensation history redwood pageSummary: How to modify this message in view compensation history redwood page Content (please ensure you mask any confidential information): Version (include the version… -
Issue with employee's line manager compensation plan approval status SQL querySummary: Content (please ensure you mask any confidential information): Hello experts, we built the following query by filtering for an employee for testing purposes: se…Valerio Curzi 1 view 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
SQL query to retrieve compensation plan status at the employee levelSummary: Content (please ensure you mask any confidential information): Hello experts, I need to track for all employees the status of their line managers compensation p…Valerio Curzi 391 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to modify this message in view compensation history redwood pageSummary: How to modify this message in view compensation history redwood page? Can someone guide please Content (please ensure you mask any confidential information): Ve… -
Building a custom report for pay ratesSummary Client is using the newly released salary basis based on rates of pay. There are no OTBI subject areas and need to create a new data model.Content The tables hol…User_2025-01-28-05-08-05-606 71 views 2 comments 0 points Most recent by Rajesh Jupudi -Oracle Reporting and Analytics for HCM -
Fast Formula for Matrix Manager in Compensation Plan HierarchySummary: Hi, We have the below requirement for Compensation hierarchy: If Country of the Employee is Poland, the hierarchy should be the other manager type (Comp manager…Fatima Claire Benito 41 views 1 comment 0 points Most recent by Manoj.Gupta Reporting and Analytics for HCM -
Auto-end date bonus programs while a new bonus program is added to an employee.Summary: Need to auto-end date old Bonus Program when a new Bonus program is getting added to an employee. For example, if a new Bonus program is starting on 1st January…Shibani Patnaik 1 view 1 comment 0 points Most recent by Danny Cusnir-Oracle HCM Experience Design Studio: Autocomplete Rules -
Dimension Folder Not Visible in Subject Area But It Is SearchableGood Day Experts, There are times when I am creating an analysis report. Some folder-columns are not visible in the subject area but it is showing when searching in the …JMLMIII 11 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Logic to know the Insert/Update/Delete as Audit Action in Audit Salary Report for HCMWe want to build an HCM audit report in OTBI. HRDirect needs an audit report to see when a salary change was added, updated or removed an individual. Filters: Employee I…Mukesh Bulla 52 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Compensation Business Process Dashboard Access ControlSummary: Business requirment is to restrict access to the seeded Compensation Business Process Dashboard for Line Managers. Identified that Workforce Transaction Analysi…SaiGayatri Chevooru 32 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Autocomplete Rule Error After New Grade CreatedSummary: Our compensation team recently added a new grade and updated the associated job code. I have two ACR's on the job requisition that pull in both Overtime Status …Randy_Yoder 11 views 3 comments 0 points Most recent by Danny Cusnir-Oracle HCM Experience Design Studio: Autocomplete Rules -
how can we add into VB studio OrganizationSummary: how can we add into VB studio Organization. while editing the page i'm getting the following error "To use Visual Builder Studio, you have to be a member of a V…Pardha Saradhi Undru-Oracle 191 views 3 comments 0 points Most recent by John Rhodes-Oracle Visual Builder Studio for HCM -
Can we restrict Benefits/Compensation Specialist from accessing Element Entries?Summary: Element Entries in BI Publisher Reports Content (required): For a client, with different legal entities, in reports we are making use of secured views at assign…VDoolhur 22 views 2 comments 0 points Most recent by Ramona Popescu-Oracle Reporting and Analytics for HCM -
Report not pulling correct salary infoSummary: We have a requirement from our HR department to build an AAP report that includes salary information for employees. We've tried building this report using a few…Henry Imgrund 31 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
In Salary report midpoint and comp ratio but report showing wrong when Grade code changedSummary: Hi Team, have direct column in salary report, midpoint and comp ratio but report showing wrong when Grade code changed . please any on help me on ? PFA. Thanks,…AjayKumar Maddipati 21 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
what is difference between CMP_ASG_SALARY_V and cmp_salary ?Summary: Hi Team, what is difference between CMP_ASG_SALARY_V and cmp_salary because of still cmp_salary showing corrctly of cs.COMPA_RATIO and cs.RATE_MID_AMOUNT column…AjayKumar Maddipati 71 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Rest API to create individual compensation planSummary: Hi All, Is there any REST/SOAP API available to create individual compensation plan? Thanks, Venkatesan R Content (please ensure you mask any confidential infor… -
Is it possible to schedule reports under My Client Groups > Compensation > View Administration Rpts?Summary: Is it possible to schedule any of the reports under My Client Groups > Compensation > View Administration Reports? Content (please ensure you mask any confident… -
Compensation OTBI Best PracticesSummary Technical brief discussing compensation related OTBI best practices Content Document 2571003.1 - Compensation OTBI Best Practices (July 2019)Gail Langendorf-Oracle 150 views 2 comments 8 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Total Compensation Statement OTBISummary: Analysis for Total Compensation Statement - Feedback Survey Content (required): Is there an analysis available in OTBI to pull data for the Total Compensation S…Shelly Feyerherm 81 views 13 comments 0 points Most recent by Art Cannon Reporting and Analytics for HCM