Payroll
Discussion List
-
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 21 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 161 views 11 comments 0 points Most recent by Venkateswara Rao Vadlamani 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 31 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 11 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 59 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 41 views 4 comments 0 points Most recent by Conor Murnane Reporting and Analytics for HCM
-
Is it possible to create an OTBI report that will show payment details by payment date and employee?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Chris West 41 views 2 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Termination Dates and Payroll Data Query or ReportHi So looking for a query/DM or report that I can edit/update to show termination details and payroll data combined? Basically, I have been asked to create a report to b… -
OTBI and BIP Report Scheduling - Ideal Time WindowHi all, Just a quick question I'm hoping someone can answer. Is there a preferred time for scheduling OTBI and BIP reports during the day? Any times to avoid / best time…
-
Which tables stores the information about the benefits that are being used in an organizationSummary: Can some one help me in finding the table for finding benefits that are being used in an Organization Content (please ensure you mask any confidential informati…yugandhar 31 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Trying to find the job details from the grade table through valid grades tableSummary: We are developing the grade ladder report in that we need to get the job details for the grades. However, we get duplicates due to the multiple valid grade IDs …Rengaraj G 11 views 1 comment 0 points Most recent by AnishaPatra-Oracle 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 31 views 8 comments 0 points Most recent by Mark Jayson Tamaray Reporting and Analytics for HCM
-
Benefit & Pension Calculation Card HistoryIs there an analysis or report that shows the history of a calculation card? I have an employee who was enrolled in main LGPS scheme up to 30 September 2023 but as of 1 … -
VBC HCM tables available for BI Query in lab pod? POCSummary: Are the Value By Criteria tables available for BI Query Data Model? Content (please ensure you mask any confidential information): Hello: I'm performing a Proof…
-
Federal Tax Withholding Filing Status - Pulling Data from TablesSummary: The Federal Tax Withholding Filing Status seen from the front end of the application is displaying a status that does not correspond with the Filing Status seen…ChicagoConsultant 12 views 1 comment 0 points Most recent by RWMATTHE-Oracle Reporting and Analytics for HCM
-
Table that Stores Fields on Tax Withholding Calculation Card- Filing StatusSummary Looking for table that stores filing status on Tax withholding calculation card when you select Federal Income Tax, Calculation Coponent DetailsContent Hi All, L…User_2025-01-30-00-53-42-934 969 views 5 comments 0 points Most recent by Sydney_Flahive Reporting and Analytics for HCM -
Unable to see newly created elements in OTBI reportSummary: I am using the attached report and am able to see elements on employees/pending workers. We recently created some new elements, and I can't get them to pull eve…Shanna Oppenheim 21 views 5 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How to link pay_costs table back to an organization_idSummary: How can I get pay_costs info to tie back to an organization_id? We want to be able to derive our costed department name the same way that the costing segments a…
-
Payroll Flow Pattern ReportSummary: Payroll Flow Pattern Report Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there a way to find out the programs which are…Parag Hiremath 41 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Trying to create a BI report to fetch out the payroll element entry data for employee.Here the data is flowing from ORC to Individual Compensation.When the employee is hired he will be awarded with some "BONUS" with some additional fields these data's wil…Jebarsan Thangam John Durai Raj 92 views 10 comments 1 point Most recent by Shanna Oppenheim Reporting and Analytics for HCM
-
Need SQL to extract the amount and periodicity of worker element entriesSummary: Hi Experts, Could you please provide SQL code that extracts the amount and periodicity of worker element entries? I need help with this requirement. Written thi…Hiba Ghoualmia 75 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
An internal assertion test couldn't be completed at location ReportUtils.validateArchiveDefn:2.Summary: Non - US payroll extract is giving the error in one of the scheduled runs in production: An internal assertion test couldn't be completed at location ReportUtil…Shilpa Varghese 173 views 4 comments 0 points Most recent by Shilpa Varghese Reporting and Analytics for HCM -
An internal assertion test couldn't be completed at location ReportUtils.validateArchiveDefn:2.Summary: Non - US payroll extract is giving the error in one of the scheduled runs in production: An internal assertion test couldn't be completed at location ReportUtil…
-
state unemployment wages by jurisdiction reportSummary: I am trying to create a report that shows state unemployment wages by state jurisdictions. I created one in OTBI using the Payroll - Payroll balances real time …JDCal 11 views 1 comment 0 points Most recent by Rakesh Ghosh-Oracle Reporting and Analytics for HCM
-
not able to fetch latest date even after using MAX functionHi team i am trying to fetch latest last update date record in below query but unable to do it.i am looking for 2022 as a latest date record but when i use max function …Chetana Pawar 11 views 1 comment 0 points Most recent by Rakesh Ghosh-Oracle Reporting and Analytics for HCM