Reports
Discussion List
-
Fusion HCM BIP report completed with errorSummary Fusion HCM BIP report completed with errorContent Hi Everyone, When attempting to run a fusion hcm BIP report Online (not schedule) the following error occurs. E…Dhanuka Chamal 430 views 2 comments 1 point Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
Multiple Conditions CASE StatementSummary Build a case statement to include ELSE conditionContent Hi, Please see the attached formula logic. I am trying to build out this formula for multiple locations b…User_2025-01-25-03-46-43-745 271 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to add a column in OTBI Analysis summing up values of two other columnsSummary I am working on OTBI analysis, where I need to show a column which will sum up the values of two other columns at row level.Content Hello, I am working on OTBI a… -
Head-CountSummary how do i get head count using SQL QueryContent i want to get head count from oracle fusion by organization id to each organization Version oracle fusion last ver…User_2025-02-11-08-39-07-186 51 views 1 comment 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM
-
BIP Report with stacked Bar chart not showing all dataContent Hello, We have created a BIP report with stacked bar chart. But it is not showing all data. I have attached screenshot document here. There is 1 filled requisiti…Ananya Sadhukhan 50 views 2 comments 0 points Most recent by Ananya Sadhukhan Reporting and Analytics for HCM
-
Filtering Workforce Trend Real Time by item in Worker Assignment Real TimeContent Has anyone had success filtering workforce trend real time data by a data point in Worker Assignment Real Time? I want to report on the make up of our officer po…Lauren Owen 37 views 5 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Is it possbile to extract the SQL's wirtten in BI Publisher?Summary Is it possbile to extract the SQL's wirtten in BI Publisher?Content We would like to know if there is any option to export all the custom sql's written in BIP. T…GTS Narayanen 44 views 3 comments 1 point Most recent by MandeepGupta 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 31 views 1 comment 0 points Most recent by user526585-Oracle Reporting and Analytics for HCM -
CSV output being generated in a different layoutSummary BI Publisher report tab is not working properly when CVS output is selected.Content Hi Team, Maybe this is a known issue and I getting late aboard. I've added a …Alvaro Couto 32 views 3 comments 1 point Most recent by Alvaro Couto Reporting and Analytics for HCM -
BIP excel template to enhance pivot chartsContent We are trying to build a BIP report and include analytics (pivot charts) on one of the tabs. is there a way to not have to repeat the filters? For instance, Stat…User_2025-02-10-08-27-16-805 24 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Table to extract data from Manage Business Unit Set Assignments pageContent Hi All, I need help identifying which table I can pull the data in Manage Business Unit Set Assignment. I need to identify what is the reference data set of Busi…User_2025-02-08-02-40-14-106 440 views 2 comments 0 points Most recent by User_2025-02-08-02-40-14-106 Reporting and Analytics for HCM
-
How can we extract requisitions tied other locations data through BIP tables ?Content Hi All, PFA, screenshot and we have two tables available (IRC_REQUISITIONS_VL & IRC_REQ_LOCATIONS ) and the join is for tables is “IRL.REQUISITION_ID = IRV.REQUI…Janardhana Kondaveeti 33 views 4 comments 0 points Most recent by Janardhana Kondaveeti Reporting and Analytics for HCM -
Department Hierarchy and Department Changes reportingContent I have been working on rolling out a department hierarchy for my company. The hierarchy is complete and working but i am looking at how it interacts with things …User_2025-02-10-15-06-52-222 65 views 4 comments 1 point Most recent by MilanMohanty Reporting and Analytics for HCM
-
.cvs output file is splitting in 2 columns I want it one column only.Content Hi Experts, I have BI Report and I want output as .csv Tab Delimited. I did all setup and when I schedule this report I see output in 2 columns (A & B). I want i…User_2025-02-07-19-03-14-525 22 views 5 comments 0 points Most recent by Dilpreet Kaur Reporting and Analytics for HCM
-
Aggregate function on ValueSet is not workingSummary Aggregate function on ValueSet is not workingContent I have attached my query containing the where clause which is not working. Even the below value set is not w…Jaeyshree Kumaran 25 views 2 comments 0 points Most recent by Ashish Kumar Pandey Reporting and Analytics for HCM
-
Capture job changeContent Hello there. I want to capture only the job change event, but for example if i change only the job in the transfer section, it captures what is selected in the a…User_KXK94 24 views 2 comments 0 points Most recent by Aloka Bhattacharya Reporting and Analytics for HCM
-
Adding Grade Min, Mid, Max to a reportSummary Grade ratesContent I want to add Grade Min, Mid and Max to reports but get an error every time I try to add the Workforce Management - Grade Rate Real Time Subje…Donna Valentine 8 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
User Manual for adding OTBI report to HR dashboardSummary User Manual for adding OTBI report to HR dashboardContent Hi Team, Can any share user manual/White paper for adding a OTBI report to HR dashboard. Appreciate you…Dinesh Neredu 40 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Analytics Dashboard section header and report link font formattingContent Hi All, I have embedded dashboard on homepage, which has report hyperlinks and section header displayed. I have managed to change the background color same as ho…Punam Roy Karmokar 21 views 2 comments 0 points Most recent by Punam Roy Karmokar Reporting and Analytics for HCM -
Timezone used by time parameter is always in GMT. How can I let user pick the timezone when enterinContent I have a BIP report with a parameter with a time component (It is a date type with a date string of" MM-dd-yyyy HH:mm:ss am"). What I am noticing is that date en…Joe Roberts-Oracle 35 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Using Headcount Values in Reports and DashboardsContent I am trying to use headcount values in reports and dashboards, but the values are not lining up correctly. I know how to load the assignment work measure via HDL…Shannon Lackmeyer 40 views 2 comments 3 points Most recent by Shannon Lackmeyer Reporting and Analytics for HCM -
In which report Enterprise name along with organization structure is displayedContent Hi Team, Do we have any report which displays Enterprise name alone with org structure details like Enterprise, division and so on. Kind Regards, Rahul -
Require a report to show when a Primary Mailing Address is missing in the systemSummary It was noted with our T4's this year that an employee received his T4 with an incorrect Primary Mailing Address - when we look in the system, the Primary Mailing…User_2025-02-04-08-51-08-912 1.1K views 6 comments 3 points Most recent by Vijaya Kumar Komari Reporting and Analytics for HCM
-
Help Performance Section info Cannot Coexist with Overall RatingsSummary I get an error when I put section rating and overall Ratings togetherContent Hi All, I created a report that shows Overall Manager Rating but when I try to pulli…Charles Egegbara 34 views 2 comments 0 points Most recent by Natalie Andrek Reporting and Analytics for HCM -
Displaying Dashboard to Welcome ScreenContent Hello All, We have been able to successfully add the Dashboard to the Welcome screen in a Sandbox with Page Composer. What we are running into now is any user no… -
OTBI Reporting Leave Begin DateSummary Displaying actual Leave Date or the date when the employee returned to workContent Hi All, Need some help with an Analysis that I have built to show employees th…User_2025-02-04-08-51-08-912 43 views 4 comments 0 points Most recent by User_2025-02-10-19-46-17-403 Reporting and Analytics for HCM
-
How to display embedded dashboard only on a custom page categoryContent Hi Team, I have embedded a dashboard on homepage springboard. Now that dashboard is embedded to all tabs of the springboard. 1) Is there a way to embed it only t…Punam Roy Karmokar 26 views 1 comment 0 points Most recent by Punam Roy Karmokar Reporting and Analytics for HCM
-
Date and Time Generated in an OTBI Report or Dashboard with No ResultsContent Hi there, We have a few OTBI Analyses that are combined into a Dashboard and the Dashboard is then scheduled to be emailed on a bi-weekly basis. The ask is to in…
-
SQL to Pull Most Current Ethnicity recordSummary Looking for BIP Data Model that will select the most current EthnicityContent Hi, I am creating a data model of person information and have been challenged when …Denise Izzi 1.2K views 5 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Briefing Books FunctionalitySummary Briefing Books FunctionalityContent Hi All, I would like to know the briefing books functionality, Please share the briefing book document or session video if an…[Deleted User] 40 views 2 comments 0 points Most recent by [Deleted User] Reporting and Analytics for HCM