Payroll
Discussion List
-
Trying to find the job details from the grade table through valid grades tableSummary: We are developing the grade ladder report in that we need to get the job details for the grades. However, we get duplicates due to the multiple valid grade IDs …Rengaraj G 11 views 1 comment 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
RTF template: Repeating field/section in payslipSummary: We have a requirement for the payslip that the Name, Person Relationship Number, and Payroll Name should be repeated if the payslip data continues in the 2nd/ne…Mark Jayson Tamaray 31 views 8 comments 0 points Most recent by Mark Jayson Tamaray Reporting and Analytics for HCM -
Benefit & Pension Calculation Card HistoryIs there an analysis or report that shows the history of a calculation card? I have an employee who was enrolled in main LGPS scheme up to 30 September 2023 but as of 1 … -
VBC HCM tables available for BI Query in lab pod? POCSummary: Are the Value By Criteria tables available for BI Query Data Model? Content (please ensure you mask any confidential information): Hello: I'm performing a Proof…
-
Federal Tax Withholding Filing Status - Pulling Data from TablesSummary: The Federal Tax Withholding Filing Status seen from the front end of the application is displaying a status that does not correspond with the Filing Status seen…ChicagoConsultant 17 views 1 comment 0 points Most recent by RWMATTHE-Oracle Reporting and Analytics for HCM
-
Table that Stores Fields on Tax Withholding Calculation Card- Filing StatusSummary Looking for table that stores filing status on Tax withholding calculation card when you select Federal Income Tax, Calculation Coponent DetailsContent Hi All, L…User_2025-01-30-00-53-42-934 1K views 5 comments 0 points Most recent by Sydney_Flahive Reporting and Analytics for HCM -
Unable to see newly created elements in OTBI reportThere was an error rendering this rich post.Shanna Oppenheim 21 views 5 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to link pay_costs table back to an organization_idSummary: How can I get pay_costs info to tie back to an organization_id? We want to be able to derive our costed department name the same way that the costing segments a…
-
Payroll Flow Pattern ReportSummary: Payroll Flow Pattern Report Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there a way to find out the programs which are…Parag Hiremath 46 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Trying to create a BI report to fetch out the payroll element entry data for employee.Here the data is flowing from ORC to Individual Compensation.When the employee is hired he will be awarded with some "BONUS" with some additional fields these data's wil…Jebarsan Thangam John Durai Raj 94 views 10 comments 1 point Most recent by Shanna Oppenheim Reporting and Analytics for HCM
-
Need SQL to extract the amount and periodicity of worker element entriesSummary: Hi Experts, Could you please provide SQL code that extracts the amount and periodicity of worker element entries? I need help with this requirement. Written thi…Hiba Ghoualmia 106 views 3 comments 0 points Most recent by MandeepGupta 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…Shilpa Varghese 192 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 11 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 13 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
-
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 85 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 12 views 2 comments 0 points Most recent by BeachDreamer Reporting and Analytics for HCM -
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 23 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
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 120 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 139 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 90 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 156 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 24 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
Active Bank Accounts with different Display NamesSummary: I have a request to create an OTBI report which shows the active banks accounts with different Display Names against them, these names are likely to be spouses …
-
EEO-1 report output format in HCM CloudSummary: EEO-1 report output format in HCM Cloud Content (please ensure you mask any confidential information): We are in the process of generating EEO-1 reporting that …Parag Hiremath 21 views 6 comments 0 points Most recent by AlyssiaKing Reporting and Analytics for HCM
-
etext issue for multiple child tag printing with master record multiple timesSummary: Hi All, Need your suggestions on how to solve the below requirement: We have a created HCM Extract to deliver data to a third party Benefits provider The XML st…Prashant Prabhakar Fusion 4 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM