Payroll
Discussion List
-
OTBI Elements Report is not Pulling in All ElementsContent I've built a simple OTBI report for Retirement Deductions and Matching Contributions. My company has 401K, 403B, and 457 Retirement Plans. So, I've filtered for …User_2025-02-11-07-08-23-440 40 views 1 comment 1 point Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
Pay Code / Element Mapping to General LedgerContent Is there a Subject Matter Area which permits you to build an OTBI report of the Pay Codes and the GL Coding or Concatenate Segment associated with the specific P…User_2025-02-11-07-08-23-440 94 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
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 27 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.2K 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 54 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 257 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 19 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 66 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 47 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 39 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 88 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 137 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 416 views 3 comments 0 points Most recent by Parupally Srikanth Reporting and Analytics for HCM
-
Output File Names | BI Reports and Payroll FlowsContent Hi, We've had a requirement where the users wanted to generate the file output via Payroll Flows rather than accessing it via a link / BI catalog path. We've man…
-
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…
-
HCM Table to connect payroll run result values to an employee assignmentSummary Need help with finding a table or column which can tell payroll run result values ran for an assignment_idContent Hello Everyone, I am in middle of editing an SQ…GauravGupta39 1.1K views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
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 50 views 1 comment 1 point Most recent by Pramod Kumar Meda Kavadi Reporting and Analytics for HCM
-
Element entries related to the current assignmentContent Hi Team, We are generating an offer letter for the candidate once they become a pending worker. For that we are getting the data from the element entries table. …Shikha Agarwal 603 views 2 comments 1 point Most recent by Shikha Agarwal 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 22 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 114 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 62 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 51 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 57 views 1 comment 1 point Most recent by Lisa Ridgely-Oracle Reporting and Analytics for HCM