Reports
Discussion List
-
Assignment Status Reporting IssueSummary Assignment Status Reporting IssueContent Hi All, I am building a Global Payroll Transfers Report in OTBI with the SA "Workforce Management - Worker Assignment Ev…User_2025-07-18-02-05-33-261 59 views 4 comments 0 points Most recent by User_2025-07-18-02-05-33-261 Reporting and Analytics for HCM -
make infolets available based on the user's roleContent Hello, We are using infolet in production but we don't have find a way to display those depending of the user's role. Most of the infolet (in example) are used t…User_2025-01-25-01-33-46-269 218 views 17 comments 3 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
New Hire and Termination ReportSummary Combining Active and Inactive Information in one ReportContent Hi, We currently have a BI Publisher report that were pulling all the New Starter base on the date…User_2025-01-29-01-38-21-058 201 views 2 comments 0 points Most recent by User_2025-01-29-01-38-21-058 Reporting and Analytics for HCM
-
Last calendar day of the previous month as default promptContent Hi Oracle Community, We are trying to have a prompt with the date automatically set on the last calendar day of the previous month (which is our closing day), bu…[Deleted User] 46 views 3 comments 0 points Most recent by [Deleted User] Reporting and Analytics for HCM
-
BI Publisher: Is there a alternative view for per_all_people_f table?Summary BI Publisher: Is there a alternative view for per_all_people_f table?Content Hi, I am currently using per_all_people_f and per_all_assignments_m tables (which ar…User_MC37Q 75 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Unable to get the from email address in BurstingContent Hi All, In the bursting query for the parameter3 value we are passing "bipublisher-report@oracle.com" and able to get the email after report submitted. If we use…
-
Has anyone built a report that lists all possible drop down menu option for HCM fields?Content Afternoon all, I was wondering if anyone has built a report that shows all configured data items for OOTB fields and DFF. We want to do an audit of all configure…User_2025-01-28-05-39-23-766 68 views 2 comments 0 points Most recent by User_2025-01-28-05-39-23-766 Reporting and Analytics for HCM
-
Count of Workers With No Performance GoalsSummary Need for building a report with workers without any performance goalContent Hi community, We currently have the report attached in BI to count workers per # of g…[Deleted User] 67 views 2 comments 0 points Most recent by [Deleted User] Reporting and Analytics for HCM
-
Future Dated RecordsSummary Future dated records/Inserted rowsContent I need to build a daily report for when managers/HR has entered a change when there are future dated records that need …User_2025-01-28-04-58-46-119 97 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Performance Management Comments in OTBISummary Performance Management: Competency comments and Overall comments in OTBIContent Hello, I have realized a custom report to extract Performance Management competen…Giuseppe 1234 127 views 3 comments 1 point Most recent by User_2025-01-28-07-43-08-025 Reporting and Analytics for HCM
-
Need inputs to fetch the Element Additional DetailsContent Hi All, While creating Element we need to provide required information in the Element additional details. Please suggest in which table (SQL) or Subject areas ho…
-
Turnover Formula AssistanceSummary Building a turnover % by termination typeContent Using a CASE formula I have identified and split out terminations by our company's preferred type, desired and u…User_2025-01-28-08-47-04-905 70 views 3 comments 0 points Most recent by User_2025-01-28-08-47-04-905 Reporting and Analytics for HCM
-
Can I use Dashboard Prompt in the individual Column Formula in my analysis?Summary Can I use Dashboard Prompt in the individual Column Formula in my analysis?Content Hi, I have a requirement where I need to use the dashboard prompt(Presentation…User_MC37Q 41 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Creating OTBI report with employee termination detailsContent I need to create a OTBI report to get employee termination details. I used Workforce Management - Work Relationship Real Time subject area but after release 13 c…User_2025-01-28-21-18-43-496 508 views 10 comments 1 point Most recent by User_2025-01-28-21-18-43-496 Reporting and Analytics for HCM
-
Salary Currency field causing error on reports in R13Summary Compensation Reports error out. Determined caused to be related to Salary Currency field.Content I have two Compensation Reports that error out. I determined the…User_2025-01-28-20-43-56-568 38 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
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 135 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 90 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 115 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 43 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 38 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 110 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 119 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 56 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 57 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 184 views 3 comments 0 points Most recent by Karen Costakes 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 735 views 3 comments 3 points Most recent by Timothy Orrange Reporting and Analytics for HCM