Reports
Discussion List
-
Union Field in Employee screenSummary Union Field in Employee screenContent Hello All , Can you please let us know where we can find "UNION" in which Oracle table. NAvigation is :- My Client Groups >…Lucky Sharma 39 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
OTBI Report with Employee names in the 9 Box instead of countContent We are trying to build a OTBI report that can show employee names in the 9Box instead of counts/ performance tiles. Attaching picture for reference. Is this poss…User_2025-02-10-08-27-16-805 39 views 4 comments 0 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM -
How to Include an url in the BI Publisher Bursting Email BodySummary How to Include an url in the BI Publisher Bursting Email BodyContent I have a link which needs be sent to the recipients going through the busting email. Here is… -
Function FILTER requires at least one measure column in its first argument.Summary Function FILTER requires at least one measure column in its first argument.Content I would like to use the filter function on a non numeric column but I run into…User_2025-02-10-08-27-16-805 318 views 4 comments 1 point Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM
-
Report using Contract DFFSummary How to build a report to include Contract DFFContent Hi, I have built a report joining the following subject areas Workforce Management - Employment Contract Rea…User_2025-02-08-08-11-51-624 32 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Subject area for Positions which has missing segments in Costing of PositionContent Hi Experts, I am new to OTBI analysis, I have a requirement to List all Positions which has missing segments in Costing of Position. Can anyone tell me which sub…Raghavendra M 52 views 6 comments 1 point Most recent by Raghavendra M Reporting and Analytics for HCM -
Monitoring License Metrics - Transactional Business Intelligence Cloud ServiceSummary What drives the license usage for Oracle Fusion Transactional Business Intelligence Cloud Service?Content Hi all, Many of the subscriptions are driven by a speci…Sian S 25 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Single output row for Course and Offering dataSummary Reduce duplicate rows in Learn Reporting of Course and Offering dataContent We have legacy course completion data that was loaded via HDL. Unfortunately we did n…Dean Soto 36 views 5 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Individual compensation plans subject areasContent Hello experts, I should create a payroll report in order to extract for each employee Individual Compensation Plans information. As a result, I need the followin…Valerio Curzi 41 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Head count by department for every month reportContent Hi, I'm looking for headcount report for each month by department. Can someone help me please. Thanks, VijayUser_2025-02-07-19-03-14-525 32 views 3 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Performance Rating With Compensation Data causing duplicate rowsContent Using Performance Rating from Compensation - Workforce Compensation Real Time subject area causes rows to duplicate for individual employee. I have tried to use …User_2025-02-10-08-27-16-805 28 views 5 comments 0 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM
-
Display Parent Manager First Name and Last Name in 2 separate columnsContent Hello, I have an analysis I am creating that the end user has requested manager first name and last name to be in 2 separate columns. I have referenced this post…User_2025-02-07-16-42-37-187 167 views 3 comments 0 points Most recent by HROps17 Reporting and Analytics for HCM
-
Report for Duplicate DependentsSummary Report for Duplicate DependentsContent Hi , Any one can help is their any report to find the duplicate dependents for each employee Regards, ReddykrishnaReddykrishna Chidella-Oracle 62 views 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM -
In need of an AAP Promotion report (FROM and TO details on job)Summary In need of an AAP Promotion report (FROM and TO details on job)Content We have AAP promotion report due in which they are asking FROM and TO of a job in a promot…Adil_R 70 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Expenses Employee Number to Worker - Person NumberSummary Cannot connect 2 subject areas to merge data in OTBIContent Using OTBI I am attempting to merge subject areas Workforce Management -accruals real time with Expen…User_2025-02-10-15-06-52-222 29 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Passing parameter from Dashboard Prompt to BI ReportSummary Passing parameter from Dashboard Prompt to BI ReportContent Hi, I know we can pass parameter from Dashboard Prompt to Analysis. I wonder if we can do it from Das…
-
How to Remove the HTML tag from the goal comments in BI ReportSummary How to Remove the HTML tag from the goal comments in BI ReportContent Hi Expert, How to Remove the HTML tag from the goal comments in BI Report Note: OTBI Report…User_2025-02-05-01-04-36-989 51 views 2 comments 1 point Most recent by User_2025-01-25-01-10-42-578 Reporting and Analytics for HCM
-
modify list of recipients on scheduled reportSummary modify list of recipients on scheduled reportContent We have a scheduled report to which I need to add two recipients. I have not had any luck in the schedule or… -
How to export approval rules configured for HCM transactions such as Absence, Employment etc.Summary How to export approval rules configured for HCM transactions such as Absence, Employment etc.Content Looking for a report to fetch the custom approval rules conf… -
Issues on Termination report with datesSummary Termination report not showing correct amountsContent Hi, I have created Termination report using "Workforce Management - Worker Assignment Event Real Time" subj…Niko Hölttä 28 views 4 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Payslip Summary section is not matching main sectionSummary Involuntary deductions is doubling and does not match the summary sectionContent Hi All, Has anyone else had an issue with the Canadian payslip where the Garnish…User_2025-02-04-08-51-08-912 20 views 2 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
Displaying an uploaded document stored as a blob in a BI Publisher report?Content We have a report request to display attachments that are uploaded by employees in a BI Publisher report. The uploaded attachments are stored as a blob and the ta…Karen Costakes 40 views 3 comments 1 point Most recent by Karen Costakes Reporting and Analytics for HCM -
First "Approved" Position RecordSummary SQLContent Hey guys. I'm trying to extract the first approved record's effective start date of all my active positions. I tried to use this in order to extract t…BenZionP 5 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Combining multiple subject areas but using one as the main data setContent Hi All, As there are certain subject areas only that would contain information needed but also have it's own limitations, I am trying to combine two subject area…Eric.C 43 views 11 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Resize a performance tileSummary I would like to arrange about 10 of them next to each other and I need to reduce size of each container.User_2025-02-08-08-49-19-186 33 views 2 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Report on Scheduled Process (ESS Jobs)Summary Looking for report on Scheduled Process (ESS Jobs)Content Hello, I'm looking for a report on scheduled processes. Does anyone have such report and would like to … -
Set PARAM_EFFECTIVE_DATE within a UNIONSummary Combine results of 2 analysis when one has an effective dateContent I have two reports with the same columns and I am combining them with a UNION. However one an…s_b 39 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Point in Time Org Chart with open vacanciesContent Hello, Has anyone built a Point in Time Org Chart with open vacancies? Thanks in advance!Dishti Malhotra-Oracle 29 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
View Report Based On Legislative Data GroupSummary View BI Report Output Based On LDGContent Hi All, We have custom BI report which is using seeded data model to query. We would like to view report data based on …Ganesh Kokkula 32 views 2 comments 0 points Most recent by Ganesh Kokkula Reporting and Analytics for HCM -
Legal Employer Hire Date and Enterprise Hire Date on Work Relationship DetailsContent Hi All, Can someone help to find underline tables and fields for "Legal Employer Hire Date and Enterprise Hire Date on Work Relationship Details Tab" If you have…User_2025-02-07-19-03-14-525 61 views 2 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM