Reports
Discussion List
-
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 1 view 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 111 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 21 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 41 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 11 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 592 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 11 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 -
Assigment changes- help needed in reportsContent Hi, Is someone can share his knowledge regarding report which can indicate what are the fields in the transaction that were changed(which field). The report is s…User_2025-01-22-19-54-47-882 50 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
View Display Error- Odbc driver returned an error (SQLExecDirectW).Summary: I created one OTBI analysis with some filter as prompted. The analysis is working fine with admin roles but when line manager is running report it is showing Vi…Kamini Kaushik-Oracle 11 views 2 comments 0 points Most recent by Kamini Kaushik-Oracle Reporting and Analytics for HCM -
How to avoid Line Manager seeing personal and family contact names in ReportsSummary: How to avoid Line Manager seeing personal and family contact names in Reports Content (required): How to avoid Line Manager seeing personal and family contact n… -
Passing parameters to schedule event trigger in flow patternSummary: Hi All, We have defined a flow pattern consisting of different tasks. We have the parameters in the flow which is linked back to the individual tasks. One of th…Anirudh Udupa 21 views 2 comments 0 points Most recent by Anirudh Udupa Reporting and Analytics for HCM -
Need OTBI Subject Area and columns for incomplete tasks under Allocated Checklist.Summary: We have a requirement report incomplete tasks under Onboarding Checklist, I used Workforce Management - Checklist Realtime subject area. I am able to get the ch…Raghavendra M 41 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Min, Mid and Max Salary Ranges missing for some associates in OTBI Report. How can we fix this?Summary: Unable to pull Salary Range Min, Mid and Max for some associates in OTBI report. Content (required): Hello, While pulling a report created in OTBI the Salary Ra…AH SL 31 views 3 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Cost center detailsSummary: Hi, Can anyone provide SQL to get cost center details of the department. Content (required): Version (include the version you are using, if applicable): 21C Cod…Reddykrishna Chidella-Oracle 11 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
View Display Error- Odbc driver returned an error (SQLExecDirectW).Summary: I created one OTBI analysis with some filter as prompted. The analysis is working fine with admin roles but when line manager is running report it is showing Vi…Kamini Kaushik-Oracle 61 views 0 comments 0 points Started by Kamini Kaushik-Oracle Reporting and Analytics for HCM -
Learning community reportContent Hi does anyone have a learning community report they could share? Kind regards MelissaUser_2025-02-06-11-18-47-896 56 views 4 comments 0 points Most recent by User_2025-02-06-08-05-57-271 Reporting and Analytics for HCM -
Need OTBI/BI query for checklist QuestionnaireSummary Need OTBI/BI query for checklist QuestionnaireContent Hi All, We have created Off boarding checklist and we are planning to develop a report(OTBI/BI)based on que…User_X612P 241 views 6 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Candidate Profile Print out ReportSummary Candidate Profile Print out Report BuildContent Hi All, I have a new requirement to build Candidate Profile Print out Report HCM--> My Client Group --> Hiring --…Iann hick 86 views 9 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to link locations with geographySummary: Content (required): Hello Guys, We would load the city present in the locations inside the Geography of the recruiting. How could we perform it? Where could we …Giuseppe Iacono 41 views 2 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
Query for extract Hierarchy ManagerHi there , we need to reconstruct the hierarchy of a user's managers via a query in BI. The real problem we encounter when a manager then has several active assignments …User_2025-02-07-06-30-13-200 2.1K views 6 comments 0 points Most recent by User_2025-02-07-06-30-13-200 Reporting and Analytics for HCM -
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 -
Catalog of Payroll Flows Dashboards in OTBI reportingContent From 21C or 21D release onwards, following OOTB Payroll dashboards will be deprecated: * Active Processes Dashboard * Payroll Flow Details Dashboard To continue …Tanvi Jain-Oracle 300 views 6 comments 4 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Not able to add dashboards objects and OTBI contents on Dashboard pagesSummary: I am trying to create one dashboards using analysis but when I created one dashboard and trying to add column sections and other dashboards options on dashboard…Kamini Kaushik-Oracle 21 views 5 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM