Payroll
Discussion List
-
How to enable dynamic password while generating the payslipSummary: Hi All, Requirement: I need to make payslip dynamic password protected. For Example - Date of birth of the employee. Thanks. Content (required): I followed the … -
Report to trace the elements costed from Journal entries along with transaction numberSummary: Report to trace the elements costed from Journal entries along with transaction number Content (required): Hi Team, Greetings! Once the entire payroll cycle is …Parag Hiremath 23 views 3 comments 0 points Most recent by Fazal Subhan Reporting and Analytics for ERP -
Employee Active Payroll balance reportSummary: Employee Active Payroll Balance Report Content: We have a requirement to include New Mexico Workers' Compensation for both Employee and Employer in the Employee… -
Payroll Report Pulling Wrong Assignment Manager in BI ReportI'm working on updating a Payroll Last Row Validation Report. It is currently pulling the wrong assignment manager for the last effective dated change on their employmen…
-
BI Report in payroll flowSummary: I’m trying to add a BI report in a payroll flow. I’ve done everything, and when I run the flow, the payroll gets calculated successfully. But when it reaches th…
-
Query to find hr_assignment_id/assignment_id for which payroll has been RunSummary Find link between payroll run and assignmentContent Hello Team I need a query to find the assignment for which a payroll(quick pay/Regular payroll) has been run …AvishekNandi 677 views 3 comments 1 point Most recent by Vishal Hinduja Reporting and Analytics for HCM
-
SQL/OTBI query to get the Organization Payment Method and Payment sourcesSummary: SQL/OTBI query to get the Organization Payment Method and Payment sources Content (please ensure you mask any confidential information): We are looking a report…Visu 466 views 5 comments 0 points Most recent by GajavalliKoteswararao Reporting and Analytics for HCM
-
need Sql Query of the balances with the below shown fieldsneed the SQl query which as fields like FIT Reduced subject witholdable FEDERAL TAX MARITAL STATUS FEDERAL NUMBER OF EXEMPTIONS STATE JURISDICTION INDICATOR YTD STATE TA…Kande_Likhitha 29 views 5 comments 0 points Most recent by Kande Likhitha Reporting and Analytics for HCM
-
Payroll HCM Extract: Third Party Roll Up User EntitySummary: Would like to inquire if there are User Entities that could retrieve the Third Party Roll Up for Third Party checks in HCM Extract. We have identified that pay_…
-
Does anyone have a SQL Query or OTBI report that will list by employee hours worked for the year?We are needing 2024 Paid Hours. We tried running the Periodic Payroll Activity Report but because the data is so large when including hours, it will not complete. I need…
-
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 381 views 6 comments 0 points Most recent by Rini_Varghese-Oracle Reporting and Analytics for HCM
-
employee tax declaration table name in fusionSummary: Content (please ensure you mask any confidential information): Hi team , need help on table name . where we will get all employee chooses which tax regime data … -
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 8.1K views 112 comments 34 points Most recent by Kaushik R-Oracle Reporting and Analytics for HCM -
Issue in Salary Certificate DORSummary: Issue in Salary Certificate DOR Content (required): Hi All, We are facing the issue in salary certificate DOR. Salary certificate is working fine in draft versi…
-
Query to fetch Run Result Element Entries & Balances for particular time periodSummary: We have a requirement to pull element entries & balances from Run Results for the particular time period. I have written the below query but which is giving mul…
-
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 381 views 8 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Payroll Element Entries History excluding terminated employeesSummary Payroll - Element Entries History Real Time subject area is excluding terminated employeesContent I have created a report to pull Annual Salary and Annual Bonus …
-
Generate run balances seeded processSummary: If we run Generate Run Balances need to know what all are the transactions/records are added/updated in the Pay_run_balances tables Content (please ensure you m…
-
Payroll query that fetches results only if for the Employee Generate Payslip flow is not run.Summary: I need to create a BI report which retrieves Employee Information of the users along with other Common columns also needed to see if whether is employee get pai…Ketan-Oracle 1 view 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
HCM Transformation Fast Formula : Getting all Metadata for AssignmentWe are trying to develop Worker.dat which will include Workterm and Assignment Metadata why We are able to get all the required fields metadata for worker but somehow as…Ajitabh Kumar-Oracle 32 views 2 comments 0 points Most recent by User_VB3A0 Reporting and Analytics for HCM
-
Reporting for Workers CompGood morning. I am in need to find a report that will show rates and also a worker's comp audit report. Has anyone had success with these types of reports.?Tisha Negrete 52 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Enterable Calculation Values on Calculation Cards - Query/ReportSummary: Enterable Calculation Values on Calculation Cards - Query/Report Content (required): Hi Team, Greetings! Does anyone have the report or query to extract the dat…Parag Hiremath 105 views 6 comments 1 point Most recent by Ankammarao Reporting and Analytics for HCM
-
Payroll Flow - BI Report - Bursting - Not generating output file.Hi folks, I'm generating a payroll report and pushing it on SFTP using bursting. Template, filename and path is derived via bursting .This report is attached to a Payrol…
-
How to customize the seeded deduction report?Summary: We would like to add additional columns like assignment status to the standard deduction report that runs part of the payroll flow. What is the recommended appr…
-
Run Payroll Costing Results - load column into FDI?Hello, Is there a way to take a column from the seeded Run Payroll Costing Results report and move that into FDI for reporting use? The need for it is stemming from payr…Sean-B-01 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to return specified run result values on one row in Payroll Run ResultsSummary: Without using a pivot table, how can I get payroll run results to show input value names as the column headers, then the relevant run result values horizontally…
-
Looking for advice regarding creation of a report to load details into Costing for PersonsSummary: We currently have a report in place which gets run daily to load information via HDL to load into the Costing for Persons. It has been made aware the report is …
-
Is anyone using an Oracle Custom Form for W4Summary: We are live with Oracle Core HR, Advanced Comp. Our Payroll and time tracking is still on our legacy system. We are looking for a way to capture W4 information …Neno Kolonich 3 views 0 comments 0 points Started by Neno Kolonich Payroll and Global Payroll Interface (GPI) -
Payroll Report HelpI'm working on updating a Payroll Last Row Validation Report. It is currently pulling the wrong assignment manager for the last effective dated change on their employmen…
-
SQL Query based on date input value errorSummary: SQL Query based on date input value error Content (please ensure you mask any confidential information): We are trying to run the below query to be used in a va…