Payroll
Discussion List
-
can we generate a report with employee names and with file attached in Document Record.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…Mathieu Garneau 11 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Payroll Element Entries - Context Sensitive Displayed Input Values - how to get on one rowSummary: Hello, I am using the SA Payroll Element Entries to try to get an employee allowance report. The issue I have is one of the fields 'Displayed Input Values' is c…Ian.Gooderham 12 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
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 2.9K views 8 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
oracle.xdo12c.xpath.XPathException error on Payslip templateSummary: oracle.xdo12c.xpath.XPathException error on Payslip template Content (required): Hi Team, Greetings! We are getting below error for few records from Payslip tem…Parag Hiremath 12 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Audit Report for all tax code changes received from HMRCSummary: Need a report showing tax code changes from HMRC Content (required): Can anyone help with suggesting how do I go about building a report based on tax code chang…Isabela Radivoi 64 views 1 comment 0 points Most recent by Anca Andronic-Oracle Payroll and Global Payroll Interface (GPI) -
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…RamkumarKadhiravan 22 views 2 comments 0 points Most recent by RamkumarKadhiravan Reporting and Analytics for HCM -
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…RamkumarKadhiravan 73 views 8 comments 0 points Most recent by RamkumarKadhiravan 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…User_2025-02-04-07-00-18-658 373 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 23 views 2 comments 0 points Most recent by Gail Langendorf-Oracle 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…Nisha_Hegde 11 views 1 comment 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM -
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 … -
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 42 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 243 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 …
-
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 23 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 74 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 41 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 22 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 …
-
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 11 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 41 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 21 views 2 comments 0 points Most recent by Isabela Radivoi Reporting and Analytics for HCM
-
Report to extract LRU Calculation cards configuration detailsSummary: Report to extract LRU Calculation cards configuration details Content (required): Hi Team, Greetings! Does anyone have the report or the query to extract LRU Ca…Parag Hiremath 51 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM
-
How do I get Box 13 to populate on the W2?Summary: Box 13 on our W2s is not showing as checked. We are a government agency with a pension plan. I looked through Oracle documentation and found guidance regarding …Sara Ro 82 views 1 comment 1 point Most recent by Faithe Chu-Oracle Payroll and Global Payroll Interface (GPI)
-
Report to get the duplicate element entries in a given pay periodSummary: Report to get the duplicate element entries in a given pay period Content (required): Hi Team, Greetings! Is there an existing report to get the duplicate eleme…Parag Hiremath 12 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Invalid Number Error in fetching Basic Salary ComponentSummary: We are writing an oracle sql query to fetch different components in the salary for inactive employees. But it keeps showing below error on runtime. ORA-01722: i…Rohankumar Patel 54 views 2 comments 0 points Most recent by Sudheer Patel Reporting and Analytics for HCM
-
How to cutomize a seeded Payroll register Report extractSummary: Which extract should we customize to add the new attributes to the extract. Can you provide us a document for the same. Content (required): We have a requiremen…Minu Priya 209 views 4 comments 0 points Most recent by Mohammad Shahnawaz-Oracle Reporting and Analytics for HCM
-
Reporting on element entry Correction - getting new and former values?Summary: There is a need to report on changes made to an element entry record of a person, where the 'Correct' editing option was used (not Update). We are seeking to ge…Shant Sarkissian_NES 42 views 7 comments 0 points Most recent by Shant_Sarkissian_WJG Reporting and Analytics for HCM