Compensation
Discussion List
-
An internal assertion test couldn't be completed at location ReportUtils.validateArchiveDefn:2.Summary: Non - US payroll extract is giving the error in one of the scheduled runs in production: An internal assertion test couldn't be completed at location ReportUtil…Shilpa Varghese 173 views 4 comments 0 points Most recent by Shilpa Varghese Reporting and Analytics for HCM -
not able to fetch latest date even after using MAX functionHi team i am trying to fetch latest last update date record in below query but unable to do it.i am looking for 2022 as a latest date record but when i use max function …Chetana Pawar 11 views 1 comment 0 points Most recent by Rakesh Ghosh-Oracle Reporting and Analytics for HCM -
Compensation Zones and Grade Differentials of an employee in BISummary: How can I get the Compensation Zone and Grade Differential an employee is assigned to? I saw from previous posts that the details are in the CMP_ADDRESS_ZONES t…Tom John Bontoyan 31 views 5 comments 0 points Most recent by Rajesh Jupudi-Oracle Reporting and Analytics for HCM
-
Missing Salary data post 24A upgradeSummary: Post 24A upgrade all OTBI reports failed to load salary data. We looked into each column added in the reports and noticed the issue is caused when there are col…Ridma Karunanathan 21 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Can we restrict managers doing calibration outside of Performance distribution?Summary: We have Performance Distribution added to a Profile rating model. In Calibration, same information is being used to display Bell Curve. Now, as an HR, if I am d… -
How can we replicate the Budget Analysis from Administration report in CompensationHi, We want to replicate as a OTBI Analysis the Budget Analysis from Administration report in Compensation in order to have information about the Overall Budget amount f…Crisenese 21 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Does anyone know which tables I need to use to retrieve the Bonus Amount from the Compensation ModueSummary: I have a requirement to show last years performance bonus amount in a report and I have built most of the information using SQL but I am unsure what tables I ne…User_2025-02-04-08-51-08-912 544 views 6 comments 0 points Most recent by Phils Reporting and Analytics for HCM -
HTML Markup values are not working after 23B updateSummary: Good afternoon, I am having issues while trying to save an edit of code within the sandbox > HTML Markup. When making the replacement, the system only saves par…Jorge_Trindade 61 views 8 comments 0 points Most recent by User_3MBEU Reporting and Analytics for HCM
-
OTBI report retrieving Base Salary amount and Annual Salary amountSummary: Content (please ensure you mask any confidential information): Hello experts, do we have a standard OTBI to retrieve Base Salary and Annual Salary amount? If so… -
Sample OTBI report to track compensation plan approvalSummary: Content (please ensure you mask any confidential information): Hello experts, is there a sample OTBI report to track compensation plan approval status? I notice…Valerio Curzi 1 view 1 comment 0 points Most recent by Andreea_Nuck-Oracle Reporting and Analytics for HCM
-
Roles required to access compensation data in reportsSummary: What are the roles required to access compensation data in reports Content (please ensure you mask any confidential information): Version (include the version y…Gleamy Mishra 11 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Salary pay rates are incorrect for some employeesSummary: The OTBI report is showing incorrect pay rate data for some employees for HRA EX and Notional Special Allowance components. We cannot identify why this data is …Ridma Karunanathan 21 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Oracle BI tables to retrieve individual compensation plan nameSummary: Content (please ensure you mask any confidential information): Hello experts, we are building custom report. Do you know the BI table to retrieve Individual Com…Valerio Curzi 3 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Report for a Salary basis of the type "Salary amount is determined by simple components"Summary: We have a Salary Basis defined of the type "Salary amount is determined by simple components" and we have hired an employee with this salary basis. There are 5 …Sachin_Shirke 332 views 4 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Using 2 different subject areas (Salary and Performance Rating) - Getting split/merged cellsSummary: Hi Experts, I'm pretty much a beginner with reporting. My client wants an OTBI report that can pull salary details as well as latest performance ratings (overal…
-
Days of service calculationHi Team, I am using "Workforce Managemnet - Work Relationship Real Time" subject area and I want to calculate "Days Of Service" only for Terminated employees. I want to …Raghu_Nandan 21 views 1 comment 0 points Most recent by BogdanFarcasanu-Oracle Reporting and Analytics for HCM
-
Minimum wages configurationSummary: We have business requirement to show the minimum wage in the salary page (Employee). Apart from grade range, it should show minimum wage for the state, specific…
-
Payroll element BI table where retrieving employee Assignment IDSummary: Content (please ensure you mask any confidential information): Hello experts, I should retrieve for an employee the assignment id where a payroll element is loa…Valerio Curzi 11 views 3 comments 0 points Most recent by RWMATTHE-Oracle Reporting and Analytics for HCM
-
Dhajani Perera 1 view 1 comment 0 points Most recent by Andreea_Nuck-Oracle Reporting and Analytics for HCM
-
Details of employees who are having the access of respective modules.Hi Everyone, For audit reason We have received an requirement where our need to is to get details of employees who all are having an access for respective modules and al…Jebarsan Thangam John Durai Raj 11 views 0 comments 0 points Started by Jebarsan Thangam John Durai Raj Reporting and Analytics for HCM
-
bulk release of compensation change statementsSummary: We use Centrally managed and stored delivery options and Allow managers to do a staggered release of statements. The manager has to release the statements for e…
-
unable to access data from Compensation- Salary Details Real time with custom roleWe have created an OTBI report using Compensation - Salary Details Real Time. We have created a custom Role for Human Resource Analyst. With this role we are unable to a…
-
Oracle HCM Table for currency exchange ratesSummary: Content (required): Hello experts, we have implemented custom BI Compensation reports displaying payroll elements and amounts in local currencies. Our customer …Valerio Curzi 265 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Employee Advance details in oracle Fusion HCMSummary: Employee Advance details in oracle Fusion HCM Content (please ensure you mask any confidential information): Hi, Please help to identify table/query for Employe…Hitha Harikumar 122 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Where retrieving Process Workforce compensation change statements processes Transaction IDSummary: Content (please ensure you mask any confidential information): Hello experts, do you know where I could find the Transaction ID when processing Workforce compen…
-
CMP_SALARY_SECURED_LIST_V emptySummary: Using CMP_SALARY_SECURED_LIST_V to secure a BIP report, but the table is empty for target user. Content (please ensure you mask any confidential information): H…Claudia Schiff 54 views 2 comments 0 points Most recent by Claudia Schiff Reporting and Analytics for HCM -
Security to Compensation ModuleContent Hi all - we have created a report that pulls compensation module details through BIP. We are using secure views, but when I sign in as the line manager to view t…Prudence K 28 views 8 comments 0 points Most recent by Claudia Schiff Reporting and Analytics for HCM -
Query showing the values on the current Tax Calculation CardsSummary: I need BI publisher reports that show the values on the current Tax Calculation Cards for all active employees including their hire date. The values of greatest…
-
Need help finding field in OTBI reportSummary: Hi Team, We have requirement to create a report to pull Progression Grade Ladder’s details. We created OTBI report using Workforce Management - Grade Rate Real …Saurabh_Mharolkar 61 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Is there a way to restrict delegation UP the hierarchy?Summary: Is there a way to restrict delegation UP the hierarchy? If a manager delegates to one of his direct reports, employees are able to approve their own ICPs. We ha…