Payroll
Discussion List
-
How to build a HCM extract to generate HDL files.Summary: As per the business requirement, I need to build a HCM extract to generate the CalculationCard.dat file. I need to build an extract which can give me balances y… -
Tax rates vs Tax codes SQL from HMRCSummary: How to query how much percentage of deduction is associated for each tax code based on HMRC definitions? in which tables this data avilable? for example for BR …User_GXFFS 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
HCM Extract failing at runtime for Name PAY_PAYPROC_UNKNOWN_ERRSummary: Hello, The HCM Extract validated and compiled with no errors is failing at runtime for below mentioned errors: Name PAY_PAYPROC_UNKNOWN_ERR Token1 null Token2 n…
-
EEO and VETS Reporting Set upSummary: Hi All, I am trying to run the delivered EEO and VETS reports from My Client Groups> Payroll> Submit a Flow area . But nothing is appearing in the LE dropdown a…Gaurav Rath- PGC 21 views 3 comments 0 points Most recent by Gaurav Rath- PGC Reporting and Analytics for HCM -
Max Effective Date for Each ElementSummary: How to retrieve the max effective date for each Element. Content (required): I am trying to find the max effective date for each of the three Elements (differen…JA1 31 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Trying to create a calculated item using fields from two subject areasI have created a report using balances and calculation cards. The report will run and return data from both areas but when i try to create a new field using a formula th…Sharon Harper 32 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Catalog for Payroll Balances Real timeSummary: Trying to create a report from Payroll Balances Real time SA to match the Balance Results values from SOE with the amount included in the report for the respect…Hem 81 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Can deduction arrears be one an OTBI report.Summary: Deduction arrears on an OTBI report. Content (required): I need to write an OTBI report for deduction arrears. Is that possible? What subject area do I need to …Donna Valentine 21 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
Payroll Flow - BI Report - Bursting - Not generating output file.Hi folks, I'm generating a payroll report and pushing it on SFTP using bursting. Template, filename and path is derived via bursting .This report is attached to a Payrol…
-
OTBI Filter CriteriaSummary: Need help to add a filter criteria in OTBI analysis. I am using the below filter criteria which is working in payroll subject area: "Balance Types"."Balance Nam…Mohan Murali 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need inputs to get the Target Element Name under Status Processing RulesSummary: Need inputs to get the Target Element Name under Status Processing Rules in Element UI Content (required): We can have a link between Pay_Element_types_vl and P…
-
Does anyone know which process populates this Benefits table?Summary: Content (required): I'm looking at table BEN_PRTT_RT_VAL and wondering if this is getting updated by a Benefits process vs. Payroll process? We see mismatches w…Scott Paulin 22 views 2 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Need Help to fix Date parameter while integrating BI report into DashboardSummary: I have created a SQL with a date parameter that calculates effective date minus 5 days. Below is the code which is working well while running normally with BI r…Mohan Murali 32 views 1 comment 0 points Most recent by Mohan Murali Reporting and Analytics for HCM
-
SQL query to retrieve earnings and deductionsSummary SQL query to retrieve earnings and deductionsContent Hi Experts, I'm designing a balance extract that needs to fetch pension deductions 403. To create the data g…Aloka Bhattacharya 2.1K views 6 comments 2 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Need a report with each element and corresponding eligibility/eligibilitiesSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
SQL to get Fast formula name that feeds (computed) value to input value of another elementSummary: Please share any SQL to get the name of the fast formula that feeds the computed value to input value of another element. Content (required): Version (include t…
-
Unable to find Filing Status, Allowances and Exempt fields in OTBI in 19CContent Hi All, We are unable to find the "Filing Status" , "Exempt" and "Allowances" fields in "Payroll - Calculation Cards Real Time" OTBI subject area. When we click …
-
Need SQL to get Element Duration DatesSummary: Need SQL to get Element Duration Date, that is at assignment level. Content (required): Need SQL to get Element Duration Date, These dates are present in 3 leve…Raghavendra M 123 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Need sample analysis/SQL to get various balance values for each assignment for EE with multiple GTSummary: When global transfer happens for any employee, we need to validate various balances to confirm if they are transferred to the new LE. During a year if an EE is …
-
Seeded report to get every earning/deduction/taxes of any specific employee during a date rangeSummary: Need to know if any seeded report exist that we can leverage to get details of every earnings/deductions/taxes of any specific employee during a pay period or f…
-
SQL to get Fast formula name that feeds (computed) value to input value of another elementSummary: Please share any SQL to get the name of the fast formula that feeds the computed value to input value of another element. Content (required): Version (include t…
-
Need to display employee records transferred from Payroll to GLContent Hi All, We transferred the data from Payroll to GL. Now we need to display those records either in OTBI/BIP. Can you suggest do we have any subject area/BIP tabl…
-
Back end table storing Costing type and Distribution groupSummary: Please share the back end table and column names storing costing type and distribution group name Content (required): HDL load fails with message A distribution…
-
Payroll Data Validation ReportSummary No results in Payroll Data Validation ReportContent I am trying to validate the data in test environment by executing the delivered Payroll Data Validation Repor…Sowdha Murugan 91 views 6 comments 1 point Most recent by Phia Belgica Reporting and Analytics for HCM
-
Gross Pay Balance for full Fiscal Year for all EmployeesSummary: I need to create or run a report for all employees to get the Gross Pay for each employee for our full Fiscal Year. Format of data needed Person Number Display …Andrew_Schmitz 82 views 1 comment 1 point Most recent by Jaeyshree Kumaran Reporting and Analytics for HCM -
Query to get balance value from run resutsSummary: Need a query to fetch value for given balance name('Gross Pay') and its dimension('Core Assignment Tax Unit Run'). the query should get value from run results n…Jaeyshree Kumaran 1.9K views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Top 10 Percent PaidSummary Need to pull the top 10% paid US staff Content Hi, I need to create a query that shows me my top 10% paid staff. The legal definition is: "In determining which e…user6284475 32 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Is there an HDL loader for the Federal Calc CardSummary: Hi All, I am looking to see if there is an HDL loader than be used rather than the HSDL loader CA Tax Credit Information Is there someway to cross reference whi…
-
SQL query to get the costing details at the element entry level.Summary: Hi , I have a requirement where I need to fetch the costing details at the element entry level. I have developed the code ( PFA) but not able to get the costing…
-
Payroll Costing and BalancesSummary: Has anyone ever used these two subject areas in an OTBI analysis correctly? : Payroll - Payroll Costing Setup Details Real Time & Payroll - Payroll Balances Rea…Andrew_Schmitz 41 views 7 comments 2 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM