Report Delivery
Discussion List
-
Returning the most recent dateSummary Want to return only the most recent dateContent I have an analysis that I am doing in BI and trying to return just one record per person, with the date as the fi…Deb Luisi 96 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How can I create a BI report, which shows the list of users who are locked into the system.Summary I want to create a BI report, which shows all the users whose ID is locked into the system. They are Active users but not suspended.Content Can anyone tell me th…User_2025-01-29-18-45-01-148 103 views 5 comments 1 point Most recent by User_2025-02-01-06-21-55-603 Reporting and Analytics for HCM -
Need help in excel templateSummary Need help in excel templateContent Hi All, I'm facing issue when I try to paste the xsl code into a cell in the excel template. Let me brief about my requirement…User_DZMJW 55 views 2 comments 0 points Most recent by User_2025-01-28-07-12-45-467 Reporting and Analytics for HCM -
Running a Report from the UI(Scheduled Processes)Summary Running a Report from the UI(Scheduled Processes)Content Hello All, In Oracle Apps we could register the report created and give access to a particular set of us…User_2025-01-31-20-01-00-954 67 views 6 comments 0 points Most recent by User_2025-01-31-20-01-00-954 Reporting and Analytics for HCM
-
BI publisher - share report links after R13 upgradeSummary issue with the links of the BIP report after R!#Content hi all, after upgrade our env to R13 - all are dashboards which contains BIP report (which we were used t…User_2025-01-30-04-14-21-127 44 views 1 comment 1 point Most recent by User720640-Oracle Reporting and Analytics for HCM
-
how to fetch previous and current value for global transfer action?Content Hi, we are not able to find solution to action 'global transfer' (when changing Legal entity) to see in one report the old and new value- related to the fact new…Gal Shani 123 views 13 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
BIP Bursting sending one email with consolidated dataSummary BIP Bursting sending one email with consolidated dataContent Hi All, I have an requirement to send the list of pending workers to a team. My bursting query is wo…User_2025-01-31-20-01-00-954 148 views 6 comments 0 points Most recent by User_2025-01-31-20-01-00-954 Reporting and Analytics for HCM
-
Training documentation/slides for general usersSummary Training documentation/slides available for general (non-builder) user populationContent Good afternoon. Does anyone know of any "basic" OTBI/BI Publisher presen…Rich R 63 views 1 comment 0 points Most recent by Dr Surlina Yin-Oracle Reporting and Analytics for HCM -
Push Weekly Email Notifications to a particular group of Line Managers and EmployeesSummary Push Weekly Email Notifications to a particular group of Line Managers and EmployeesContent Hi Friends I need to send couple of weekly notifications to a group o…Mansur Khalil 57 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Mapping of OBI Subject area to HCM ExtractsSummary Document for mapping OBI Subject area to HCM ExtractsContent Hi We have been using OBI Subject areas to extract data dump from HCM fusion. Now that our databse h…Mohit Gupta-45440 96 views 4 comments 0 points Most recent by Mohit Gupta-45440 Reporting and Analytics for HCM -
Need to develop a BI Publisher report that will have filter mechanism in the output.Summary Need to develop a BI Publisher report that will have filter mechanism in the output.Content Need to develop a BI Publisher report that will have filter mechanism…Aloka Bhattacharya 65 views 4 comments 1 point Most recent by Sricharan Monigari Reporting and Analytics for HCM -
Join Grade Rate Real Time and Salary Details Real TimeSummary I want to create a report with information from Workforce Management - Grade Rate Real Time and Compensation - Salary Details Real Time but I can not join them p…Rogelio H 94 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
OTBI Analytic: 2 values in one column - share it to two columns or show meassures only once in one cSummary Behind one field there are two different values . Under the results the two values are summarized in one column. Would need each value in a separate column. How …User_2025-01-25-03-41-47-642 124 views 2 comments 0 points Most recent by Karen B 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 78 views 8 comments 0 points Most recent by Julian Challenger-Oracle 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 44 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle 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…
-
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 67 views 8 comments 0 points Most recent by Gail Langendorf-Oracle 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 45 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 116 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 124 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 59 views 5 comments 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 39 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
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 77 views 4 comments 0 points Most recent by Dr Surlina Yin-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…
-
Scheduler Account LoginContent Hi all - we have a problem we are hoping you can assist :) Right now, we have a few developers that will schedule reports. However they are the only ones that ca…Prudence K 36 views 4 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM -
FTP using PPKContent Hi all - need your help on this one! I am not overly familiar with using FTP, but can muddle my way through when using a regular set-up (host, login, password). …
-
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…
-
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…