Get Started with Redwood: Oracle Cloud SCM and Purchasing
Payroll
Discussion List
-
How to pull in correct payroll number of employees in BI Publisher reporting?Summary: I have put together a query where my joins for payroll number are bringing some duplicate lines into my record. On investigation, the joins are not bringing the… -
Changes Only Extract not picking the ORC Promoted EmployeesSummary: What is stopping the Changes only extract not to pick the employees promoted through ORC? Content (required): We have developed a Changes Only extract which sen…
-
Need help on arrears balance ReportSummary: Content (required): Hello, We are trying build a custom arrears balance for both active and terminated employees. We do not have anything available for terminat…Ganesh G 202 views 3 comments 0 points Most recent by Catherine Chan Reporting and Analytics for HCM -
SQL query to fetch element status processing rule of a element.Summary: We need a SQL query to fetch the element status processing rule of an element. Version (include the version you are using, if applicable): 23APiyush Pokharkar-Oracle 1.3K views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Payroll Element and Related Elements InformationSummary: Payroll Element and Related Elements Information Content (required): In the Payroll Element screen we have Related Elements. We need to know in which table/subj…
-
SQL for Element Status Processing RulesSummary SQL for Element Status Processing RulesContent We are looking for a SQL to display element status processing rules where we attach the element to a fast formula …User_2025-02-01-07-38-26-148 163 views 2 comments 0 points Most recent by Piyush Pokharkar-Oracle Reporting and Analytics for HCM -
Does anyone know in which table 'Domicile state other than the District of Columbia' field is storedSummary: I am not able to find in which table the State card component 'Domicile state other than the District of Columbia' field from calculation card (Tax withholding …SowmyaSk 41 views 1 comment 0 points Most recent by Raju Sandepogu-Oracle Reporting and Analytics for HCM
-
HR_6882_HRPROC_ASSERT errorSummary: HR_6882_HRPROC_ASSERT error Content (required): Hi Team, Greetings! We have run into error for the direct deposit process with error log summary as- BIP job pro…Parag Hiremath 94 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Generate automatically incremented check numbers for "Generate Check Payments" processExperts, Request your help here. Can we add custom parameters in a flow pattern copied from "Generate Check Payments"? We need to retrieve the last generated check numbe…Aloka Bhattacharya 42 views 0 comments 0 points Started by Aloka Bhattacharya Reporting and Analytics for HCM -
Arrears report with Current Deduction And Total ArrearsSummary: Hi, I am trying to create a report that will show current deduction taken for Med, Dental, Vision Arrears along with how much the total is and if the full amoun…
-
Gross Pay - Previous Week and YTDSummary Would like to be able to report out on the previous weeks' gross pay along with the year to date balanceContent Currently we have two reports. One to pull the pr…Kyle Norris 150 views 6 comments 0 points Most recent by Deekshith Kalluri Reporting and Analytics for HCM
-
What table to query for Individual Balance adjustments in PayrollSummary: Hi, I am looking for the table in OTBI that can be used to query any manually keyed Individual Balance Adjustments. If anyone has an SQL, it would also be great…Bonnie Lafferty 281 views 2 comments 0 points Most recent by Bonnie Lafferty Reporting and Analytics for HCM -
Need inputs to fetch the "Third Parties" (My client groups-->Third Parties) informationSummary: Need inputs to fetch the "Third Parties" (My client groups-->Third Parties) information Content (required): We need to know table name/OTBI subject area to fetc…
-
Data is not coming in an otbi report once ldg is added.Summary: Content (required): In an custom otbi report, data is not coming once ldg is added to that. Version (include the version you are using, if applicable): Code Sni…Swati Rana 31 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
OTBI error when running reportSummary: Hi all, Is anyone able to help me understand why this error message is being displayed when a HR user tries to run this report showing details of a particular e…
-
How to get Active Bank Account DetailsHi Experts I am trying to write a query to get Active Bank Account Details for a given employee. I am not sure in which table and column this flag is stored. I checked "…Dharmendra Shukla 446 views 4 comments 0 points Most recent by Dharmendra Shukla Reporting and Analytics for HCM -
Need inputs for 401k Contribution ReportSummary: Need inputs for 401k Contribution Report Content (required): Hi Team Greetings! This is about getting the details for 401k contributions report including deferr…Parag Hiremath 75 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM
-
Audit report For Tax Withholding Calculation cards and table for Association, Federal & RegionalSummary: Need to develop a report that captures any changes made to the employee’s Tax Withholding cards such as Association,Federal, Regional. This report will be run u…User_2025-02-12-00-53-03-661 167 views 2 comments 0 points Most recent by Monika_Dubey Reporting and Analytics for HCM
-
Looking for HDL to upload Calc Cards for bulk employee movements from PT to FTSummary: Looking for HDL to upload Calc Cards for bulk employee movements from PT to FT Content (required): Version (include the version you are using, if applicable): C…
-
Manage IBAN with REST APISummary: Content (required): Hello everyone, We are having issues using the REST API to add an IBAN for a waiting employee/worker. In particular, we have developed a cal…
-
How to display MTD, QTD in payroll register report for latest processSummary: How to display MTD, QTD in payroll register report for latest process Content (required): As of now payroll register report displaying only Run and YTD values. …Munazeer Shaik 33 views 1 comment 0 points Most recent by Jim Kirkpatrick-Oracle Reporting and Analytics for HCM
-
Exception: The job attached to employee must have an EEO job category.Summary: Hi All, I am getting this in the EEO1 exception report . Any idea why its throwing this error? I have made sure that all the jobs that are used have the EEO cat…Gaurav Rath- PGC 53 views 3 comments 0 points Most recent by Shashank Priyadarshi - Oracle-Oracle Reporting and Analytics for HCM -
Delivered Report for State TaxSummary: Checking for delivered Report which provides State Tax Withholding details for all states. Content (required): We have built a custom report for State Tax Withh…Seema Kalantri 42 views 2 comments 0 points Most recent by Seema Kalantri Reporting and Analytics for HCM
-
Time and Labor Entries by BatchSummary Looking for a query of Time and Labor Entries by Payroll Transfer BatchContent We’d like to be able to report on the entries that were loaded from Oracle Time an…User_2025-02-04-10-25-07-624 73 views 5 comments 1 point Most recent by Santhosh T Murthy Reporting and Analytics for HCM
-
Payroll costing - position levelSummary: Breaking down the payroll costing report by position. Content (required): For example, if an employee had a position change on the 15th of September, is there a…User_2025-02-11-21-40-21-159 32 views 3 comments 0 points Most recent by PEEYUSHARORA Reporting and Analytics for HCM
-
Get Journal Entries Details For An EmployeeSummary: Team We would need to fetch Accounting Date & Transaction Number From Journal Entries. (GL) For An Employee Columns are: Accounting Date Transaction Number Payr…Manoharan 517 views 1 comment 0 points Most recent by Raluca.S - Fusion GL Oracle-Oracle Reporting and Analytics for ERP
-
Payroll Arrears Audit ReportSummary Allows you to audit for any arrears deductions prior to finalizing payrollContent This audit report is run after the first payroll calculation to check for arrea…Becky Stalsby 256 views 4 comments 4 points Most recent by Stephanie Turner Reporting and Analytics for HCM -
Payroll Element QuestionnaireSummary: Looking for a query to Fetch the Payroll Element Questionnaire Details Can any body Please share a query to Fetch the Payroll Element Questionnaire details Cont…MilanMohanty 320 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Calculation Component Reference Values vs. NamesSummary: In Oracle HCM OTBI: Is there a way to add in the from the person calculation card, earnings distribution override screen the name of the component reference as …User_2025-03-07-05-52-31-902 22 views 1 comment 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Calculation Card Reporting - CitySummary: We need a way to report on employees that have a split percentage city tax (part work city & part home city to represent working partially in office vs. remote)…Chelsea Holden 22 views 1 comment 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM