Payroll
Discussion List
-
Payroll Costing Setup: Join Position Level Segments with Work Structure DataSummary: Having trouble finding a good way to join Position Level costing segments from "Payroll Costing Setup Details Real Time" with relevant columns from "Worker Assi… -
How to build HR analytics using Payroll Period and Payroll Year as time dimensionSummary HR OTBI Analytics with Workforce Management - Worker Assignment Event Real Time subject area and Payroll Calendar as Time DimensionContent Workforce Management -…User_UM4C6 23 views 3 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Pension Reports using Payroll - Calculation Cards Real TimeSummary: Build a report showing Employee Pension Details Content (required): I am trying to build a report with the below field requirements but keep getting more than o…Marcus Aurelius 11 views 2 comments 0 points Most recent by Marcus Aurelius Reporting and Analytics for HCM
-
I need to prepare pension payover report for Uk legislation in BIPSummary: Condition for this Report is that Employees should not come in Report during opt-out period end date and after opt-out end date employees Employee Contribution …Tiw.Jyotsna-Oracle 1 view 0 comments 0 points Started by Tiw.Jyotsna-Oracle Reporting and Analytics for HCM
-
How to get list of valid Procedure Elements which are used in Payroll HCM Extracts?Summary: We are trying to customize a seeded payroll extract. As most of the extracts use procedure elements to fetch data, we wanted to know if we have some documentati…
-
Need Output as a XML for generate payslip process in Flow patternSummary Need Output as a XML for generate payslip process in Flow patternContent Hi Team, we have a requirement to get the payslip xml from generate payslip process , we…Chaitanya Jogi 30 views 3 comments 0 points Most recent by User_CFBK4 Reporting and Analytics for HCM
-
Unable to find Pension Calendar year to date column tableSummary: I am unable to find pension Calendar Year to date column for Annual Pension Initial loaded data in only available in PAY_BAL_BATCH_LINES Table Content (required…
-
Query to get statement of earningsSummary: Can someone share query to get all the balances on statement of earnings screen along with its element and values. I wrote a where I am getting the expected val…Jaeyshree Kumaran Kalpana 22 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Where to check if employee received a pager unit and their on-call premium?Summary: I'm trying to look where in HCM this information can be visible: Employee received a pager unit and their on-call premium. Thanks!notautomni9 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Query to fetch Run Result Element Entries & Balances for particular time periodSummary: We have a requirement to pull element entries & balances from Run Results for the particular time period. I have written the below query but which is giving mul…
-
Seeded HCM Extract for payrollHello, Is there a seeded HCM Extract to get total payroll balances per location/department? Thanks in advance!
-
Need a table or Query to get the IRS Limit values for 401K elements in PayrollSummary Need a table or Query to get the IRS Limit values for 401K elements in PayrollContent Hi Team, Need a table or Query to get the IRS Limit values for 401K element…Chaitanya Jogi 24 views 2 comments 0 points Most recent by Raghavendra M Reporting and Analytics for HCM
-
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 Elem…Kaushik R-Oracle 2K views 42 comments 29 points Most recent by User_PA741 Reporting and Analytics for HCM -
How to convert State Code into State name in BI AnalysisSummary Convert state code into description using subject area or table.Content Hi, I am building an analysis to get some information from a Person's payroll run results…Senthilkumar D 58 views 7 comments 0 points Most recent by Dhinakaran-Venugopal-Oracle Reporting and Analytics for HCM
-
Logical SQL With Dashboard PromptSummary: Hi - I am trying to build a logical SQL report that displays paycheck information along with current salary as an outer join from Compensation subject area. The…Kyle Norris 11 views 15 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Gross to Net YTD valuesSummary Require a report that shows the Gross to Net YTD valuesContent I found the base report in /Shared Folders/Human Capital Management/Payroll/Payroll Calculation Th…
-
Where is 'Expedite Payroll' flag stored?Hi All, Summary: I'm trying to find what table is the 'Expedite Payroll' flag on timecards stored? Content (required): this is what it looks like in front-end Thanks!notautomni9 21 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Where can I find tax registration Number for Reporting UnitSummary: Please can anyone tell me where the tax registration number is in OTBI, I am wanting to add it to a report but cannot find it. Content (required): I am looking …Sharon Harper 11 views 2 comments 0 points Most recent by Sharon Harper Reporting and Analytics for HCM
-
Where is the rate field for hours worked?Summary: Content (required): I have a report that uses the subject area Payroll - Payroll Balances Real Time, but it does not have a pay rate field. Below is an example …
-
Payment Method Bank Account Details is not available in OTBI Payroll Personal Payment details RealSummary: We have a customer requirement that we only need to use the Bank Account in ESS Personal Payment Method but when we try to create an OTBI using the Payroll Pers… -
Reusable Data Model SQL QueriesSummary: Reusable Data Model SQL Queries Content (required): Hi Team, Greetings! Does any have Reusable Data Model SQL Queries for HCM modules (HR, Payroll , Benefits, O…Parag Hiremath 1 view 1 comment 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
Reusable Data Model SQL QueriesSummary: Reusable Data Model SQL Queries Content (required): Hi Team, Greetings! Does any have Reusable Data Model SQL Queries for HCM modules (HR, Payroll , Benefits, O…
-
Need help of running Element Entries - Real Time report for Workers Element entriesSummary: Hi Experts, We need to report on payroll elements for Employees. We have tried to use the subject area Payroll - Element Entries Real time. Whenever we are addi…Silpi 11 views 4 comments 0 points Most recent by Dannielle Dellucci Reporting and Analytics for HCM
-
How to get data in 2 fields for Payroll Relationship -> 'Time Card Required' ?Summary: There are two fields for 'Time Card Required' on the Payroll Relationship responsive page. One is at the Payroll Association level and other at Payroll Assignme…Vinay Hardas 11 views 4 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Bank Statement Analysis Report > Bank Statement TransactionsWe are trying to validate the transactions being reflected on this report. Here's the full path of the seeded report: Shared Folders > Financials > Cash Management >Bank…
-
"Close Date" in Payroll RelationshipsSummary: Morning, We are trying to report on the "Close Date" in Payroll Relationships but I am struggling to find it in OTBI. Would it be possible to have it in the OTB…User_NSURV 11 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Customize- Payroll Register Report for the Latest ProcessSummary: Can we add additional attributes by customizing the seeded extract "Payroll Register Report for the Latest Process". Content (required): Can we add additional a…Mohan Murali 11 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
CASE when help for balance valueSummary: I have an OTBI analysis where I need to pull the sum of balance values for specific balance type between two dates. If an employee does not have that balance ty…Greg Rank 11 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Significance of SOURCE_ACTION_ID in pay_payroll_rel_actions tableSummary: Hi, At the time of using table pay_payroll_rel_actions , we generally put this condition in where clause: SOURCE_ACTION_ID is not null. I observed that in table… -
Create Report to Include Sign On Bonus from Offer LetterSummary: I have an analysis report that list candidates that we had hired. However, I need to add Sign On Bonus amount into the report. I found the "Other Compensation" …