Payroll
Discussion List
-
An internal assertion test couldn't be completed at location ReportUtils.validateArchiveDefn:2.Summary: Non - US payroll extract is giving the error in one of the scheduled runs in production: An internal assertion test couldn't be completed at location ReportUtil…Shilpa Varghese 241 views 4 comments 0 points Most recent by Shilpa Varghese Reporting and Analytics for HCM -
An internal assertion test couldn't be completed at location ReportUtils.validateArchiveDefn:2.Summary: Non - US payroll extract is giving the error in one of the scheduled runs in production: An internal assertion test couldn't be completed at location ReportUtil… -
state unemployment wages by jurisdiction reportSummary: I am trying to create a report that shows state unemployment wages by state jurisdictions. I created one in OTBI using the Payroll - Payroll balances real time …JDCal 15 views 1 comment 0 points Most recent by Rakesh Ghosh-Oracle Reporting and Analytics for HCM
-
not able to fetch latest date even after using MAX functionHi team i am trying to fetch latest last update date record in below query but unable to do it.i am looking for 2022 as a latest date record but when i use max function …Chetana Pawar 11 views 1 comment 0 points Most recent by Rakesh Ghosh-Oracle Reporting and Analytics for HCM
-
Need inputs to get the YTD, QTD, MTD balance values using Pay_run_balances tableSummary: Need inputs to get the YTD, QTD, MTD balance values using Pay_run_balances table Content (required): In the Pay_run_balances table able to see "RUN" related bal…
-
Combing Two Rows into One Based on Person Numberhttps://us.v-cdn.net/6034893/uploads/GBYJEUBQX1Z5/us-audit-report.txt Hello everyone, We're working on the earnings report and there are some employees have two assignme…Yiming Xiong 22 views 10 comments 0 points Most recent by Yiming Xiong Reporting and Analytics for HCM
-
User Entity to capture US Tax withholding HistoryHi Team, we have built a custom changes only Integration(HCM Extract) to capture the New W4 calc card Information. But all the User Entity we can currently find are prov…
-
Address Autocomplete for the US: Trigger when Address Section is not pouplatedSummary: We created an autocomplete rule to validate US Home Address in transactions like Add Pending Worker, Hire an Employee, Create Work Relationship, Local and Globa…Bianca Lei Villareal 1 view 3 comments 0 points Most recent by Bianca Lei Villareal HCM Experience Design Studio: Autocomplete Rules -
SQL for Payroll Element Calculation FactorsSummary: Hi all, does anyone have any SQL that extracts element calculation factors? Element Name, Calculation Step, Calculation Value Definition, Range Values etc… Than…Jon Taylor 104 views 1 comment 0 points Most recent by Rakesh Ghosh-Oracle Reporting and Analytics for HCM
-
Payroll HCM - What tables would show historic scale points and hourly rates for that scale point.Hi , I'm currently looking into a request from one of my colleagues asking if it's possible to have our Holiday Accrual report have the Hourly rate reflect March 2024 pa…Josh Dewar 11 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Is there a way to see the Oracle tables & selection criteria used to generate Payroll Activity Rpts?Summary: Several of our BI Publisher payroll reports, which have successfully reconciled to Oracle Payroll Activity Reports for the same timeframes for the past five yea…BeachDreamer 23 views 2 comments 0 points Most recent by BeachDreamer Reporting and Analytics for HCM -
Can we update the scheduled HCM extracts schedule time?Instead of cancel the exisitng flow and create new one with new schedule time, can we update the schedule time of existing flow? -
How to End Date Extract Definitions?Hello, Normally after a P2T is performed I would go into the Extract Definitions and end date the FTP delivery to insure no file would be sent to a vendor for example AD… -
Need assistance to get YTD balance using pay_balance_view_pkg.get_balance_valuesSummary: We are trying to get YTD balance using pay_balance_view_pkg.get_balance_values. I am using the attached query, but it is not returning any result, though employ…
-
What is the OTBI Subject Area for State Wise Minimum Wage?Hi Team - Can anyone please let me know the OTBI subject area for State Wise Minimum Wage. The DB tables for the same are PAY_VALUE_DEFINITIONS_F and PAY_RANGE_ITEMS_F. …Ramya Rajendran 21 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Performance Issue - HCM Extract that retrieves quarter to Date Balance for the last 5 quartersI created an HCM Extract that returns the quarter to date balance of a specific balance group. I need the last 5 quarters and I was able to retrieve the data I need by m…
-
Filter OTBI report using dff's effective start date and effective end dateSummary: Need to filter dff data using effective start and end date Content (please ensure you mask any confidential information): I created a analysis report which has …Taushif Anwar 121 views 10 comments 0 points Most recent by Taushif Anwar Reporting and Analytics for HCM
-
Possibility to do Gross Pay in OTBIContent I am working on a report to show gross pay and specific imputed earnings during a specific date range divided by pay dates. I am attempting this report with Orac…User_2025-02-10-19-21-48-801 135 views 8 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Customer wanted to automate the process to send payslip over personal email for terminated employeesSummary: Hi Team, Would you please help us to get the steps how to achieve the requirement "automate the process to send payslip over personal email for terminated emplo…Rama123-Oracle 108 views 3 comments 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM