Reports
Discussion List
-
Delegation ReportSummary: Content (required): Is there a report or a subject area in which we can report all current delegations? We want to find which people are delegating to others an…Annette M 22 views 2 comments 0 points Most recent by Wiktor Ornatowski-Oracle Reporting and Analytics for HCM -
Termination - reporting offboarding commentsSummary: Content (required): We are trying to create a report that selects all terminated employees within a date range, along with the term action reason. Many times ou…Annette M 63 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
SQL or tables for Resignation Workflow Approver historySummary: Resignation Workflow Approver history Content (required): Hi all, I need to pull our the workflow details of Resignation workflow in BI. So please let me know f…Aditya Lanka 410 views 1 comment 0 points Most recent by MandeepGupta 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.7K views 6 comments 2 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
OTBI report logic to fetch Employees who were in current position as of 1st June,2019Summary: We have a requirement to create an OTBI report which will fetch all Employees who were in current position as of 6/1/2019. I was looking at the subject area - '…Sovan Mishra-Oracle 125 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to find 'User Defined Column' within Compensation PlanSummary: Can anyone help locate this field within a Compensation Plan. I need to find "Numeric Column 18", preferably within a Subject Area or if it's only within a tabl…Andrew_Schmitz 35 views 5 comments 1 point Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
Performance Task Next Step BIP ReportSummary: Creating a BIP report for Performance Tasks showing Step/Next Step Content (required): We have a BIP report for the Performance Task Steps which include Task St… -
Report to Audit object migrationsSummary: A report that shows who created/updated application objects (i.e. Fast Formulas). Content (required): Version (include the version you are using, if applicable)…Wayne Smith 31 views 2 comments 0 points Most recent by Paidiparthi Ravindra Reporting and Analytics for HCM
-
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 …
-
Subject Area filtering - empty valuesSummary: Subject Area filtering - empty values Content (required): Subject Area filtering of Assignment Type filters out empty values as well. For example, if we have pe…User_2025-02-11-21-40-21-159 22 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
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 184 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Report on 'Ad Hoc' feedbackContent The business has decided they want the option to give feedback without the one receiving the feedback being able to see it (don't ask me why). We've advised the … -
Termination Report Unable to Pull In SalariesSummary Trying to pull a historical report of terminations in a certain location with salary amount at time of termContent Hi - I have looked into a number of posts rega…Kyle Norris 68 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Report to fetch Element with assignment number and name for employeesSummary: i am using the below SQL to fetch the details. But the SQL is taking time to fetch the details. Can anyone please let me know if my i am missing any join Conten…minati_behera-Oracle 21 views 1 comment 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Sum of Distinct/Unique values in Header for ETEXT templateSummary: Sum of Distinct/Unique values in Header for ETEXT template Content (required): I have 4 records for same person in my xml. All 4 records have same salary($2000)…Jaeyshree Kumaran 480 views 5 comments 0 points Most recent by Jaeyshree Kumaran Reporting and Analytics for HCM
-
Year to Date Turnover FilterSummary How to return Year to Date (YTD) this year vs. YTD previous years for turnover metrics.Content I'm trying to return year to date turnover and compare it against …Ryan_Sullivan 30 views 3 comments 0 points Most recent by Ryan_Sullivan Reporting and Analytics for HCM -
Embedded Reports and the environmentSummary: Every time we take a release, I have to relink all of our embedded reports to point to our TEST environment. Content (required): Is there any way that we can ha…User_2025-02-04-08-51-08-912 2 views 2 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
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 113 views 6 comments 1 point Most recent by Phia Belgica Reporting and Analytics for HCM
-
Report for tracking duration of TerminationsSummary: We have a need to report on the duration of termination, in specific, how long was the time period between when the termination request/workflow was initiated a…Adil_R 22 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
ETL lineage for Oracle Fusion HCM AnalyticsSummary: Looking for ETL Lineage / Data lineage for Oracle Fusion HCM Analytics. FAW Content (required): Looking for ETL Lineage / Data Lineage for Oracle Fusion HCM Ana…Mangesh Bhanage 42 views 2 comments 1 point Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for HCM
-
EEO-4 Report - any ETA from Oracle?Summary EEO-4 Report - any ETA from Oracle?Content As every customer need a standard EEO-4 report as part of requirement, I understand it is in scope of future release. …
-
Subject Area - Column collapse aggregationSummary: Subject Area - Column collapse aggregation Content (required): Hi, I am trying to build a report to display Position FTE, and Incumbent FTE. However, to calcula…User_2025-02-11-21-40-21-159 12 views 1 comment 1 point Most recent by Julian Challenger-Oracle 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 2.7K views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Line Manager DOR- with 0 CountSummary: I have created a Line Manager report with no filters - the intention was the manager can view all their direct and indirect reports. But as there is no filter t…
-
How to get the total Headcount of Employees and contract worker on monthly basis.Summary: We are trying to create a dashboard using Analysis Report, but when we try to fetch the headcount of employees and contract workers through analysis, there is a…Harish.M 566 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Getting Shift Hours For An Employee On Particular DateSummary: Folks, We have a requirement to fetch the Hours On Date. Example. Find the screenshot attached. If we pass parameter date as 03-Dec-2018 then 35 hours 77777700-…
-
Tools-> Report and Analytics not available to End user (SUI interface)Summary Tools-> Report and Analytics not available to End user (SUI interface)Content Tools-> Report and Analytics not available to End user (SUI interface) Please sugge…Avaneesh Jain-5059 49 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Privileges required to open Payroll Element Entries - Real Time subject areaSummary: Hello experts, do you know the privileges required to open Payroll Element Entries - Real Time subject area? Thanks in advance for your time! Kind Regards, Vale…Valerio Curzi 12 views 3 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Dashboards and InfoletsContent Hi, I created a simple infolet and a dashboard for Absence Mgmt data. I created the infolet and added the simple report. When it comes to "Add Content" for the L…HulyaAkan76 44 views 2 comments 0 points Most recent by Kamini Kaushik-Oracle Reporting and Analytics for HCM
-
Seeded Data Model and Report For Grade Step ProgressionSummary Seeded Data Model and Report For Grade Step ProgressionContent Hi Team, Where do get the Seeded Data Model and Report for activity 'Grade Step Progression' scree…User_2025-02-01-03-43-13-079 112 views 13 comments 0 points Most recent by Vijay Gorania Reporting and Analytics for HCM