Payroll
Discussion List
-
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 68 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…User_2025-02-05-22-44-35-842 98 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 118 views 1 comment 0 points Most recent by MandeepGupta 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 41 views 3 comments 0 points Most recent by Parag Hiremath 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 145 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 42 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 437 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 52 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 52 views 1 comment 0 points Most recent by Harish Vummidi 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 22 views 4 comments 0 points Most recent by Gail Langendorf-Oracle 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 72 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…
-
State tax details in hcm fusionSummary: I am looking for the below details in the state tax setup level state tax type state Minimimum wage state of the tax defined Please guide me to refer the table …
-
SQL or table to get the PAY_PAYROLL_TIME_TYPE ID of time and tasksgood morning experts We are working on a time and tasks report and we did not find the PAY_PAYROLL_TIME_TYPE ID, only the code and the name, could you help us with the S…
-
Display Values Across ColumnsSummary: I am querying voluntary deductions and using input value names of Amount, Percentage, Total Owed and Vendor Name. Because the Displayed Input Value is one colum…Julie Mandel 34 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Link between Balance and Primary details Element NameSummary: Link between Balance and Primary details element name Content (required): In Balance Definitions UI we have Primary Details Element Name. In which table/OTBI Su…
-
Last Paid DateSummary: Looking to pull a report on active employees that shows the last date they were paid/payslip was generated? Content (required): Version (include the version you…Jessica D 45 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Does anyone have information about the Oracle stored procedure pay_balance_utility?Summary: Content (required): pay_balance_utility is mentioned in an Oracle doc but then the support team claims not to have access to any information about it. Version (…Scott Paulin 23 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Unable to extract the results of the notifications sent using BI Publisher with Bursting.Summary: if seeded report got bursted one notification through EMail to X Users, is it possible can we get notification delivered date. If yes what are the tables involv…Sivaram Injeti 42 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM
-
Unable to get the Calculation card Federal Start Date valueSummary: Unable to get the Calculation card Federal Start Date value in OTBI/BIP query Content (required): I am unable to get the Federal Start Date value in OTBI/BIP qu…
-
Current performance calibration and overall target OTBISummary: Content (required): Hello everyone, We are having issues with an OTBI related to the performance dashboard for the Manager. In particular, the otbi "Current per…Gerardo Peluso 51 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Need formula for Date Paid is in last calendar monthSummary: I have a report using Subject Area Payroll - Payroll Balances Real Time. The report will run on the first day of every month and will capture the number of hour…
-
California Pay Data Reporting UpdateSummary: The California pay data reporting requirement is getting updated. Is Oracle developing an update to the delivered report to account for this? Content: Existing …
-
May I know which subject area suitable for below columns ?Summary: Hi Team, May I know which subject area suitable for below columns ? unable to find ? Thanks, Ajay Content (required): Version (include the version you are using…AjayKumar Maddipati 22 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM