Compensation
Discussion List
-
Need to know the table that contains bonus amount in Individual compensation.Summary: I'm looking for the table that stores Bonus amounts entered through the Individual Compensation module. I need the table that stores the person_id, assignment_i…Prerna Mhaisane 40 views 7 comments 0 points Most recent by Prerna Mhaisane Reporting and Analytics for HCM -
How can the seeded compensation dashboards below for managers be customized?Can anybody suggest the right way to edit these seeded dashboards and do the customization based on our company needs. The need is to Add/ remove parameters Add/ remove …Sameeksha MN 16 views 3 comments 0 points Most recent by Sameeksha MN Reporting and Analytics for HCM
-
Logical SQL With Dashboard PromptSummary: Hi - I am trying to build a logical SQL report that displays paycheck information along with current salary as an outer join from Compensation subject area. The…
-
Best Practices: OTBI Compensation - Compensation Stock Details Real Time subject areaSummary: This is part of a series for best practice tips to use in your cloud environments, created by Oracle BI and Product Management. Roles and Privileges Compensatio…Gail Langendorf-Oracle 13 views 1 comment 2 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
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 314 views 6 comments 1 point 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 …SimonG 63 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Error : An application error occurred. See the incident log for more information.Summary: Is there any way to retrive log for error message : An application error occurred. See the incident log for more information. Content (please ensure you mask an…Muzammil Aman Siddiqui-Oracle 57 views 0 comments 0 points Started by Muzammil Aman Siddiqui-Oracle Reporting and Analytics for HCM
-
When the customer is trying to edit salary information from Salary History Page and then submittingSummary: When the customer is trying to edit salary information from Salary History Page and then submitting it they are getting error "" An application error occurred. …Muzammil Aman Siddiqui-Oracle 2 views 0 comments 0 points Started by Muzammil Aman Siddiqui-Oracle Reporting and Analytics for HCM
-
BI Publisher Report SQL Error : SQL or ORA exceptions caused due to invalide sql , database packageSummary: I've created a headcount report that combine all workforce informations based on per_all assignments, compensation data based on cmp_salary_v cmp_salary_v2... i…Ayoub AFRASS 486 views 5 comments 0 points Most recent by Juan Pablo Gonzales Reporting and Analytics for HCM -
Employee displays in analysis for indirect leader they no longer report up toSummary: We've kicked off our workforce compensation cycle. I have an employee who changed managers earlier this year. The indirect manager they previously reported to i…Susan Anderson 21 views 2 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM -
Redwood Compensation page for global and local transferSummary: On the redwood experience for Global & Local transfer 'Compensation' page, the recruiting assistant button is blocking the save button. Content (please ensure y…Bhuvaneswari Dharmaraj 13 views 2 comments 0 points Most recent by Bhuvaneswari Dharmaraj Compensation
-
BIP Report not retrieving data for single value in parameter, But same is working fine in DataModelSummary: BIP Report not retrieving any data when single value is selected in parameter, But the same is working fine in Data Model. Please help. Content (please ensure y…Mallikharjun Purilla-Oracle 22 views 2 comments 1 point Most recent by Hello123 Reporting and Analytics for HCM
-
Currency conversion rate not applied for monetary item in TCSThe currency conversion rate was expected to be applied to the equity data loaded through the external data screen in the TCS system. However, it appears that the system…Divyansh srivastava 2 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to alignment of text in TCS statement ?Summary: The text alignment in columns of TCS reports is inconsistent, with some columns using left alignment and others using right alignment. However, the alignment of…Divyansh srivastava 1 view 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
SQL to Get Grade and Grade and Grade Step details on a assignmentSummary: Hello Everyone, I'm new to SQL query building. Just getting hands on it. I am trying to create a Data model that will return salary detail including Grade and G…PRABHA_DEV 3.2K views 16 comments 0 points Most recent by User_WTXEN Reporting and Analytics for HCM
-
Annual salary not equal across different subject areasWe are having a problem with annual salary not being equal in Compensation - Salary Details Real Time and Compensation - Workforce Assignment Salary Real Time. It appear…
-
Employee job levelsSummary: Adding job level to employee report Content (please ensure you mask any confidential information): We have a requirement to show the employee job levels. When I…Ridma Karunanathan 32 views 4 comments 0 points Most recent by Ridma Karunanathan Reporting and Analytics for HCM
-
How to control the font size in TCS ?How to control the font size in TCS? The font size for the Total value in TCS is smaller than the font size used for tabular data.Divyansh srivastava 1 view 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
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
-
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 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 38 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 -
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 27 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
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…Erin McDonald-44302 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 31 views 1 comment 0 points Most recent by Manoj.Gupta Reporting and Analytics for HCM
-
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 21 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 31 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics 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 21 views 2 comments 0 points Most recent by Ramona Popescu-Oracle Reporting and Analytics for HCM