Payroll
Discussion List
-
SQL for w4 tax Calculation card -2020Summary SQL for w4 tax Calculation card -2020Content Hi Team, We need a SQL to fetch the all fields in w4 tax calculation card 2020 -Federal form. Can you please share i…User_4VVG2 98 views 3 comments 0 points Most recent by Parupally Srikanth Reporting and Analytics for HCM -
Query to find hr_assignment_id/assignment_id for which payroll has been RunSummary Find link between payroll run and assignmentContent Hello Team I need a query to find the assignment for which a payroll(quick pay/Regular payroll) has been run …AvishekNandi 20 views 2 comments 1 point Most recent by Mandeep Gupta Reporting and Analytics for HCM
-
Output File Names | BI Reports and Payroll FlowsContent Hi, We've had a requirement where the users wanted to generate the file output via Payroll Flows rather than accessing it via a link / BI catalog path. We've man…
-
Multiple Worksite report is not returning data for TX after 21-A updateSummary Multiple Worksite report is not returning data for TX after 21-A updateContent Multiple Worksite report is not returning any data for Texas or New Hampshire afte…user10511068 12 views 2 comments 0 points Most recent by user10511068 Reporting and Analytics for HCM
-
HCM Table to connect payroll run result values to an employee assignmentSummary Need help with finding a table or column which can tell payroll run result values ran for an assignment_idContent Hello Everyone, I am in middle of editing an SQ…GauravGupta39 23 views 1 comment 0 points Most recent by Mandeep Gupta Reporting and Analytics for HCM
-
Time and Labor Entries by BatchSummary Looking for a query of Time and Labor Entries by Payroll Transfer BatchContent We’d like to be able to report on the entries that were loaded from Oracle Time an…Mark Erzen 53 views 4 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
PTO balance Fast formulsSummary I want to write PTO fast formulaContent Hi All, I am compiling below fast formula /***************************************************************************** …ratnakar pakala-79449 30 views 1 comment 1 point Most recent by Pramod Kumar Meda Kavadi Reporting and Analytics for HCM
-
Element entries related to the current assignmentContent Hi Team, We are generating an offer letter for the candidate once they become a pending worker. For that we are getting the data from the element entries table. …Shikha Agarwal 43 views 2 comments 1 point Most recent by Shikha Agarwal Reporting and Analytics for HCM -
Effective End Date not pulling in element reportSummary Effective End Date not pulling when reporting on element entriesContent Hi, I'm using the Payroll - Element Entries Real Time subject area to show pay element in…
-
EEO1 Electronic Establishment ReportSummary Unable to find the EEO1 Extract flow name to submit by Navigating through Data Exchange--> Submit Extract.Content Unable to find the EEO1 Extract flow name to su…Chanakya Badri 19 views 2 comments 2 points Most recent by Chanakya Badri Reporting and Analytics for HCM
-
Percentage split cost centres in OTBISummary Unable to find percentage split cost centres in OTBI on payroll relationship levelContent Hi, I am trying to create an OTBI report which displays employees who h…Barry Stamp-73691 64 views 12 comments 2 points Most recent by Urvashi Jain-261257 Reporting and Analytics for HCM -
Payroll Element Entries History excluding terminated employeesSummary Payroll - Element Entries History Real Time subject area is excluding terminated employeesContent I have created a report to pull Annual Salary and Annual Bonus …
-
Calculation Card Details - Table InformationSummary Additional Information on Descriptive Flexfields in PAY_DIR_COMP_DETAILS_FContent Hello, I was looking into fetching the Pension Auto Enrollment information from…
-
Payroll ReportContent Hi, I am using two subject areas Workforce Management - Person Real TIme, and Payroll - Personal Payment Detais real time When I add any of the column Target Ban…Mohammed Rafi 33 views 5 comments 1 point Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
OTBI Subject Area: "Payroll - Personal Payment Details Real Time" --> Target Bank --> Selected AccoSummary OTBI Subject Area: "Payroll - Personal Payment Details Real Time" --> Target Bank --> Selected Account FlagContent HI, I am looking to identify a field in the OT…User_MC37Q 44 views 2 comments 1 point Most recent by Shruthi Ramesh Reporting and Analytics for HCM -
Roles Required to access Subject Areas related to HCM/Payroll/Compensation/BenefitsSummary Looking for a reliable document listing Subject Areas and the Roles Required to access the sameContent Many a times it happens that OTBI analysis shared by exper…Dharmendra Shukla 29 views 5 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Gross Wage Report YTDSummary Detail Gross Wage Report YTDContent I am looking for a way or if there is already a predefined report for Gross Wages YTD broken down by each employee for exampl…Mike Householder 31 views 1 comment 1 point Most recent by Lisa Ridgely-Oracle Reporting and Analytics for HCM -
Timecard Entries with Payroll PeriodSummary Reporting on the Payroll Period that Timecard Entries are paid inContent We have a requirement to report using OTBI, the Payroll Period that Timecard Entries are…David Bean-193134 36 views 3 comments 0 points Most recent by David Bean-193134 Reporting and Analytics for HCM
-
Payslip Summary section is not matching main sectionSummary Involuntary deductions is doubling and does not match the summary sectionContent Hi All, Has anyone else had an issue with the Canadian payslip where the Garnish…
-
Need inputs to link between calculation cards and Payroll resultsContent Hi All, Can we have a link between Payroll results and Calculation cards tables/subject areas? If anybody is having any links share to us. Thanks, VisuVisu 19 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Balance Report for CanadaSummary This BIP report renders all dimensions associated to the reported balance and their values (RUN, MTD,QTD, YTD, etc.).Content Data model is based on the query pro… -
Error with Month as a Presentation Variable PromptSummary ORA-01722: invalid number at OCI call error when calling the report through prompt but works fine when hard-codedContent OTBI Report runs fine in Edit mode and s…
-
When I Run EEO-1 Component 2 Electronic Report, the Text results come back blankSummary When I Run EEO-1 Component 2 Electronic Report, the Text results come back blankContent Hi, When I run the When I Run EEO-1 Component 2 Electronic Report, there …Kevin Orze-43433 24 views 1 comment 1 point Most recent by Kevin Orze-43433 Reporting and Analytics for HCM
-
Invalid Payroll Transactions in the SubledgerContent We have been up for a year on Oracle and have had a very rocky go of it. We have about 50k (yep thats right) invalid transactions for 2020 in the subledger from …Rebecca McArthur 10 views 2 comments 0 points Most recent by Rebecca McArthur Reporting and Analytics for HCM
-
Need a SQL Query to fetch previous employment element entry details.Summary Need a SQL Query to fetch previous employment element entry details.Content Hello Team, I have a requirement to fetch Previous employement element entry details …
-
Performance issues while using Period Name and Payroll Name in the Column Prompts LOV of a OTBI repoSummary Performance issues while using Period Name and Payroll Name in the Column Prompts LOV of a OTBI reportContent Hi I have 2 prompts on my OTBI report. Period Name …
-
Need a SQL query to fetch Previous salary and previous assignment working hours of an employee.Summary Need a SQL query to fetch Previous salary and previous assignment working hours of an employee.Content Hello, I have a requirement to fetch Previous salary and p…
-
Payroll OTBI with Balance Definitions, Names, Feeds and Element names with Input Value NamesSummary We have a Balance Name called Net Pay with a Balance feed of multiple combinations of Elements and Input Value Names but I cannot find this relationship in the m…Robert Craske 41 views 2 comments 0 points Most recent by Robert Craske Reporting and Analytics for HCM
-
Annual Employee Salary DetailsSummary Annual Employees Salary details ReportContent Is there any OTBI & Standard seeded report available for employee annual salary details.Bilalemail 26 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Tax Year to Date / Statement of EarningsSummary How can I report on Tax YtD values from SoEContent We have a requirement to build a report in PeopleCloud which is currently an SQR in PeopleSoft. The existing r…