Payroll
Discussion List
-
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 51 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Need to build an analysis report of all pay periods that exist to dateSummary: I'm trying to build an analysis in OTBI that brings me all of the pay period names and dates for all Consolidation Groups in a Legislative Data Group. This is t…sarah_1000 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to run Generate Prenote File report of Payroll of HCMSummary: Hello, I wanted to run the oracle seeded report Generate Prenote File report of payroll module of HCM. But I don't know how to run this report. Thanks Content (…VAIBHAV L 33 views 6 comments 0 points Most recent by Anca Andronic-Oracle Payroll and Global Payroll Interface (GPI)
-
How i can improve the running time for one report?Summary: Misdated Payroll Relationship timming out I used this formula: CASE WHEN "Payroll Assignment"."First Standard Earning Date" = MIN("Worker Payroll"."Payroll Star…ClaudiaManea 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Customize- Payroll Register Report for the Latest ProcessSummary: Can we add additional attributes by customizing the seeded extract "Payroll Register Report for the Latest Process". Content (required): Can we add additional a…Mohan Murali 131 views 6 comments 1 point Most recent by Nithya_Bussety-Oracle Reporting and Analytics for HCM
-
Payroll-Personal Payment Details Real Time - no data being returnedSummary: Trying to build a report showing employee bank account details from SA 'Payroll-Personal Payment Details Real Time' - I have the required roles (Payroll Mgr etc…
-
Extract run Failing after adding new FastFormulaSummary: Extract is failing after adding new rule to get the correct parking tier based upon employee salary Content (please ensure you mask any confidential information…GauravGupta39 21 views 4 comments 0 points Most recent by GauravGupta39 Reporting and Analytics for HCM
-
looking for ytd and ptd bip reportSummary: lookind for ytd and ptd bip report Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Co…
-
Report to fetch void payment dateSummary: We are looking for a report with output similar to Payment Register Report but with an additional column to display the actual Void date. Content (please ensure…
-
How can we fetch Calendar year to date value of any balance in Oracle BI Report.Need to fetch Calendar Year to Date value in Report.Sourabh_Patial 143 views 3 comments 0 points Most recent by Siddarth G L Reporting and Analytics for HCM
-
How to run Oracle Standard Cheque Report of Payroll of HCMSummary: Hello, I wanted to run the oracle seeded report cheque report of payroll module of HCM. But I don't know how to run this report. Thanks Content (please ensure y…
-
Data not appearing on all tabs of an Excel report when run as a payroll FlowSummary: We have an HDL Error report that is based on a Data Model and creates an Excel spreadsheet with 3 tabs of data. The first tab is the Summary, the second lists a…Al Darabaris 11 views 3 comments 0 points Most recent by Al Darabaris Reporting and Analytics for HCM
-
Can we add Settlement Date to OTBI reportSummary: Can we add settlement date to OTBI reports? Content (please ensure you mask any confidential information): Version (include the version you are using, if applic…Shameer Shaik 31 views 4 comments 0 points Most recent by Shameer Shaik Reporting and Analytics for HCM
-
Element Entries Real Time - Retroactive Payement DateSummary Within Element Entries Real Time - I have Retroactive payements made to employees however in OTBI i cannot locate 'Orginal Date Earned'Content Overview: For Empl…User_2025-02-04-23-40-44-792 53 views 4 comments 0 points Most recent by Parag Hiremath 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 32 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Any Suggestions of how to improve HCM Extract completion time!Summary: We are facing an issue with the custom HCM extract which is running and taking a long time to generate the XML output (5 employee data for 10 minutes). We have …
-
Query to get department from PAY_COSTS tableSummary: Need to link the department to the PAY_COSTS table. How can I link the department (organization_id) to the PAY_COSTS table through other tables? Content (please…luke.syv8 2 views 1 comment 0 points Most recent by Rakesh Ghosh-Oracle Reporting and Analytics for HCM
-
How to retrieve 'Exempt from Long Term Care' associated with Washington tax card from backend table?Summary: I am trying to locate 'Exempt from Long Term Care' linked to the Washington Regional Tax Card in the backend table, but I cannot find the base name in the backe…Swapna Udaiyar 61 views 7 comments 0 points Most recent by Gabriela Ichim-Oracle Reporting and Analytics for HCM
-
We looking Variable pay plan details in OTBI for which subject area need to use ?Summary: Hi Team, May I know which subject area need to use for Variable pay plan details as per below screen shot. Variable pay plan details: Content (please ensure you…AjayKumar Maddipati 11 views 5 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Report showing all ElementsSummary Need a report to show all element entries that have been created (Recurring and Non-Recurring)Content HI All, I hope this is a simple ask but I can't seem to fin…User_2025-02-04-08-51-08-912 1.1K views 9 comments 1 point Most recent by Muzaffaruddin 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 22 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Building Scalable Payroll Balance Reports in OTBISummary This document provides guidance to OTBI report developers on how to build scalable reports for reporting on Fusion Payroll balances.user714053-Oracle 210 views 4 comments 4 points Most recent by Divyalakshmi Krishnamoorthy Reporting and Analytics for HCM
-
Sql to find t4 information of employee (like tax year and boxes information etc)Summary: Dear exports, Any one have sql/otbi report to pull the information exist in canada t4 slip? Please suggest Content (please ensure you mask any confidential info…Rama123-Oracle 11 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Vacation hours disbursedSummary Vacation hours disbursedContent Hello Community, Are you aware of any report in oracle that will tell us vacation hours disbursed? We are specifically looking fo…User_2025-02-05-16-57-43-236 6 views 6 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Sql Query to get payroll deduction detailsSummary: I am looking for a query which provides terminated employees last earnings and deduction details from payroll. Content (please ensure you mask any confidential …Rahul K-Oracle 441 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Customer wanted automate the T4 slips that should deliver to terminated emps personal email addressSummary: Hi Experts, Need suggestions on how to automate the T4 slips that should deliver to terminated emps personal email address, if anyone implemented this functiona…Rama123-Oracle 11 views 1 comment 0 points Most recent by ROOPESH MADAN-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…
-
Payroll Audit ReportSummary: Hi All, Do we have any option for audit report on Payroll details. Who has accessed a specific salary/payroll screen in the past 7 days? Thanks, Ram Content (pl…RamkumarKadhiravan 21 views 2 comments 0 points Most recent by RamkumarKadhiravan Reporting and Analytics for HCM -
Where can we find the latest list of all HCM PVOs to be used in BICCSummary: We want to use BI Cloud Connector to pull HCM data. Where can we find the documentation for all available PVOs supported in BICC ? Content (please ensure you ma…Soumya Suravita 305 views 6 comments 0 points Most recent by Soumya Suravita Reporting and Analytics for HCM
-
Database table that is equivalent to the OTBI Subject Area Payroll Calculation Cards Real TimeSummary: Can someone provide the Database table name that is equivalent to the OTBI Subject Area Payroll Calculation Cards Real Time specifically looking for the Calcula…Laura Goodall-Brown 11 views 2 comments 0 points Most recent by Laura Goodall-Brown Reporting and Analytics for HCM