Payroll
Discussion List
-
how to sum two condition in e-text template on oracle fusion hcmSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable): -
how to sum two condition in e-text template on oracle fusion hcmSummary: When we add all 4 fields the output of the report comes blank. I am able to add Shift Pay+Incentive+Current Salary the output appears but when i add Lead Pay (w…
-
Output from BI Report is not fully getting passed to HCM Extract in the flowSummary: We are working on the process with the flow including the first step of HCM extract execution which calls BI Report to generate the data in HDL format and then … -
Query to get account numberSummary: Query to get account number present in below screenshot Content (required):Navigation - Payroll>Statement of earnings>Costing Results>Account number. Can anyone…Jaeyshree Kumaran 31 views 1 comment 1 point Most recent by Dharmendra Shukla Reporting and Analytics for HCM
-
PARAM_EFFECTIVE_DATE based on payroll balance effective dateHi Team, We are creating report using logical SQL. We are fetching balance details for the whole year. So, Assignment details should be based on the balance effective da…
-
Fiscal calendar in OTBIHas anyone built a fiscal calendar in OTBI? A 5-4-4 fiscal calendar. Our fiscal year starts in November (October 28th for 2020). We have a lot of reports that we end up …SM-Oracle 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report needs to show accruals for current and previous time dimensionsSummary Report needs to show accruals for current and previous time dimensionsContent Experts, Need your help!Could you please let me know if you would use an HCM Extrac…Aloka Bhattacharya 18 views 2 comments 1 point Most recent by Aloka Bhattacharya Reporting and Analytics for HCM -
Payroll - Calculation Cards Real Time FieldsSummary Trying to find two specific fields withing Calculation Cards Subject Area: Issuing Authority and Order Amount Payee.Content I am working on building a report for…
-
Role permissions to BI reportsContent We want to give access to our HR manager to modify BI report or create an adhoc OTBI analysis for the recruitment and onboarding module. What permission can we g…
-
Payroll Pay Affecting changes reportSummary Payroll Pay Affecting changes reportContent Hello, I am in process of creating the Payroll Pay affecting changes report and wanted to know if any one has come ac…Dharmendra Jha 46 views 2 comments 0 points Most recent by Dharmendra Jha Reporting and Analytics for HCM
-
Incorrect result in summary report for Payroll - Element entries history real timeSummary Incorrect result in summary report for Payroll - Element entries history real timeContent For an employee, I am getting 8 records and the sum is 631.95 I have be…AvaneeshJain 13 views 5 comments 0 points Most recent by AvaneeshJain Reporting and Analytics for HCM -
Facing a error while fetching the balance Results from Payroll. Error : ORA-20001: An error occurredContent I'm fetching the different balance results from payroll custom balance groups & getting an error ORA-20001: An error occurred. An assertion failure was detected …Akshat Rajpurohit 29 views 1 comment 0 points Most recent by user526585-Oracle Reporting and Analytics for HCM -
Payslip - Other Deductions Section is showing doubled amountSummary Need help in determining if the issue is just with the BI Report or if the dataset is pulling in the wrong informationContent An employee had his garnishment (In…PamS 45 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI Reports over Payroll DataSummary We experience terrible performance when we run OTBI reports over subject areas such as Payroll Balances Real TimeContent The OTBI reports tool is struggling to p…Raz Baboorian 48 views 4 comments 2 points Most recent by Raz Baboorian Reporting and Analytics for HCM
-
Need to create a report that will extract data which doesn't have costing options enabled at departmSummary Need to create a report that will extract data which doesn't have costing options enabled at departments, jobs, positionsContent Hello Everyone, We have requirem…Prudhvi Indukuri 20 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Workers Compensation wage reports neededSummary Looking for recommendations and examples of reports related to Workers CompensationContent Our team that administers our Workers Compensation programs has not fo…
-
Bank Account UpdatesContent I was wondering if anyone had a report that was able to pick up changes to bank account information? We currently have a report that pulls the last update date o…Matthew Voss 122 views 4 comments 0 points Most recent by Matthew Voss Reporting and Analytics for HCM -
OTBI Elements Report is not Pulling in All ElementsContent I've built a simple OTBI report for Retirement Deductions and Matching Contributions. My company has 401K, 403B, and 457 Retirement Plans. So, I've filtered for …FDWilliams 39 views 1 comment 1 point Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
Pay Code / Element Mapping to General LedgerContent Is there a Subject Matter Area which permits you to build an OTBI report of the Pay Codes and the GL Coding or Concatenate Segment associated with the specific P…FDWilliams 92 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Need query to pull finalised or processed pay period namesSummary Need query to pull finalised or processed pay period namesContent Need query to pull only finalised or processed pay period details?
-
SQL query to get net pay amount of an employee on the monthly basisContent Hi All, Creating an outbound interface where need to fetch the employee's monthly net amount. Hence, need SQL query for the same. Context: Employee have multiple…Arti P 2.6K views 8 comments 0 points Most recent by Gopikrishna Nerella Reporting and Analytics for HCM -
Database Table and Database Column for Target Bank presentation tableSummary Need the parameters to build a BIP report for outputContent I am building a report that displays as a form completed for each new starter however it will not out…Dawn Cawston - CPS 30 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Query to pull earnings balance for each assignmentContent Need help on pulling earnings balance for each assignment or identifying which assignment has earnings.Renzel Keith Coquia-204674 54 views 2 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Employee Salary ReportContent Is there a seeded report (or a custom report you would share), that includes the wages for a period (entire year), including the employee name, date of hire, tot…Annette M 236 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to create a Custom Job Role (Read Only) for using "PAYROLL - ELEMENT ENTRIES REAL TIME" subjectSummary Need to create a Custom Role which gives read only access to UI and allow access to "PAYROLL - ELEMENT ENTRIES REAL TIME" subject areaContent Hello Experts I hav…Dharmendra Shukla 23 views 2 comments 1 point Most recent by Dharmendra Shukla Reporting and Analytics for HCM -
SQL query help needed - Payroll tablesSummary Reporting on those employees who have had a garnishment added in the selected payrollContent Hi All, I hope someone is able to help me out. I am trying to debug …
-
Scheduled Report Returning only 25k rowsSummary Scheduled Report Returning only 25k rowsContent I have an OTBI report that i am running that has output greater than 25k rows but less than 65k rows. I thought i…User_EQ8R5 86 views 4 comments 0 points Most recent by Raymund Jerome Reporting and Analytics for HCM
-
OTBI - Reporting Monthly Net Pay ValueContent Hi all, Does anyone know the correct subject area and field to use in order to report on the net pay value an employee would receive? I've been looking at the fo…
-
Audit DahsboardSummary Need help finding Audit DashboardContent I remember seeing Audit Dashboard. I can't seem to find it. Does anyone know is there a Oracle delivered Audit Dashboard…User381997 66 views 1 comment 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need SQL query to fetch Balance Initialization/Balance AdjustmentContent Hi All, We are looking SQL query to fetch the Balance Initialization/Balance adjustment data. Please share SQL query if anyone is having in handy. Thanks, Visu