Payroll
Discussion List
-
Duplicate and Missing Payroll Payment Records for EmployeesContent (please ensure you mask any confidential information): I'm encountering an issue where the query returns two rows for a person one with the correct payment statu…User_VQ154 21 views 1 comment 0 points Most recent by Soumya Suravita Reporting and Analytics for HCM -
Build a BI Publisher Report that tracks incremental changes in Core HRSummary Build a BI Publisher Report that tracks incremental changes in Core HRContent Hi Experts, I have a requirement for a BI Report wherein I need to pull a lot of ch…Aloka Bhattacharya 478 views 10 comments 1 point Most recent by Naresh Choudhary Reporting and Analytics for HCM -
Maximum report data size for offline (scheduled) reports value changeSummary: Maximum report data size for offline (scheduled) reports value change Content (please ensure you mask any confidential information): Hi Team, Greetings! How do …Parag Hiremath 21 views 3 comments 0 points Most recent by MitG-Oracle Reporting and Analytics for HCM -
Calculation Card Component - Provincial Tax CardSummary: Column / Table where the Location held on the Provincial Tax Card is stored. Content (required): Hello experts, We've been trying to report on the Calculation C…
-
How do I report on the field 'Order Reference'In Court Order Calculation Card page, I need to report on the Order Reference field - how and where can this be found?Helen Tilling 2 views 2 comments 0 points Most recent by Helen Tilling Reporting and Analytics for HCM
-
Report to pull all Payroll balances to move from one TRU to anotherSummary: Does anyone have a report they have used in the past to pull all balances for an employee, in order to do balances adjustments due to incorrect TRU? Content (pl…
-
Query for State Tax Withholding details for all statesSummary: Hello! I am looking for the BI query for State Tax Withholding. Thank you in advance! Content (please ensure you mask any confidential information): Version (in…
-
How do we get the Pay Period Month , Year , Max Gross Pay MTD in OTBISummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to load employee into object group through HDLSummary: Client is asking bulk load of employee into payroll object Group any HDL simple .dat file Content (please ensure you mask any confidential information): Version…Ratan Nahak-Oracle 46 views 4 comments 0 points Most recent by Anna-MariaP Reporting and Analytics for HCM
-
Need inputs to fetch balance "Reference" field value against balance dimensionSummary: Need inputs to fetch balance "Reference" field value against balance dimension Content (required): In the Employee Payroll balance results we are able to see Ba…
-
Standard payroll reportsSummary: Hi All, Please share all the payroll standard reports list. Best Regards, SateeshSateesh Kumar M 11 views 4 comments 0 points Most recent by Sateesh Kumar M Reporting and Analytics for HCM
-
how to delete status processing rule using hdlSummary:How to delete status processing rule using hdl Content (please ensure you mask any confidential information): Version (include the version you are using, if appl…
-
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 965 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 1 view 0 comments 0 points Started 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 …
-
While running HDL to delete status processing rule from element i am getting below errorSummary: While running HDL to delete status processing rule from element i am getting below error METADATA|StatusProcessingRule|EffectiveStartDate|StatusProcessingRuleId…
-
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 296 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 12 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 2 views 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…Nicole A. 2 views 1 comment 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Payroll Report Pulling Wrong Assignment Manager in BI ReportI'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…Nicole A. 21 views 6 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
How to enable dynamic password while generating the payslipSummary: Hi All, Requirement: I need to make payslip dynamic password protected. For Example - Date of birth of the employee. Thanks. Content (required): I followed the …
-
Report to trace the elements costed from Journal entries along with transaction numberSummary: Report to trace the elements costed from Journal entries along with transaction number Content (required): Hi Team, Greetings! Once the entire payroll cycle is …Parag Hiremath 21 views 3 comments 0 points Most recent by Fazal Subhan Reporting and Analytics for ERP
-
Employee Active Payroll balance reportSummary: Employee Active Payroll Balance Report Content: We have a requirement to include New Mexico Workers' Compensation for both Employee and Employer in the Employee…
-
BI Report in payroll flowSummary: I’m trying to add a BI report in a payroll flow. I’ve done everything, and when I run the flow, the payroll gets calculated successfully. But when it reaches th…
-
SQL/OTBI query to get the Organization Payment Method and Payment sourcesSummary: SQL/OTBI query to get the Organization Payment Method and Payment sources Content (please ensure you mask any confidential information): We are looking a report…Visu 740 views 5 comments 0 points Most recent by GajavalliKoteswararao Reporting and Analytics for HCM
-
need Sql Query of the balances with the below shown fieldsneed the SQl query which as fields like FIT Reduced subject witholdable FEDERAL TAX MARITAL STATUS FEDERAL NUMBER OF EXEMPTIONS STATE JURISDICTION INDICATOR YTD STATE TA…Kande_Likhitha 41 views 5 comments 0 points Most recent by Kande Likhitha Reporting and Analytics for HCM
-
Payroll HCM Extract: Third Party Roll Up User EntitySummary: Would like to inquire if there are User Entities that could retrieve the Third Party Roll Up for Third Party checks in HCM Extract. We have identified that pay_…