Reports
Discussion List
-
Location of Worker Availability seeded report in BIContent The Worker Availability report is visible by default on the Manager Resources Dashboard. As of R12 this dashboard is not enabled by default, as the patch notes s…User_2025-01-25-01-23-28-110 134 views 20 comments 2 points Most recent by Karen Waddell Reporting and Analytics for HCM -
Can I use Date Transformation function (TIMESTAMPADD , TIMESTAMPDIFF, CAST) on a Dashboard Prompt(prSummary Can I use Date Transformation function (TIMESTAMPADD , TIMESTAMPDIFF, CAST) on a Dashboard Prompt(presentation variable) before using it to compare in Analysis.C…User_MC37Q 89 views 3 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
OTBI: Adding 2 dates (Effective Start Date) and (Effective End Date) to the Dashboard PromptSummary OTBI: Adding 2 dates (Effective Start Date) and (Effective End Date) to the Dashboard PromptContent Hi, I have a scenario where I need to add 2 dates on to the d… -
BIP BurstingSummary Image in RTF Template received as attachment in emailContent Hi, We have a requirement to have company Logo and some images in the email notification, which will…Sivakumaran Muthusamy-Oracle 112 views 4 comments 0 points Most recent by Unknown Reporting and Analytics for HCM -
Oracle HCM Cloud Report documentationContent Hi all, as of Release 10, there was some excellent documentation on the shipped reports here: https://docs.oracle.com/cloud/farel10/globalcs_gs/globalcs_report.h…John Palethorpe 01 62 views 8 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Display Bin even with zero resultsSummary Is there a way to still include a Bin in the analysis output with zero results?Content Hello, I have an analysis where I am using Bins to count employees by age …Susan Anderson 42 views 3 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM -
OTBI Analysis Error: A Drive Table join exceeded the limit of 10 backend database queries. (HY000)Summary OTBI Analysis Error: A Drive Table join exceeded the limit of 10 backend database queries. (HY000)Content Hi, I am getting error "A Drive Table join exceeded the…User_MC37Q 47 views 8 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
OTBI Analysis: Can I do a Analysis A - Analysis B (Both analysis have headcounts with different filtSummary OTBI Analysis: Can I do a Analysis A - Analysis B (Both analysis have headcounts with different filters)Content HI, OTBI Analysis: Can I do a Analysis A - Analys…User_MC37Q 107 views 5 comments 0 points Most recent by Mark Johnson Reporting and Analytics for HCM -
Date effective OTBI report errorSummary Including Current date as default for presentation variable with PARAM_EFFECTIVE_DATEContent Hi I am trying to create an OTBI report which uses 'Effective_Date' …Mohit Gupta-45440 120 views 9 comments 0 points Most recent by Prudence K Reporting and Analytics for HCM -
Possible to embed link to run a report, inside a Dashboard pageSummary Embed link to run a report, inside a Dashboard pageContent We have a request to embed a link in a Manger's Dashboard that will allow them to run a pre-built repo… -
OTBI Analysis: Upon clicking on a performance tile, the relevant data(detail levelin tabular format)Summary OTBI Analysis: Upon clicking on a performance tile, the relevant data(detail levelin tabular format) should come up.Content Hi, I have a OTBI analysis where I ha…User_MC37Q 55 views 5 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Gauge/Dial Chart AssistanceSummary Creating a gauge chart within OTBI with custom thresholdContent I'm looking to build a simple gauge capturing capturing the average number of days it takes our H…User_2025-01-28-08-47-04-905 42 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Exceeded Maximum Results Error when adding a promptSummary Any way around this?Content I'm looking to build out a trend report, using the WF Trend Subject area, which will allow the user to select a manager via a prompt …User_2025-01-28-08-47-04-905 56 views 5 comments 0 points Most recent by Timothy Orrange Reporting and Analytics for HCM -
OTBI: YTD Values in Payroll Balances Subject AreaSummary OTBI: YTD Values in Payroll Balances Subject AreaContent Hi, Is there a way we can display the YTD Balance values from the "Payroll Balances Real Time" Subject A…User_2025-01-22-19-45-49-284 208 views 3 comments 0 points Most recent by Karen Long Reporting and Analytics for HCM -
Handling data field containing a comma while generating CSV files using etext templates in BI PublisSummary Handling data field containing a comma while generating CSV files using etext templates in BI PublisherContent Hi, I have an etext template to create a .csv (com…Aloka Bhattacharya 821 views 3 comments 4 points Most recent by Timothy Orrange Reporting and Analytics for HCM -
Can we use run time parameter in Bursting?Summary Email BurstingContent Hi Everyone, Can we use parameter in bursting like we use in our sql. Regards, Poornima PaliwalUser_2025-01-31-01-21-22-432 44 views 1 comment 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
After upgrade to Rel 13, compensation OTBI report is running into an error.Summary After upgrade to Rel 13, compensation OTBI report is running into an error. - Datatype: 17 is not supportedContent After upgrade to Rel 13, compensation OTBI rep…User_2025-01-25-04-02-13-126 35 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
After Upgrading to R13 Prompts and Filters on Certain Fields Causing Reports to Error OutContent After upgrading to R13, several reports have stopped running as expected. We have narrowed it down to certain prompts and filters in the report. For instance, we…
-
Archiving of hierarchiesSummary I'm curious as to how others are archiving their hiearchies to enable historical reporting.Content Is there a way we can set effective dates to Hierarchies in EP…User_2025-01-28-21-08-14-146 37 views 1 comment 0 points Most recent by Mark Rinaldi-Oracle Planning -
Areas of Responsibility assign to workers- how can we pull data in reports?Content Hello, If someone can share his knowledge regarding how can we pull the data - responsibilities assigned to workers? we want to track the employees's areas of re…User_2025-01-22-19-54-47-882 73 views 4 comments 0 points Most recent by Dr Surlina Yin-Oracle Reporting and Analytics for HCM -
Bar Chart SortingSummary Is there a way to sort the horizontal color axis by the measure?Content Is there a trick to getting a chart to sort when adding color to the horizontal axis? I h…User_2025-01-28-08-47-04-905 26 views 4 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
BIP Publisher BurstingSummary BIP Publisher BurstingContent Hi, Is it possible to give multiple email addresses in the TO parameter of bursting definition sql query in Oracle Fusion HCM BI pu… -
OTBI Drill down to transactional recordSummary OTBI Drill down to transactional recordContent Is there any way we could drill down from an OTBI analysis to the transactional record to take some corrective act…User_2025-01-22-19-27-16-253 247 views 3 comments 0 points Most recent by User_2025-01-30-01-56-27-828 Reporting and Analytics for HCM -
Data visibility issue with Compensation Subject Areas (Compensation - Salary Details Real Time)Summary Data visibility issue with Compensation Subject Areas (Compensation - Salary Details Real Time)Content Hi, We're facing the data visibility issue with Compensati…User_2025-01-30-20-59-13-989 64 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
BI Publisher: Is contractor information stored in PER_CONTRACTS_F table.?Summary BI Publisher: Is contractor information stored in PER_CONTRACTS_F table.?Content Hi, I would like to know when is a entry made into table:PER_CONTRACTS_F. I beli… -
Future Dated TerminationsSummary Future Dated TerminationsContent Hello, Does anyone know of a way to pull in action codes that are future dated? When I run the analysis, I can pull in people th…User_2025-01-30-00-38-09-143 73 views 3 comments 2 points Most recent by User_2025-01-25-02-35-56-629 Reporting and Analytics for HCM -
Setting Permissions on OBIEE analysisSummary Customize access permissions on BI analysis (not BIP)Content When we are setting up permissions on BI analysis, it seems as though even though a user was set wit… -
Converting BI Analysis to BIP (Easily)Summary Need to convert existing analysis to BIPContent Is there an easy way, if any, to do this?