Payroll
Discussion List
-
Element Entries Real Time - Retroactive Payement DateSummary Within Element Entries Real Time - I have Retroactive payements made to employees however in OTBI i cannot locate 'Orginal Date Earned'Content Overview: For Empl…User_KKA8Z 53 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Logic to know the Insert/Update/Delete as Audit Action in Audit Salary Report for HCMWe want to build an HCM audit report in OTBI. HRDirect needs an audit report to see when a salary change was added, updated or removed an individual. Filters: Employee I…Mukesh Bulla 22 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Any Suggestions of how to improve HCM Extract completion time!Summary: We are facing an issue with the custom HCM extract which is running and taking a long time to generate the XML output (5 employee data for 10 minutes). We have …
-
Query to get department from PAY_COSTS tableSummary: Need to link the department to the PAY_COSTS table. How can I link the department (organization_id) to the PAY_COSTS table through other tables? Content (please…luke.syv8 1 view 1 comment 0 points Most recent by Rakesh Ghosh-Oracle Reporting and Analytics for HCM
-
How to retrieve 'Exempt from Long Term Care' associated with Washington tax card from backend table?Summary: I am trying to locate 'Exempt from Long Term Care' linked to the Washington Regional Tax Card in the backend table, but I cannot find the base name in the backe…Swapna Udaiyar 61 views 7 comments 0 points Most recent by Gabriela Ichim-Oracle Reporting and Analytics for HCM
-
We looking Variable pay plan details in OTBI for which subject area need to use ?Summary: Hi Team, May I know which subject area need to use for Variable pay plan details as per below screen shot. Variable pay plan details: Content (please ensure you…AjayKumar Maddipati 11 views 5 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Report showing all ElementsSummary Need a report to show all element entries that have been created (Recurring and Non-Recurring)Content HI All, I hope this is a simple ask but I can't seem to fin…
-
Report not pulling correct salary infoSummary: We have a requirement from our HR department to build an AAP report that includes salary information for employees. We've tried building this report using a few…Henry Imgrund 26 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Building Scalable Payroll Balance Reports in OTBISummary This document provides guidance to OTBI report developers on how to build scalable reports for reporting on Fusion Payroll balances.user714053-Oracle 210 views 4 comments 4 points Most recent by Divyalakshmi Krishnamoorthy Reporting and Analytics for HCM
-
Sql to find t4 information of employee (like tax year and boxes information etc)Summary: Dear exports, Any one have sql/otbi report to pull the information exist in canada t4 slip? Please suggest Content (please ensure you mask any confidential info…Rama123-Oracle 12 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
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…
-
Vacation hours disbursedSummary Vacation hours disbursedContent Hello Community, Are you aware of any report in oracle that will tell us vacation hours disbursed? We are specifically looking fo…User_RVZRJ 8 views 6 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
Sql Query to get payroll deduction detailsSummary: I am looking for a query which provides terminated employees last earnings and deduction details from payroll. Content (please ensure you mask any confidential …Rahul K-Oracle 149 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Customer wanted automate the T4 slips that should deliver to terminated emps personal email addressSummary: Hi Experts, Need suggestions on how to automate the T4 slips that should deliver to terminated emps personal email address, if anyone implemented this functiona…Rama123-Oracle 11 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Rest API to create individual compensation planSummary: Hi All, Is there any REST/SOAP API available to create individual compensation plan? Thanks, Venkatesan R Content (please ensure you mask any confidential infor…
-
Payroll Audit ReportSummary: Hi All, Do we have any option for audit report on Payroll details. Who has accessed a specific salary/payroll screen in the past 7 days? Thanks, Ram Content (pl…RamkumarKadhiravan 22 views 2 comments 0 points Most recent by RamkumarKadhiravan Reporting and Analytics for HCM -
Where can we find the latest list of all HCM PVOs to be used in BICCSummary: We want to use BI Cloud Connector to pull HCM data. Where can we find the documentation for all available PVOs supported in BICC ? Content (please ensure you ma…Soumya Suravita 71 views 6 comments 0 points Most recent by Soumya Suravita Reporting and Analytics for HCM
-
Database table that is equivalent to the OTBI Subject Area Payroll Calculation Cards Real TimeSummary: Can someone provide the Database table name that is equivalent to the OTBI Subject Area Payroll Calculation Cards Real Time specifically looking for the Calcula…Laura Goodall-Brown 12 views 2 comments 0 points Most recent by Laura Goodall-Brown Reporting and Analytics for HCM -
Need inputs to display Payroll Run Results based on JobSummary: Need inputs to display Payroll Run Results based on Job Content (please ensure you mask any confidential information): We need to display Payroll Run Results da…Visu 21 views 9 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Report to show all employees who have not been paid in last 3 weeksSummary: Need a report to see the employee, assignment, last paid date and benefit termination date for the employees who have not been paid in last 3 weeks. Content (pl…Priyabrata Prusty 22 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
Benefits arrears OTBI reportHi all, We are trying to develop a new OTBI report for benefits arrears , we have used the following 2 subject areas with effective date prompt. 1.workforce management -…yugandhar 139 views 11 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Reporting on Payroll Balances with a Time Definition DimensionSummary: Hi, we have a number of payroll balances defined which utilise element allocation functionality and have a 'time definition' dimension i.e. _REL_BD_TDPTD. The t…Jon Taylor 11 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
query to identify the processed and unprocessed payroll transactions for BI reportsVersion (include the version you are using, if applicable): for version "Oracle Fusion Cloud Applications24A (11.13.24.01.0)".Immanuel Aruldoss 21 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
link between FND_SESSIONS table to country and stateSummary: link between FND_SESSIONS table to country and state Content (please ensure you mask any confidential information): By using FND_SESSIONS table, we can get the …
-
Oracle Payroll fast formula to fetch from VbyC tables?Summary: Can we access our own VBC records with a Oracle Payroll fast formula to fetch from VbyC tables? ex. PAY_VBC_VALUE_IDENTS_VL OR below picture list. thank you Con…JBW_HCM 1 view 1 comment 0 points Most recent by Divya Jayaraman-Oracle Reporting and Analytics for HCM
-
Query to get delayed payroll flowsSummary: Query to get delayed payroll flows - the ones which did not start on scheduled time Content (please ensure you mask any confidential information): Hi Team, Gree…Parag Hiremath 11 views 1 comment 0 points Most recent by Satyam Roy Reporting and Analytics for HCM -
RTF template: Repeating field/section in payslipSummary: We have a requirement for the payslip that the Name, Person Relationship Number, and Payroll Name should be repeated if the payslip data continues in the 2nd/ne…Mark Jayson Tamaray 12 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
CE_EMP_UNSPECIFIED_BANK showing up as Bank Name instead of correct bank nameSummary: CE_EMP_UNSPECIFIED_BANK showing up as Bank Name instead of correct bank name Content (please ensure you mask any confidential information): Hi Team, Greetings! …Parag Hiremath 17 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
How to run the report USOnlinePayslip from BI PublisherHi All, I need to run the report USOnlinePayslip from BI Publisher. I am not able to get the output whatever parameters I pass. I need to get the xml data of the output …SowmyaSk18 11 views 1 comment 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
BICC VO for PAY_COSTS linking to XLA tableSummary: We are looking for a BICC VO that links the PAY_COSTS Table with XLA tables. This VO should bring in the segment details. Currently we are using PAY_XLA_COSTS_V…Conor Murnane 32 views 4 comments 0 points Most recent by Conor Murnane Reporting and Analytics for HCM