Payroll
Discussion List
-
Reporting on Eligible for Pretax Age Catch-Up Contributions FieldSummary: Looking to include the column Eligible for Pretax Age Catch-Up Contributions in a payroll report to pull all data assigned to a person's Reporting Information c… -
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… -
How to retrieve the OLD payroll frequency and NEW Payroll frequency in the BIPHi ALL, Kindly support me to resolve below issue: I have a requirement to retrieve the OLD payroll frequency and NEW payroll frequency in BI report. Following with other… -
SQL to retrieve fields for BI ReportSummary: Hi All Please share SQL query to fetch below details for generate bursting report. Thankyou, Ram Content (required): SQL to retrieve Employee Number, Employee N…
-
Payroll : Fiscal year to date balance showing results for the Calendar year and not Fiscal yearSummary: Payroll : Fiscal year to date balance showing results for the Calendar year and not Fiscal year Content (required): Hi, We have enabled "Relationship NoCB Fisca…SakthiPradeepa_NK 10 views 0 comments 0 points Started by SakthiPradeepa_NK Reporting and Analytics for HCM
-
How to make BI report output file (RTF template with Excel op) as non editable once it's downloadedSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Table name to get Element CategorySummary Table name to get Element CategoryContent Hi Team, Can someone help me with the table name to get the "Element Category", i was able to get this information inOT…Chaitanya Jogi 153 views 12 comments 0 points Most recent by Veerachari Reporting and Analytics for HCM
-
Pension and annual salary data in one reportSummary: Hi, We are trying to build a report which provides information on an employees pension and annual salary. The report is built combining subject areas. When comb…NusratB 14 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Maintain Meta Model and IndexHi, We have a Maintain Meta Model and Index process in error in scheduled processes. This was scheduled by someone who is now a leaver, so may be the reason for the erro…Daniel.McDermott 20 views 0 comments 0 points Started by Daniel.McDermott Reporting and Analytics for HCM
-
Query Slower after patch Favoring Full Table Scan (FTS) instead of Index ScanSummary: A report built to get the timecard details (OTL query) is suddenly running for a very long time after the recent patch was applied. It does full table scan rath… -
query to pull Reporting information calculation cardSummary: query to pull Reporting information calculation card Content (required): Hi All, Greetings! We are looking for a query to pull Reporting information calculation…Parag Hiremath 145 views 4 comments 0 points Most recent by Parag Hiremath 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 … -
Payroll-Personal Payment Details Real Time Target Bank Account is Null but not "IsNull" in the fieldSummary: Content (required): We are trying to find all the employees that have missing Bank Account Numbers or Bank Sort Codes We are currently using Payroll - Personal … -
Element HDL Template Generator ReportSummary OTBI report to generate sample files to create Payroll Elements using HDL Content Introduction: This report provides sample files to create Payroll Elements usin…Kaushik R-Oracle 3.7K views 65 comments 29 points Most recent by Dinesh Nagaraj Reporting and Analytics for HCM -
Convert numbers to Arabic in wordsContent Hi, We have a requirement to convert salary numbers to Arabic. How can we achieve this? Is there any possible way in BIP or rtf template? Regards, Nivya Version …Nivya Mathire 319 views 10 comments 1 point Most recent by Nivya Mathire Reporting and Analytics for HCM -
Get Journal Entries Details For An EmployeeSummary: Team We would need to fetch Accounting Date & Transaction Number From Journal Entries. (Payroll-> Review Journal Entries) For An Employee Columns are: Accountin…Manoharan 44 views 1 comment 0 points Most recent by Nalsoft Pvt Ltd Reporting and Analytics for HCM
-
Payroll - Element Entries - Real Time Subject AreaSummary: We have a requirement to enable our Reward Team to have the ability to report on Element Entry Values. I have read many similar posts regarding this and i under…Tony Donnachie 117 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Data PurgeSummary: Hi Team, Could we get the list of dependent components which will be purged when we select particular object in "Data Purge" Example: if Payroll is selected in …
-
Mask Employees Payroll Run Results data after cloneSummary: We need to mask all Employees previous processed Payroll Run Result data on the cloned system Content (required): We are taking Clone from production to test fu…
-
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…
-
How to add AVG formula to PivotSummary: Using Subject Area Payroll - Payroll Balances Real Time to pull worked hours by date paid. The requirement is to display both Total YTD Hours and Average Hours …JHaden3 24 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Query to fetch count of colleagues for whom balances have got loaded into systemSummary: After execution of "Load initial balances" job in system as part of HDL upload of balances. Now I need to know for how many colleagues balance information is lo…
-
Which subject area gives the payslip earnings?Summary: Report pullings details from Pyalip Content (required): Does anyone know which subject area I can use to get the payslip details as per the screenshot attached?…Isabela Radivoi 34 views 5 comments 0 points Most recent by Isabela Radivoi Reporting and Analytics for HCM -
Can OTBI pull payment Method details e.g concatenated bank account No and Sort code ?Summary: I want to add to my audit bank details Report the payment methods details such as concatenated bank account and sort code. Content (required): Not sure if possi…Isabela Radivoi 44 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to prevent state taxes from being withheld based off addresses onlySummary: How to prevent state taxes from being withheld based off addresses only Content (required): Hello all. Employee is now per diem and changed his address to NY. H…Michael Cashin 24 views 2 comments 0 points Most recent by Michael Cashin Reporting and Analytics for HCM
-
White paper to load an HDL through BIP reportSummary: Please let me know if there is a white paper indicating the configuration for creating an HDL file and further load it through HDL through a payroll flow. I am …
-
Issue in Salary Certificate DORSummary: Issue in Salary Certificate DOR Content (required): Hi All, We are facing the issue in salary certificate DOR. Salary certificate is working fine in draft versi…Venkatesan 24 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Upgraded from Version 1 to 3. PER_SENIORITY_DATES_F - How is it Populated?Summary: New table PER_SENIORITY_DATES_F created as part of upgrade to version 3. Can any one share the details of the data migration to this table? Content (required): …ChicagoConsultant 14 views 1 comment 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM
-
Payslip Reprinting Report flow does not Produce Output and cannot be opened because it has no pagesSummary: Payslip Reprinting Report flow is completed successfully and does not Produce Output and cannot be opened because it has no PDF (Blank) pages ####[2023-07-11T16…Janardhan ACS-Oracle 49 views 3 comments 0 points Most recent by Janardhan ACS-Oracle Reporting and Analytics for HCM
-
How to calculate cost of sickness in UKSummary: Calculate the cost of sickness using salary from element entry Content (required): I have been asked to calculate the quarterly cost of sickness. I was wonderin…Isabela Radivoi 24 views 2 comments 0 points Most recent by Isabela Radivoi Reporting and Analytics for HCM