Payroll
Discussion List
-
How to get the actual Effective Start Date of the Grade assigned to the employee?I'd like to fetch the effective start date of the person's Grades. The actual date when the Grade was assigned to that person. Because currently I'm using the following …
-
Payroll Flow PatternSummary: Does anyone have a sql they have used to get a dump of all payroll flow patterns and the corresponding tasks and following task in a pod? Including Created By, …Jen Barthel 11 views 2 comments 0 points Most recent by Venkat Balasubramanian-Oracle Payroll and Global Payroll Interface (GPI)
-
Want to change the configuration for salaried employees timecard.Summary: we want to change current configuration for salaried employees whose timecards information going to payroll,we want this to modified in such a way that only abs…
-
Omar El-sherif 21 views 2 comments 0 points Most recent by Venkat Balasubramanian-Oracle Payroll and Global Payroll Interface (GPI)
-
Prompts are not showing while scheduling the OTBI AnalysisThere are 4 prompts in the Analysis. But when we try to schedule the report, these parameters/prompts dont show up in the General tab. Please suggest.Dona Das-Oracle 11 views 2 comments 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
BIP Report Citibank PaycheckHello everyone, I would like to ask if you have or if there are any existing RTFs that follow the specifications for Citibank Paycheck. Thank you.CAMIL_Q 1 view 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Sql to fetch reason from payment details pageHi Team i want to fetch the reason column from payment result screen. Please find the attachment for referance.Chetana Pawar 11 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
PAY_MESSAGE_LINES tableTeam, We have a requirement to get all the error messages run by payroll process (Payroll Message Report - Flow). We have developed the report and getting the message na…Manoharan 45 views 1 comment 0 points Most recent by Gabriel D-Oracle Reporting and Analytics for HCM
-
All Active employees that receives no pay or $0 gross pay for any pay periodSummary: There is a requirement where client need a report having list employees receiving no pay or 0$ Gross pay based on previous 26 pay periods. We have a bi-weekly P…Rahul Saini 21 views 1 comment 0 points Most recent by Anca Andronic-Oracle Payroll and Global Payroll Interface (GPI)
-
-
expedited element entries querySummary: Hi, We have a report about the expedited element entries but not for HCM Extracts. Do you have any sample query about how to get this report?
-
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…
-
Any report or query to get Error subprocesses from the payroll flowSummary: Any report or query to get Error subprocesses from the payroll flow Content (please ensure you mask any confidential information): Hi Team, Greetings! When a pa…Parag Hiremath 21 views 7 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How do I create a severance report using payroll run result real time subject area ?I am trying to build a severance report for codes - SVR, RTN, SVK, SVL, WRN. I am looking to get the earnings in the below format but I am struggling to find the fields …Trupti Khodke 42 views 4 comments 0 points Most recent by Trupti Khodke Reporting and Analytics for HCM
-
Unable to generate payslip in biweekly employeesSummary: We processed usual payroll flow in pods however for biweekly employees, Datas are not generating. Content (please ensure you mask any confidential information):…Pablo Calizo 12 views 1 comment 0 points Most recent by Chai-Oracle Payroll and Global Payroll Interface (GPI)
-
Can we Autopopulate TRU as per the Legal Employer, when when hiring an employee.Summary: When hiring an Employee/converting a Pending Worker, in the Payroll detail section, we need to auto-populate the TRU as per Legal Employer. Is this achievable t…Megha N. 11 views 1 comment 0 points Most recent by Chai-Oracle Payroll and Global Payroll Interface (GPI)
-
SQL query to get CPP Exempt and EI Exempt status from Tax Crdit InformationSummary: SQL query to get CPP Exempt and EI Exempt status from Tax Crdit Information Content (please ensure you mask any confidential information): Need SQL query to get…
-
Need Data base Oracle tables stored ThirdPartyOrganizationPaymentMethod details.I am working on a conversion BIP report for ThirdPartyOrganizationPaymentMethod . Can you please share a sample SQL to query these information we loaded using HDL.…
-
Assignment Organization and relationship to Worked Hours and DollarsSummary: Assignment - Worked Organization Content (required): What is the purpose of the Assignment Organization and how does it relate to where the employee worked for …Jill 11 views 1 comment 0 points Most recent by Chai-Oracle Payroll and Global Payroll Interface (GPI)
-
For Statutory Deductions Register, how to segragate Federal and Provincial Totals for Quebec?Summary: The statutory deductions registers gives totals while combining provincial and federals. For the province of Quebec, they need to remit separately to different …Nabil.S 21 views 1 comment 0 points Most recent by Chai-Oracle Payroll and Global Payroll Interface (GPI)
-
UK Check/Cheuqe Payslip ReportSummary: UK Cheque payslip report query Content (required): I am adding the SQL query for custom cheque payslip report. Employee will have the payment method as cheque o…Arti P 21 views 1 comment 1 point Most recent by Chai-Oracle Payroll and Global Payroll Interface (GPI)
-
'Range Values' in calculation factor from element definition pageHello Experts, I have requirement to get all details of calculation factor , Please check below image to identify requirement. Thanks.Rajdip Chavada 31 views 2 comments 0 points Most recent by Chai-Oracle Reporting and Analytics for HCM
-
Translation in PAY_MESSAGE_LINESTeam, We have a requirement to display the payroll error message name and message text. We are using PAY_MESSAGE_LINES to get the details. But this table has only Englis…
-
Is there a report or query to see changes for employees Loans status before payroll runsHello All, Is there a report or query to see changes to employees Loans status before payroll runs, for example if they refinance , new etc? Thanks, Version 23CGail Wilmoth 21 views 2 comments 0 points Most recent by Chai-Oracle Reporting and Analytics for HCM
-
Does anyone know the arguments for pay_balance_utility.get_bal_grp_usage_values?Summary: Content (required): I would like to run a quick SQL to validate the balance group usage without creating and running a full HCM Extract. This procedure was ment…Scott Paulin 62 views 8 comments 0 points Most recent by Scott Paulin Reporting and Analytics for HCM
-
Payroll Balances Real Time not returning zero valuesContent We are using the folder Payroll balances Real Time to bring back for a payroll run those people who have zero gross pay, however, although in the person results …
-
I have a report with element totals and I need to filter so it only shows the total rowSummary: I was able to get totals by month for each element. Now I need to only have the Totals row visible. Any ideas? See below. I do not want each element total to sh…
-
Solutioning Data Archival for US(United States) and CA(Canada) Legislations.Summary: My Client has a requirement to archive complete fusion data and I want to understand how could we preserve anything and everything from Fusion HCM Cloud's Criti…SAHILVASYANI 41 views 5 comments 0 points Most recent by Anca Andronic-Oracle Payroll and Global Payroll Interface (GPI)
-
How to get Federal Tax Exempt and commission Information from Tax Calculation Card in OTBISummary: How to get Federal Tax Exempt and commission Information from Tax Calculation Card in OTBI Content (please ensure you mask any confidential information): Versio…