Payroll
Discussion List
-
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 103 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 105 views 3 comments 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
Personal Payment Method HistorySummary How to find out if the Employee has Added, Updated or Deleted a Payment Method?Content Hi All, I am trying to build a Personal Payment Method History Report in w…User_2025-01-31-02-00-10-435 153 views 8 comments 1 point Most recent by Isabela Radivoi Reporting and Analytics for HCM
-
Is there any seeded report for Payroll Analytics Initiative?Summary: Is there already Oracle seeded report for this? Content (please ensure you mask any confidential information): Version (include the version you are using, if ap…Cherry Carpo 21 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
How to make the Payroll Relationship mandatory for Hire an Employee transaction through ResponsiveSummary: We have a requirement to make the Payroll Relationship mandatory for Hire an Employee transaction through Responsive UI. Any insights on this requirement? Conte…Rohit J 1 view 1 comment 0 points Most recent by Danny Cusnir-Oracle HCM Experience Design Studio: Autocomplete Rules
-
Which User Entity provides pay period start and end dates?Summary: I have PAYROLL_ACTION_ID & payroll_rel_action_id in the root data group. Which UE can provide start and end date of the pay period that payroll action id belong…
-
Query for Third Party payments along with involuntary deduction component referencesSummary: Delivered Third Party Payment Register Report is not fetching unpaid payments in the report along with the status. We need a query to retrieve the unpaid paymen…