Payroll
Discussion List
-
Reporting on paper payslip flag from People GroupSummary: We require a report that gives me people who have a paper payslip flag ticket in People Group segments. This is to ensure employees out of business get their pa…MKuch 12 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
OTBI Payroll Reporting - How to Generate Employee Data as of Payroll Period & not Current DateWe currently have an OTBI report using the Payroll - Payroll Balance Real Time subject area. Currently, if we run this report it pulls in the employee Business Unit as o…Alex van Gulijk 200 views 14 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Query showing the values on the current Tax Calculation CardsSummary: I need BI publisher reports that show the values on the current Tax Calculation Cards for all active employees including their hire date. The values of greatest…
-
Override the Online Delivery Option for the PayslipSummary: I need help on set ups for overriding an employee's Payslip online delivery preference when they are terminated in Oracle Fusion Cloud. We are currently on 24A.M. S. 2 views 1 comment 0 points Most recent by Hassan El Bouihi-Oracle Reporting and Analytics for HCM
-
Element added back to Balance Feed after updating end dateSummary: After updating the end date of a balance feed element to 2021-12-31 ( through HDL) through Balance Definition page/HDL, the same element is added back with 2022…Hem 81 views 1 comment 0 points Most recent by TudorV-Oracle Payroll and Global Payroll Interface (GPI)
-
how to join pay_tasks_vl table with person number?i wanted to fetch task name from (pay_tasks_vl) for a particular person but not getting how to join this table with person detailsChetana Pawar 11 views 2 comments 0 points Most recent by Chetana Pawar Reporting and Analytics for HCM
-
payroll report with gross pay showing element entry deductionsSummary: I need to create a report (OTIBI or BIP) that shows a person name, person number, pay period, pay period week, gross pay (for the pay period), add-in bonuses, (…
-
Overtime Report for Direct and Indirect EmployeesHi all, I'm looking to build an overtime report that can be used by mangers to see their direct and indirect reporting lines claims, etc I've usually used the 'Assignmen…
-
Payroll ReportSummary: Hi, We are trying to find an easy way to run a Payroll Register report from OTBI. I found this seeded Payroll Register report but it has parameters that I am un…
-
Oracle Fusion Payroll Balance QuerySummary:Performance Issue with my BI Publisher report Payroll Balance Query Content (required): My current payroll balance query is using pay_balance_view_pkg.get_balanc…
-
How to develop a report using year-to-date balance dimensions for payroll balancesSummary: We need to be able to generate effective OTBI reports delivering year-to-date information on payroll balances. When looking at Payroll Balance Results in the UI…Len M. 322 views 9 comments 0 points Most recent by Kishoor_R-Oracle Reporting and Analytics for HCM
-
How to Filter for Calculation Component Details in OTBISummary: Business requires a report to pull all current information on the Reporting Information Calculation Card where the Calculation Component Detail = Third-Party In… -
Check Digits field in Payroll - Personal Payment Details Real Time subject areaSummary: The Check Digits field cannot seem to be found in the Payroll - Personal Payment Details Real Time subject area. Content (required): The Check Digits field cann…Calvin Tam 53 views 4 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Results to be displayed vertically instead of horizontallySummary: Whenever I create a new OTBI Analysis it displays horizontally Content (please ensure you mask any confidential information): How do I change this to show verti…Anna-MariaP 13 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to make a totals columnSummary: Hi, I am trying to have a column that totals the values for a deduction at a Cost Center level. However, in my report, i continue to have repeating rows per Cos…Darrin N 23 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How do I pull the exact same timecard data that appears on the Oracle Team Time Cards screen?Summary: I need to create a data model that pulls the exact same data that appears on the Team Time Cards screen. We have OTBI reports that use the "Workforce Management…BeachDreamer 83 views 1 comment 0 points Most recent by Mohamed Mahrir Reporting and Analytics for HCM -
Generate Check Payment statusSummary: We have Gnerate Check Payment Status as "Void" or "Paid and not Reconciled". Need to know in which table/OTBI suject area holds this exact value. Content (requi…
-
How to Get Flow Submission Date/Creation Date in OTBI ReportHow to Get Flow Submission Date/Creation Date in OTBI Report. I am using payroll Run Result Real Time Business Area. Scenario: Employee Resigned in the month of Sept2023…Jithindev 33 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Need to Add board members in system and Pay Quarterly onceSummary: My requirement is to add Board members in System who are not actually employees and i want to pay them only Quarterly once. what is the Best way to achieve this…Laxman Doppalapudi 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Any report to get the employees with missing calculation card detailsSummary: Any report to get the employees with missing calculation card details Content (please ensure you mask any confidential information): Hi Team, Greetings! There a…Parag Hiremath 24 views 2 comments 1 point Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Which table holds the value for 'Province of Employment' for Canada Employees ?Summary: Need the Table and column info for the 'Province of Employment' value to troubleshoot and fix card association issue. Content (please ensure you mask any confid…Priyabrata Prusty 73 views 3 comments 0 points Most recent by Priyabrata Prusty Reporting and Analytics for HCM
-
need a payroll element costing reportSummary: Need to write a payroll element costing report that includes highlighted information from picture below Content (required): need a report that shows all the inf…Bernadette Dorris 137 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Unable to get the Payroll Balance Value through Payroll - Payroll Balances Real Time subject areaSummary: Unable to get the Payroll Balance Value through Payroll - Payroll Balances Real Time subject area Content (required): We have payroll balance data for an employ…
-
Colorado state employee retirement benefits year end reportingWorking with a school district in Colorado whose employees are participants of PERA. PERA has a very specific requirement for reporting year end data in the exact EFW2 S…Muriel Sindyla 11 views 1 comment 0 points Most recent by Rajesh Tota Reporting and Analytics for HCM -
How to fetch PREVIOUS Grade and Grade Step using BIP?I need to pull the latest previous Grade/Grade Step in a single row because we don't need to back track all the changes on their Grade/Grade Step. How to construct the B… -
How To Loop Throgh a value set in Fast FormulaSummary How To Loop Throgh a value set in Fast FormulaContent Hi Team, we have a requirement to pull particular balance values i tried using the DBI Items but which is n…User_2025-02-04-07-00-18-658 1K views 3 comments 0 points Most recent by Peeyush Chandel Reporting and Analytics for HCM -
Latest Tax not Pulling through Subquery ResultsSummary: Latest Tax not Pulling through Subquery Results Content (required): The sub query set up correctly pulls back latest tax code effective start date in a calculat…
-
Help with Query optimization - Sum of Payroll Balance DimensionSummary: Only months into our post-implementation and our pension report query is consistently timing out. I believe I have narrowed down the offending portion of the da… -
BIP report to fetch employees that are included in Automated Grade Step ProgressionSummary: Other than GSP_ELIGIBILITY_FLAG from PER_ALL_ASSIGNMENTS_M, is there any tables which can identify employees that are included in Automated Grade Step Progressi…
-
Payroll run exclusion GroupSummary Identifies employees who are in an exclusion group and will not be included in the payroll run.Content Hi, Can you please suggest if Payroll exclusion group is a…User_2025-01-30-20-59-13-989 40 views 4 comments 0 points Most recent by Nitin.Goswami Reporting and Analytics for HCM