Payroll
Discussion List
-
Need query to pull finalised or processed pay period namesSummary Need query to pull finalised or processed pay period namesContent Need query to pull only finalised or processed pay period details?ViswanathaReddyKetireddy 30 views 2 comments 0 points Most recent by ViswanathaReddyKetireddy Reporting and Analytics for HCM -
SQL query to get net pay amount of an employee on the monthly basisContent Hi All, Creating an outbound interface where need to fetch the employee's monthly net amount. Hence, need SQL query for the same. Context: Employee have multiple…Arti P 3.4K views 8 comments 0 points Most recent by Gopikrishna Nerella Reporting and Analytics for HCM -
Database Table and Database Column for Target Bank presentation tableSummary Need the parameters to build a BIP report for outputContent I am building a report that displays as a form completed for each new starter however it will not out…Dawn Cawston - CPS 30 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Query to pull earnings balance for each assignmentContent Need help on pulling earnings balance for each assignment or identifying which assignment has earnings.Renzel Keith Coquia-204674 55 views 2 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Employee Salary ReportContent Is there a seeded report (or a custom report you would share), that includes the wages for a period (entire year), including the employee name, date of hire, tot…Annette M 258 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to create a Custom Job Role (Read Only) for using "PAYROLL - ELEMENT ENTRIES REAL TIME" subjectSummary Need to create a Custom Role which gives read only access to UI and allow access to "PAYROLL - ELEMENT ENTRIES REAL TIME" subject areaContent Hello Experts I hav…Dharmendra Shukla 22 views 2 comments 1 point Most recent by Dharmendra Shukla Reporting and Analytics for HCM -
SQL query help needed - Payroll tablesSummary Reporting on those employees who have had a garnishment added in the selected payrollContent Hi All, I hope someone is able to help me out. I am trying to debug …User_2025-02-04-08-51-08-912 20 views 1 comment 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM -
Scheduled Report Returning only 25k rowsSummary Scheduled Report Returning only 25k rowsContent I have an OTBI report that i am running that has output greater than 25k rows but less than 65k rows. I thought i…User_EQ8R5 85 views 4 comments 0 points Most recent by Raymund Jerome Reporting and Analytics for HCM
-
OTBI - Reporting Monthly Net Pay ValueContent Hi all, Does anyone know the correct subject area and field to use in order to report on the net pay value an employee would receive? I've been looking at the fo…
-
Audit DahsboardSummary Need help finding Audit DashboardContent I remember seeing Audit Dashboard. I can't seem to find it. Does anyone know is there a Oracle delivered Audit Dashboard…User381997 68 views 1 comment 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need SQL query to fetch Balance Initialization/Balance AdjustmentContent Hi All, We are looking SQL query to fetch the Balance Initialization/Balance adjustment data. Please share SQL query if anyone is having in handy. Thanks, Visu
-
Active employees that have a zero net paymentSummary Looking for an analysis/report that shows active employees that received a zero net payment for a pay periodContent Hello, I am looking for a report/analysis tha…User_2025-01-31-02-45-52-854 48 views 3 comments 0 points Most recent by Prudhvi Indukuri Reporting and Analytics for HCM
-
Missing Payroll Element within OTBISummary Missing Payroll Element within OTBIContent I cannot see an Element with Element Classification Name = Information and at the Payroll Relationship Level within El…Andrew_Schmitz 40 views 4 comments 0 points Most recent by ravikiran goda-Oracle Reporting and Analytics for HCM -
HDL Error ReportingSummary HDL Error ReportingContent Hi Experts, Does anyone have user friendly error reports for HDL Loads. Because PBL is deprecated, we are looking for a good reporting…Rahul Bedia 100 views 8 comments 1 point Most recent by Suma Raghavendra Reporting and Analytics for HCM
-
Personal Payment MethodSummary Is it possible to report on personal payment method when this is blankContent Hi, please can someone confirm if it is possible to identify in a OTBI report when …Helen Tilling 142 views 4 comments 0 points Most recent by User_2025-02-08-06-26-45-662 Reporting and Analytics for HCM
-
SQL for w4 tax Calculation card -2020Summary SQL for w4 tax Calculation card -2020Content Hi Team, We need a SQL to fetch the all fields in w4 tax calculation card 2020 -Federal form. Can you please share i…User_4VVG2 421 views 3 comments 0 points Most recent by Parupally Srikanth Reporting and Analytics for HCM
-
Multiple Worksite report is not returning data for TX after 21-A updateSummary Multiple Worksite report is not returning data for TX after 21-A updateContent Multiple Worksite report is not returning any data for Texas or New Hampshire afte…
-
PTO balance Fast formulsSummary I want to write PTO fast formulaContent Hi All, I am compiling below fast formula /***************************************************************************** …User_2025-01-30-22-34-07-335 56 views 1 comment 1 point Most recent by Pramod Kumar Meda Kavadi Reporting and Analytics for HCM
-
Effective End Date not pulling in element reportSummary Effective End Date not pulling when reporting on element entriesContent Hi, I'm using the Payroll - Element Entries Real Time subject area to show pay element in…
-
EEO1 Electronic Establishment ReportSummary Unable to find the EEO1 Extract flow name to submit by Navigating through Data Exchange--> Submit Extract.Content Unable to find the EEO1 Extract flow name to su…User_2025-02-06-23-16-04-175 21 views 2 comments 2 points Most recent by User_2025-02-06-23-16-04-175 Reporting and Analytics for HCM
-
Percentage split cost centres in OTBISummary Unable to find percentage split cost centres in OTBI on payroll relationship levelContent Hi, I am trying to create an OTBI report which displays employees who h…User_2025-01-30-03-54-32-528 117 views 12 comments 2 points Most recent by Urvashi Jain-261257 Reporting and Analytics for HCM
-
Calculation Card Details - Table InformationSummary Additional Information on Descriptive Flexfields in PAY_DIR_COMP_DETAILS_FContent Hello, I was looking into fetching the Pension Auto Enrollment information from…
-
Payroll ReportContent Hi, I am using two subject areas Workforce Management - Person Real TIme, and Payroll - Personal Payment Detais real time When I add any of the column Target Ban…Mohammed Rafi 63 views 5 comments 3 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
Roles Required to access Subject Areas related to HCM/Payroll/Compensation/BenefitsSummary Looking for a reliable document listing Subject Areas and the Roles Required to access the sameContent Many a times it happens that OTBI analysis shared by exper…Dharmendra Shukla 49 views 5 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Gross Wage Report YTDSummary Detail Gross Wage Report YTDContent I am looking for a way or if there is already a predefined report for Gross Wages YTD broken down by each employee for exampl…Mike Householder 58 views 1 comment 1 point Most recent by Lisa Ridgely-Oracle Reporting and Analytics for HCM -
Timecard Entries with Payroll PeriodSummary Reporting on the Payroll Period that Timecard Entries are paid inContent We have a requirement to report using OTBI, the Payroll Period that Timecard Entries are…User_2025-02-06-14-40-18-938 58 views 3 comments 0 points Most recent by User_2025-02-06-14-40-18-938 Reporting and Analytics for HCM
-
Payslip Summary section is not matching main sectionSummary Involuntary deductions is doubling and does not match the summary sectionContent Hi All, Has anyone else had an issue with the Canadian payslip where the Garnish…User_2025-02-04-08-51-08-912 20 views 2 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
Need inputs to link between calculation cards and Payroll resultsContent Hi All, Can we have a link between Payroll results and Calculation cards tables/subject areas? If anybody is having any links share to us. Thanks, VisuVisu 30 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Balance Report for CanadaSummary This BIP report renders all dimensions associated to the reported balance and their values (RUN, MTD,QTD, YTD, etc.). Content Data model is based on the query pr… -
Error with Month as a Presentation Variable PromptSummary ORA-01722: invalid number at OCI call error when calling the report through prompt but works fine when hard-codedContent OTBI Report runs fine in Edit mode and s…