Payroll
Discussion List
-
How to add custom Parameter to PayslipSummary: Need to be able to print Payslip by Departments for specific Departments following a Pay Run Content (required): We have over 60 departments and some department…Greyseerco 135 views 9 comments 0 points Most recent by Saurabh.Sinha-Oracle Reporting and Analytics for HCM -
Report to extract LRU Calculation cards configuration detailsSummary: Report to extract LRU Calculation cards configuration details Content (required): Hi Team, Greetings! Does anyone have the report or the query to extract LRU Ca…Parag Hiremath 25 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM -
How do I get Box 13 to populate on the W2?Summary: Box 13 on our W2s is not showing as checked. We are a government agency with a pension plan. I looked through Oracle documentation and found guidance regarding …Sara Ro 43 views 1 comment 1 point Most recent by Faithe Chu-Oracle Payroll and Global Payroll Interface (GPI)
-
Which table stores Payroll Association dates?Summary: We are able to report on Payroll Relationship Final Close date and specific Payroll Assignment dates, but cannot find the data for Payroll Association Final Clo…TraciH-NorthBayHealth 110 views 3 comments 0 points Most recent by TraciH-NorthBayHealth Reporting and Analytics for HCM -
Report to get the duplicate element entries in a given pay periodSummary: Report to get the duplicate element entries in a given pay period Content (required): Hi Team, Greetings! Is there an existing report to get the duplicate eleme…Parag Hiremath 16 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Invalid Number Error in fetching Basic Salary ComponentSummary: We are writing an oracle sql query to fetch different components in the salary for inactive employees. But it keeps showing below error on runtime. ORA-01722: i…Rohankumar Patel 54 views 2 comments 0 points Most recent by Sudheer Patel Reporting and Analytics for HCM
-
How to cutomize a seeded Payroll register Report extractSummary: Which extract should we customize to add the new attributes to the extract. Can you provide us a document for the same. Content (required): We have a requiremen…Minu Priya 66 views 4 comments 0 points Most recent by Mohammad Shahnawaz-Oracle Reporting and Analytics for HCM
-
Audit Report for all tax code changes received from HMRCSummary: Need a report showing tax code changes from HMRC Content (required): Can anyone help with suggesting how do I go about building a report based on tax code chang…Isabela Radivoi 52 views 0 comments 0 points Started by Isabela Radivoi Payroll and Global Payroll Interface (GPI) -
Reporting on element entry Correction - getting new and former values?Summary: There is a need to report on changes made to an element entry record of a person, where the 'Correct' editing option was used (not Update). We are seeking to ge…Shant Sarkissian_NES 34 views 7 comments 0 points Most recent by Shant_Sarkissian_WJG Reporting and Analytics for HCM
-
Missing Bank Details for Rehires and Global Transfers not linked to latest Personal Payment MethodsSummary: Bank Details for Employees who have transferred from one Legal Employer to another or for Rehires are not updated against their new Personal Payment Methods. Co…GJ79 54 views 3 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Element Entry Changes ReportSummary Copying an existing BI Publisher versionContent Hi, I'm trying to replicate a BI Publisher report that HR runs each month and submits to payroll. I'd like the re…Andrew-180341 76 views 2 comments 0 points Most recent by Isabela Radivoi Reporting and Analytics for HCM
-
Dynamic Regular Date Earned Formula RequiredSummary: Need a formula to get the last two regular dates earned to update each month. Content (required): I have a Payroll Net Pay Variance report which compares the Ne…
-
Is there a standard report for Balance Adjustments?Summary: Specifically, we are looking for a way to report on failed Balance Adjustments. At year end, we frequently mass load Balance Adjustments. And always a few fail …
-
Query to extract employee Salary SourceSystemId and SourceSystemOwnerSummary: Content (required): Hello experts, please could you share the SQL query to extract employee Salary SourceSystemId and SourceSystemOwner? Thanks in advance for y…Valerio Curzi 54 views 1 comment 0 points Most recent by Mandeep Gupta Reporting and Analytics for HCM -
Need help - Need a payroll report for Element vs BalancesSummary: We need to create a report to include Element names which are feeding a particular Payroll Balance. We tried to do it using Payroll Subject Areas but it did not… -
Tax Witholding ReportSummary: I need help creating a report showing which employees are claiming exemption from the tax witholdings. More specifically, which employees are claiming exempt. I…Greg Rank 36 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Query to extract ElementEntry SourceSystemID and ElementEntryValue SourceSystemIDSummary: Content (required): Hello experts, do you have a query to extract ElementEntry SourceSystemID and ElementEntryValue SourceSystemID? We need to recover both keys…Valerio Curzi 34 views 3 comments 0 points Most recent by Mandeep Gupta Reporting and Analytics for HCM
-
Pension Automatic Enrolment calculation card report in OTBISummary: Content (required): Hi, hoping someone can steer me in the right direction here. I'm looking to report on the data contained in employees' PAE calculation card …Leanne W 64 views 3 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM
-
Audit Report for inactive bank account associated with employee payment methodSummary: Audit Report for inactive bank account associated with employee payment method Content (required): Hi Team, Greetings! Is there any existing Audit Report for in…Parag Hiremath 54 views 8 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM
-
Need Help with Permissions Required for HCM Subject AreasSummary: I've got a service account that we use to pull extracts into Casabase. We are getting access to all of the ERP and accounting subject areas. However, we are now… -
Converting payroll elements from one currency to anotherSummary: Content (required): Hello experts, Do you know if now it is available in OTBI and UI the possibility to convert payroll elements from one currency to another ac…Valerio Curzi 34 views 3 comments 0 points Most recent by Valerio Curzi Reporting and Analytics for HCM
-
Line Manager information in OTBI reportSummary: If any employee is Line Manager for other employee record then we need to display 'X' value. Content (required): Ex: Output: In the above scenario 66789 and 123…Visu 64 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to remove certain part of a column after parenthesis in BI reportSummary: Hi All, I want to remove the part of Tax Reporting Unit column from where the parenthesis is starting. Please suggest the function to use this in sql. Example: …Dona Das-Oracle 55 views 6 comments 0 points Most recent by Dona Das-Oracle Reporting and Analytics for HCM
-
How to restrict Effective Date parameter in schedule process, not to generate on specific DatesSummary: We have an ADP Payroll Extract. During the scheduling process, where in Effective Date Parameter should not pass Saturdays,Sundays and should consider every alt…MaheshRayudu7 56 views 1 comment 0 points Most recent by HarishVummidi Reporting and Analytics for HCM
-
Need a report that shows assignment numbers that DO NOT have a tax card associationSummary: I'm looking for help on developing a query that will fetch Employee Name, Person Number, Assignment Number, and Assignment Effective Start Date for any assignme…
-
I am unable to fetch payroll details with worker and bank details in OTBI .Summary: When i take only payroll columns like payroll_id, payroll_name then i got output but when i select payroll columns with bank details or worker columns getting n…mohityagyik 24 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
need a payroll element costing reportSummary: Need to write a payroll element costing report that includes highlighted information from picture below Content (required): need a report that shows all the inf…Bernadette Dorris 55 views 2 comments 0 points Most recent by Bernadette Dorris Reporting and Analytics for HCM
-
How to fetch Arrear balance details for terminated EmployeesSummary: Content (required): Hello, Our requirement is to fetch the arrears details for the terminated employees, adjust them accordingly. Deduction report has a section… -
Payroll GL costing details in HCM fusionSummary: Please guide me to get the below columns where to fetch in hcm fusion tables Ledger Group Accounting period GL Distribution status Open item status Monetary amo…susmita 74 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Costing table link with gl tables in hcm fusionSummary: I am looking for the below tables Whether its linked with gl tables pay_costs pay_cost_allocations_f pay_cost_allocations_keyflex GL_JE_BATCHES, GL_JE_HEADERS G…