Payroll
Discussion List
-
Which table stores Payroll Association dates?Summary: We are able to report on Payroll Relationship Final Close date and specific Payroll Assignment dates, but cannot find the data for Payroll Association Final Clo…TraciH-NorthBayHealth 1.2K views 6 comments 0 points Most recent by awheel09 Reporting and Analytics for HCM -
OTBI field results cut offSummary: When I run the attached XML in OTBI, the field results in the vendor name are being cut off. Content (please ensure you mask any confidential information): An e…Julie Mandel 11 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Seeded Deferred Compensation Overlimit Balance Exception report has incorrect formula valueSummary: Balance Exception Report for Deferred Compensation Overlimit with exception name 401k Over the Limit has incorrect formula value Content (please ensure you mask…Karen Settembrino 13 views 0 comments 0 points Most recent by Karen Settembrino Reporting and Analytics for HCM -
How to create Parameterized HCM Extracts which is linked with BIP Report?Summary: Hello, We have a requirement to load a data using HDL by getting a data from HCM Extracts which is also linked to BIP report. We have achieved this without any … -
How to retrieve/calculate fiscal year for payroll period otbi reportSummary I would like to add fiscal year and calendar year in payroll by period OTBI reportContent Hi Team, I have created a prompt name toggle with 2 fields(calendar and…Kalyani Koylada 305 views 3 comments 0 points Most recent by Nidhi Chhajed Reporting and Analytics for HCM -
Is it possible to report on element config? (e.g. is it taxable, pensionable etc)Summary: I'm looking to create an analysis which shows me the configuration of each element in terms of which have been set as taxable, pensionable, which payrolls they …BFell 11 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
We are looking for the SQL to fetch the last updated by/last updated date of wage basis rule.Summary: employee from NJ state (US). When we ran the payroll the amount for element named Deferred comp regular was recorded under pretax deduction balance. This was be…Bhushan Kulkarni 1 view 1 comment 0 points Most recent by Shyam Rajbhar Reporting and Analytics for HCM -
Payroll DD/Taxes Report SQL HelpWe have a New Hire Direct Deposit/Tax report that captures employees who have not completed DD and/or Taxes. How would I update the query to pull all new hires/rehires (… -
Payroll Report HelpI'm working on updating a Payroll Last Row Validation Report. It is currently pulling the wrong assignment manager for the last effective dated change on their employmen…