Payroll
Discussion List
-
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 48 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 263 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 21 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 55 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 21 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 12 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 42 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 22 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 64 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 91 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 13 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 221 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 47 views 7 comments 0 points Most recent by Shant_Sarkissian_WJG Reporting and Analytics for HCM
-
Missing Bank Details for Rehires and Global Transfers not linked to latest Personal Payment MethodsSummary: Bank Details for Employees who have transferred from one Legal Employer to another or for Rehires are not updated against their new Personal Payment Methods. Co…GJ79 76 views 3 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Element Entry Changes ReportSummary Copying an existing BI Publisher versionContent Hi, I'm trying to replicate a BI Publisher report that HR runs each month and submits to payroll. I'd like the re…User_2025-02-05-22-44-35-842 96 views 2 comments 0 points Most recent by Isabela Radivoi Reporting and Analytics for HCM -
Dynamic Regular Date Earned Formula RequiredSummary: Need a formula to get the last two regular dates earned to update each month. Content (required): I have a Payroll Net Pay Variance report which compares the Ne…
-
Is there a standard report for Balance Adjustments?Summary: Specifically, we are looking for a way to report on failed Balance Adjustments. At year end, we frequently mass load Balance Adjustments. And always a few fail …
-
Query to extract employee Salary SourceSystemId and SourceSystemOwnerSummary: Content (required): Hello experts, please could you share the SQL query to extract employee Salary SourceSystemId and SourceSystemOwner? Thanks in advance for y…Valerio Curzi 128 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Need help - Need a payroll report for Element vs BalancesSummary: We need to create a report to include Element names which are feeding a particular Payroll Balance. We tried to do it using Payroll Subject Areas but it did not… -
Tax Witholding ReportSummary: I need help creating a report showing which employees are claiming exemption from the tax witholdings. More specifically, which employees are claiming exempt. I…Greg Rank 46 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Audit Report for inactive bank account associated with employee payment methodSummary: Audit Report for inactive bank account associated with employee payment method Content (required): Hi Team, Greetings! Is there any existing Audit Report for in…Parag Hiremath 159 views 8 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM
-
Need Help with Permissions Required for HCM Subject AreasSummary: I've got a service account that we use to pull extracts into Casabase. We are getting access to all of the ERP and accounting subject areas. However, we are now… -
Converting payroll elements from one currency to anotherSummary: Content (required): Hello experts, Do you know if now it is available in OTBI and UI the possibility to convert payroll elements from one currency to another ac…Valerio Curzi 43 views 3 comments 0 points Most recent by Valerio Curzi Reporting and Analytics for HCM
-
Line Manager information in OTBI reportSummary: If any employee is Line Manager for other employee record then we need to display 'X' value. Content (required): Ex: Output: In the above scenario 66789 and 123…Visu 452 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to remove certain part of a column after parenthesis in BI reportSummary: Hi All, I want to remove the part of Tax Reporting Unit column from where the parenthesis is starting. Please suggest the function to use this in sql. Example: …Dona Das-Oracle 51 views 6 comments 0 points Most recent by Dona Das-Oracle Reporting and Analytics for HCM