Payroll
Discussion List
-
What Caused the seeded Payroll Activity report to be updated on 11/27/2025?Summary: Want to understand why the seeded Payroll Activity Report has a Last Modified Date of 11/27/2025? and Owwner is System Account Content (please ensure you mask a… -
How to Find the Pension Scheme Name from the 'Benefits and Pensions' (BnP) Calculation Card in a BIPHello Experts, I am building a BI Publisher report to show employee pension details. I had a requirement, were I need to retrieve the Pension Scheme Name from the employ… -
Query required to fetch the fields - Resident PSD Code, Resident School District, Work PSD Code.Hi, Does anybody have a query that will fetch the fields - Resident PSD Code, Resident School District, Work PSD Code, Work School District. These fields are present in …SowmyaSk 543 views 10 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to create custom employee role that only gives read-only access to payroll documents of record?Summary: We have a requirement, for a specific group of employees, to create a custom employee role that solely gives read-only access to payroll Documents of Record (th…Michelle Hughes 11 views 2 comments 0 points Most recent by Michelle Hughes Reporting and Analytics for HCM
-
Generate Payslip - Archive Information and Generate Report ErrorSummary: When i ran Generate Payslip, The Archive Information and Generate Report log status are Error. Content (please ensure you mask any confidential information): I …Pablo Calizo 131 views 5 comments 0 points Most recent by Kevin Wong Sing Ting Reporting and Analytics for HCM
-
Custom report is not triggering automatically after the Make EFT Payment process is completedSummary: Actual Behavior: Custom report is not triggering automatically after the Make EFT Payment process is completed (following upgrade to 25C). Expected Behavior: Re… -
The value is not falling in the backend tables for Extra Withholding column in calculation card.There is a requirement to fetch Federal Tax form details from My Workforce > Payroll > Calculation Card > Tax Withholding. In this section, there is a specific column na…SameekshaShrivastava 1 view 0 comments 0 points Started by SameekshaShrivastava Reporting and Analytics for HCM
-
Missing current month data in OTBI for payrollSummary: Missing current month data in OTBI for payroll Content (please ensure you mask any confidential information): We have facing an issue where the current pay peri…
-
Element HDL Template Generator ReportSummary OTBI report to generate sample files to create Payroll Elements using HDL Content Introduction: This report provides sample files to create Payroll Elements usin…Kaushik R-Oracle 9.9K views 128 comments 35 points Most recent by Kaushik R-Oracle Payroll and Global Payroll Interface (GPI) -
UI End-Date and Database Records for Bank AccountsSummary: Hi everyone, I recently inactivated a bank account using the checkbox, and now I see a mismatch with the end date. The UI shows it as 01/07/2025, but the tables…
-
Unable to fetch the State, County and City values through "Payroll - Calculation Cards Real Time"Summary: Unable to fetch the State, County and City values through "Payroll - Calculation Cards Real Time" subject area Content (please ensure you mask any confidential …
-
SQL Query for Calculation Cards > Benefits and Pensions for Employees with Multiple AssignmentsHi Navigation: Calculation Cards > Benefits and Pensions I need help to find out how to join the Pension scheme back to the Assignment number/id for a BIP report. If not…Nilesh D Patel 74 views 1 comment 0 points Most recent by Rakesh Ghosh-Oracle Payroll and Global Payroll Interface (GPI)
-
Employee Assignments Processed in a 'Calculate Payroll' RunHi, does anyone have an SQL/Data Model to list all employees processed through a 'Calculate Payroll' Run or know which tables i would need to use?
-
Required table for component group rules setupSummary: Hi Team, Could ypu please provide us the table where payroll component group rules stored in oracle fusion Payroll module Setiup name > Component Group Rule. fo…
-
Query to link between State and component group ruleSummary: what is the link between component group rule and this state through SQL query or backend table. We got one table HZ_GEOGRAPHIES where GEOGRAPHY_TYPE = 'STATE' …
-
Payroll query that fetches results only if Archive and Generate Payslips is run post Payroll runSummary: We have a requirement to fetch the run result values only if the Archive Periodic Pay results and Generate Payslips processes have been run for the person post …Pinky Mukherjee 736 views 5 comments 0 points Most recent by Vibha Pandey - Oracle Reporting and Analytics for HCM -
Query to get Statement of Earnings (Payroll> Person Results> Calculate Payroll> Standard Earning.)Summary: Could anyone please provide a query to retrieve the following data? Query to get Statement of Earnings (Payroll> Person Results> Calculate Payroll> Statement of…Choudhary Punit 22 views 0 comments 0 points Started by Choudhary Punit Reporting and Analytics for HCM -
query to identify the processed and unprocessed payroll transactions for BI reportsVersion (include the version you are using, if applicable): for version "Oracle Fusion Cloud Applications24A (11.13.24.01.0)".Immanuel Aruldoss 54 views 2 comments 0 points Most recent by Eric Geddes Reporting and Analytics for HCM
-
How to restrict special characters for account holder name in redwood personal payment method pageSummary: Customer want validation needs to be thrown as an error when there are Special Characters in the the Account Holder Name. And in personal payment method page I'…
-
Extract all data from PAY_RUN_RESULT_VALUES and PAY_RUN_BALANCES tablesSummary: We have a requirement to extract all data from PAY_RUN_RESULT_VALUES and PAY_RUN_BALANCES tables since go live. We tried to build a BIP Report and running them …Phaneendra Vallapu 117 views 6 comments 0 points Most recent by RithwikSivanand111111 Reporting and Analytics for HCM
-
ytd payroll balance values using pay_run_balancesSummary: How to fetch the Ytd balance value of the Gross Pay,Net and Employee tax deductions using pay_run_balances table Content (please ensure you mask any confidentia…susmita 1K views 2 comments 0 points Most recent by Bhagya Kalla Payroll and Global Payroll Interface (GPI)
-
Under Payroll relationship, end date is not updating when reverse termination payroll performedSummary: When we performed reverse terminate payroll under Payroll relationship> Payroll Association, End date is not reverted . Post Reverted , End date is not changed …Shwetha_01 61 views 4 comments 1 point Most recent by Parag Hiremath Payroll and Global Payroll Interface (GPI)
-
OTBI error when running reportSummary: Hi all, Is anyone able to help me understand why this error message is being displayed when a HR user tries to run this report showing details of a particular e…
-
Duty travel resumption report is showing for employee not for contingent workerUser A who is a cwk and User B is a emp, both of them are having exact payroll roles. But for user A the Duty travel resumption report is not populating the data only co…
-
Regarding W2 Allocated TipsSummary: Hi Team, We have configured Allocated Imputed earnings element and mapped allocated tips results element at balance feeds and created balance group required rel…User_HN2QF 11 views 0 comments 0 points Started by User_HN2QF Payroll and Global Payroll Interface (GPI)
-
Certified payroll - Has Oracle provided delivered reports for certified payrollSummary: Has Oracle provided delivered reports for certified payroll? Can someone, please share any leads to achieve the requirement? Content (please ensure you mask any…Suppu 51 views 2 comments 0 points Most recent by Trisha Hastings Payroll and Global Payroll Interface (GPI)
-
Payroll administrator is unable to see records updated by Fusion HCMWe have an analysis created using subject area Payroll - Personal Payment Details Real Time. I can see all records having been updated by any user but our Payroll Admini…Deana Wittman 22 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Time card details based on payroll flow - Load Time Card BatchesHi Expects, Requirement : Need to fetch time card details based on payroll flow - Load Time Card Batches. basically OTL report , based on payroll flow parameter. when we…Rajdeep Chavda 83 views 6 comments 0 points Most recent by Om Shukla-Oracle Reporting and Analytics for HCM
-
which hdl used to create individual balance adjustmentsSummary: We are looking for the hdl to create the individual balance adjustment for the person Content (please ensure you mask any confidential information): We are look…Balaji Vijayakumaran 63 views 6 comments 0 points Most recent by Balaji Vijayakumaran Reporting and Analytics for HCM
-
Where are Social Security Wages in OTBI?I'm trying to report on information from W-2s, specifically the Social Security Wages from box 3 in the W-2. Where do we find that information in OTBI, specifically Soci…