BI Publisher
Discussion List
-
Self-Service & DashboardsSummary How do you share your reports with your users?Content Hello experts - I am hoping to find out best practices as to how you do reporting for your company (or how …Prudence K 112 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
BIP Report with OTBI PromptsSummary How do I create a dashboard that uses OTBI prompts for a BIP reportContent Hi all - we are experiencing an issue since our Rel12 upgrade, where the parameters fo…Prudence K 230 views 4 comments 0 points Most recent by User_2025-01-31-00-03-33-089 Reporting and Analytics for HCM
-
MAX formula with CONCAT calculated measureSummary Difficulty getting the formula to workContent The way our Talent Review Meeting's were created we were forced to use flexfields to store the data. So to include …User_2025-01-28-08-47-04-905 56 views 12 comments 0 points Most recent by User_2025-01-28-08-47-04-905 Reporting and Analytics for HCM -
Is there a way to catch the No Results message with a user-friendly message?Summary Is there a way to catch the No Results message with a user-friendly message?Content A way to catch the No Results error message with a user-friendly messageI hav…Kimberly Nguyen 68 views 7 comments 1 point Most recent by Kimberly Nguyen Reporting and Analytics for HCM -
calcul division , result wrong OTBISummary result of Division of sum (measure ) /sum(measure ) is not goodContent Hello , I want to calculate the percentage of headcount by competency So I have the number…User_I6AXL 61 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Assignment Audit ReportSummary Looking for a report that includes Updated, Corrected, and Deleted AssignmentsContent Hello, I am searching for an existing report or a way to report an audit of…User_2025-01-28-17-24-53-863 204 views 4 comments 0 points Most recent by User_2025-01-28-17-24-53-863 Reporting and Analytics for HCM
-
Cloud HCM cannot enable writeback,,,Summary Unable to understand how to write back dataContent Hi All, I am attempting to write back to a dff that i created but have been unsuccessful so far. In OTBI the o…Nicolas Trojack-24006 28 views 8 comments 1 point Most recent by Anil Pillaresetty Reporting and Analytics for HCM -
High number of columnsSummary High number of columns in BIP reportContent Hello everyone, Could you please give some tips on what is the best layout output option in BIP for a report that has…Alvaro Couto 34 views 13 comments 0 points Most recent by User_2025-07-18-02-05-33-261 Reporting and Analytics for HCM -
What does DATA_DS G_1 mean in BIP?Summary What does DATA_DS G_1 mean in BIP?Content Hello All, I am running a SQL in BIP and it is returning DATA_DS G_1 (see attached SQL and screenshot of DATA_DS G_1). …User_2025-03-07-21-07-25-805 480 views 6 comments 1 point Most recent by User_2025-07-18-02-05-33-261 Reporting and Analytics for HCM
-
Duplicate Rows; Multiple lines of dataSummary My report is spitting out multiple lines of the same data; trying to find a way to consolidateContent I'm building a report that will serve as a validation/audit…User_2025-01-28-20-40-07-753 160 views 8 comments 0 points Most recent by User_2025-01-28-20-40-07-753 Reporting and Analytics for HCM
-
HCM Extract Bursting PrioritySummary How to set bursting priority in BI Bursting or HCM extract delivery optionContent One of our integration partner requires trigger file (empty file with same file…User_2025-01-25-03-22-14-136 69 views 3 comments 0 points Most recent by DIVIAMARENDRA1201 Reporting and Analytics for HCM
-
Job Function NameSummary Need Function Name in BI Publisher reportContent Hello, I am building a BI Publisher report and need to pull in the Job Function Name I found the JOB_FUNCTION_CO…User_2025-01-23-21-24-21-434 774 views 3 comments 2 points Most recent by User_2025-01-23-21-24-21-434 Reporting and Analytics for HCM
-
Absence Accrual Plans for EmployeesSummary Need query table/analysisContent One of our states where our employees are located has ruled to provide hourly employees with sick pay of 40 hours per year after…Frank Wheatley 159 views 9 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Department tree versions issueContent Hi , Department tree having 2 versions , both are active , old version is end dated 31/12/2016 and new version is starts from 1/1/17. In new version existing dep…
-
How to Obtain "People Group" Field through BI PublisherSummary How to obtain "People Group" field through BI PublisherContent Hello All, I am unable to obtain "People Group" and "Legal Employer Name" fields through querying …Aahiri_Sarma 65 views 7 comments 0 points Most recent by Aahiri_Sarma Reporting and Analytics for HCM -
Table name to find the approved date and approve by columnSummary Table name to find the approved date and approve by columnContent Hi, I have a requirement to create a report with approved date and approved by column. My custo…User_2025-01-29-01-27-20-754 68 views 3 comments 1 point Most recent by Dr Surlina Yin-Oracle Reporting and Analytics for HCM
-
Locate setup/configuration tables in reporting/analytics toolSummary Locate setup/configuration tables in reporting/analytics toolContent We are discussing where set up tables can be located in the Reporting tool. For example, we … -
Weight updated from PerformanceSummary table of weight updated by PMContent Hi, I need to export the weight field about a goals that you can define from Performance Section. Could you please help me? …User_2025-01-28-21-18-09-074 42 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Can we expose analytics or dashboards to users on fusion pages without traversing to BI CatalogSummary Can we expose analytics or dashboards to users on fusion pages without traversing to BI CatalogContent We have developed some analytics and dashboards and the cl…Sricharan Monigari 109 views 11 comments 0 points Most recent by Lynda Huebsch-Oracle Reporting and Analytics for HCM -
Cross Subject Area Dashboard OptionSummary Need to join multiple subject area for dashboard purposesContent Hi, I apologize in advance if this is already discussed in some previous thread- if that is the …User_2025-01-30-19-26-42-218 46 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Total Purchases for Tier I SuppliersSummary I need to create an analysis that shows total purchases for specific suppliers.Content I need to create an analysis that shows purchase order line details such a…User_2025-01-28-00-30-46-187 49 views 1 comment 0 points Most recent by User_2025-01-28-00-30-46-187 Reporting and Analytics for SCM
-
Search a date un value of columns that containts multiple date (DD/MM/YYYY ~DD/MM/YYYY ~DD/MM/YYYY )Summary How to search for date of birth in the actual year from value which contains many datesContent Hello, I want to find persons which their date of birth is in the …User_I6AXL 29 views 3 comments 0 points Most recent by Aaron Leggett Reporting and Analytics for HCM