Reports
Discussion List
-
Standard report to track dashboard and reports accessesHi, is there a standard report that is useful to track users accesses in Dashboard HR and also the detail on which reports in this dashboard they access? We configured t…Mara Tammaro 12 views 2 comments 0 points Most recent by Mara Tammaro Reporting and Analytics for HCM -
Table to extract BPM Approval Groups InformationHi, I cannot see any data when querying the tables below. Could it be due to the role? What could be the reason? I think it should be recorded in these tables. fa_fusion…Cansel Karasoy 23 views 4 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
ESS Job Report with link between parent and child requestsSummary: ESS Job Report with link between parent and child requests Content (please ensure you mask any confidential information): Hi Team, We use the different reports …Parag Hiremath 575 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to get the Path of Sub Templates of Total Compensation Statement Seeded ReportSummary: We have a requirement to Customize the Total Compensation Statement Seeded Report Template We are not able to get the path of the sub Templates used in it. Cont…MilanMohanty 35 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Link a report to a button near to the All-in-One evaluationSummary: Content (please ensure you mask any confidential information): Hi experts, I need to add a link that redirect me to a dashboard. Is it possible to achieve it th…Elena_Panniello98 11 views 1 comment 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
Age Formulas using SQLSummary Need age as of the current date and when someone will be a certain ageContent Hello, I am needing a formula to calculate age in Years that does NOT round. For ex…Rebekah Gilday 90 views 9 comments 0 points Most recent by Diane G123 Reporting and Analytics for HCM -
Which action for a DEEP LINK can I use to manage a REQUSITION in DRAFT status?I need to create a custom notification with a link that leads to the detail of a requisition that is in draft status. I've tried with this deep link: //fndSetup/faces/de…Gian Luca Triglia 31 views 5 comments 0 points Most recent by Gian Luca Triglia Reporting and Analytics for HCM
-
Will selecting Application Role within Report Agent set up secure the rows based on AORs?Summary: Hi all We want to create an agent that sends the results of an OTBI analysis to our HR Business Partner population. If I add our application role for them will …
-
Grade Step DetailsContent Good Day, Within Report creation in OTBI we are trying to report on all Grade Step Levels from Grade to Step to Ceiling etc. But we are unable to find the "code"…User_2025-01-28-07-12-45-467 133 views 8 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Grade Step in OTBISummary Workforce Management - Worker Assignment Real Time does not display current gradeContent Hi, Does anyone know which subject area would give me Grate step values …User_2025-01-31-00-03-33-089 304 views 25 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Unable to get results when pulling Grade data in with Job Structure dataSummary Report fails when fields from Grade Rate Real Time are pulled inContent Using two subject areas: Workforce Profiles - Model Profile Real Time and Workforce Manag…User_2025-01-28-20-43-56-568 37 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Comparing columns from two different Analysis areas.Summary Comparing columns from two different Analysis areas.Content I am attempting to grab Job Codes for employees and the grades for the jobs. In the analysis i am usi…User_2025-02-10-19-21-48-801 36 views 14 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Issue with Grade Rate Real Time Subject AreaSummary Grade Rate value is not returnedContent We had a requirement to display all workers who has a current salary not equal to the current grade step rate value i.e, …Akash Kiran Jana 26 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to report on missing Costing of Positions?Summary: Content (please ensure you mask any confidential information): I'm trying to find a way to report on Position Costing that is missing. In the 'costing of positi…Leanne W 132 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Is there a way to pull service accounts into user admin reports?Summary: Currently our existing user lists only pulls users who are employees in the system. We need to be able to pull a list of all accounts as we have service/generic…
-
Scheduling a BIP Report for Biweekly...Summary Bi-Weekly schedulingContent HI All, I was wondering if there was any way to easily schedule a report to be run bi-weekly. We have some reports that need to be ru…User_2025-02-04-08-51-08-912 172 views 4 comments 2 points Most recent by Sree Latha Reporting and Analytics for HCM
-
Parameter definition in reportI will use the last_update_date parameter in the report I prepare. But I want to use the last_update_date column in more than one table in a single parameter. For Ex: pe…Cansel Karasoy 23 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
manager hierarchy analysisSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Bhagyashri_Bhoge 14 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to use Listagg functionality in OTBI AnalysisSummary Listagg in OTBI reportsContent Hi Team, Listagg function in OBIEE reports is used to display multiple lov's in a a single row with (,)separator. How can we achie…Kalyani Koylada 962 views 8 comments 0 points Most recent by Tonya H Reporting and Analytics for HCM
-
Only display the row with the earliest seniority dateSummary: Hi I'm creating a basic staff list which has seniority date on (some of our staff have protected service from a previous company) and I need to be able to show …HRJon 41 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Payroll - Calculation Cards Real TimeContent Good Morning, We are trying to find granular details with regards to Pension details. On the front end we can see in a sub-folder called 'Calculation Component D…User_2025-01-28-07-12-45-467 185 views 7 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Report to get employee default expense accountSummary Report to get employee default expense accountContent Hi is there any report which can get what is the default expense account attached the employee please? this…User_2025-01-29-02-09-34-137 103 views 13 comments 1 point Most recent by Isabela Radivoi Reporting and Analytics for HCM
-
In past we get all questions from prescreen questions report but now two questions missing ?Summary: HI Team, In past we get all questions from prescreen questions report but now two questions missing ? any refrence and help me on . Please find issued SQL file.…AjayKumar Maddipati 23 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Report to get list of users who are lockedSummary I need to get a list of locked user accountsContent I looked at the 'Reporting on Application Users and Roles' section the Oracle documentation, but none of thos…David Villegas 1.6K views 17 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Identifying global transfer records, hire/rehire records from per_periods_of_serviceSummary: Identifying global transfer records, hire/rehire records from per_periods_of_service Content (please ensure you mask any confidential information): Hi All, Empl…Gayathri K M-Oracle 743 views 5 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Is there a way to show only data for a user that is running a dashboard?Summary: I have created a dashboard for several reports. It shows the user that last updated a record. Is it possible for the user that runs the dashboard to show only r… -
Can we dynamically change paramters value in each execution run of scheduled BI report.Summary: We want to change the report paramter value in each execution run of scheduled BI report. Content (please ensure you mask any confidential information): Version…Sourabh_Patial 31 views 4 comments 0 points Most recent by Sourabh_Patial Reporting and Analytics for HCM
-
Is there a way to get date tracked data for Per_periods_of_service tableI'm trying to figure out the date when the "Actual Termination Date" is changed, but Per_periods_of_service table has top of the stack record only. Is there a table that…
-
We can able to load the data in User-Defined Table Business objects but not able to see in frontSummary: We can able to load the HDL data but we can't able to see the data but in backend we can able to see the data. Note: If we entered manually in UDT then we can s…Ravindr-Oracle 83 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
To check if the requisition has Suspended state completion eventsHi, We had an issue in FAW, where for some requisition the suspended completion duration is missing. While debugging this issue, we are trying replicate the same in FA, …