OTBI
Discussion List
-
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 -
Preparing a custom fixed asset reportSummary Custom report designContent Hi, I would like to create a custom fixed asset report.What data model should I select or create or how can I do that ?(BI Publisher,…Armagan Sahin-57534 211 views 1 comment 0 points Most recent by Jennifer Sherbrook - CNL Reporting and Analytics for ERP
-
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 -
Salary basis for future hireSummary Using the Compensation - Salary details real time don't see salary basis for future hireContent We need to get the salary basis for new hires, rehires, etc. For …User_2025-01-30-04-37-05-780 75 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Suppliers on Purchasing Hold by Supplier Type ReportSummary Dashboard Displaying Active Suppliers On Purchasing Hold By Supplier TypeContent This dashboard will allow you to retrieve a list of your active suppliers that h…Aishwarya Pawar-Oracle 126 views 2 comments 4 points Most recent by Aishwarya Pawar-Oracle Reporting and Analytics for ERP
-
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 479 views 6 comments 1 point Most recent by User_2025-07-18-02-05-33-261 Reporting and Analytics for HCM
-
Donuts instead of PiesSummary Is it possible to output Donut charts instead of pie charts?Content Most modern dashboards contain at least one donut / doughnut chart. Few contain pie charts an…User_2025-01-23-23-50-04-709 102 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Top N querySummary Filter top 5 leaving reasonContent Hi, I want to create a report that shows the top 5 reasons of leaving (e.g. 'found another job", "Low salary" etc.). I know wh…
-
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…
-
Manager Types in reports - HELP NEEDEDContent Hi All, I want to create a report that will show the manager type + manager name for each employee. i.e. Person Name Manager Type Manager Name Dudi Levi Line Man…Dudi Levi 97 views 7 comments 0 points Most recent by Julian Challenger-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 … -
SQL Expression for a specific month and day with a year of current year - 1Content Hi - I need to add a filter to an OTBI report that is hire date greater than 10/1 of the prior year. I would like to make the year dynamic based on the year of t…Julia SRI International 146 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How can we find roles/access needed for a subject areaSummary How can we find roles/access needed for a subject areaContent Hi All, We are on R12. Our OTBI subject areas (for FIN and PRC) are working only for some users and…
-
Phones and emails make duplication rowsSummary I'm trying to add columns for emails and phones but instead of one line it's duplicating itContent Hi, I created an analysis in OTBI that shows employees phones …
-
Does Drill down feature work for Logical SQL based Analytics?Summary Want to know if the drill down feature works with analytics developed using Logical SQLContent For one of the requirement it was not possible to use the fields d…Sricharan Monigari 98 views 6 comments 0 points Most recent by Sricharan Monigari 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
-
FA Retirement & Reinstatement SummarySummary How to Print Retirements and Reinstatements in the same OTBI reportContent Hi, We are trying to print FA Retirement details (Asset Cost, NBV, Gain Loss) and FA R…Sridevi Srikanth 33 views 0 comments 0 points Most recent by Sridevi Srikanth Reporting and Analytics for ERP -
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
-
Addition of New Field withing Subject AreaSummary How to add new filed (proejct classification) within a particular subject areaContent We have created Project Classification such as "Accounting Business Objecti…User_2025-01-30-19-08-20-842 54 views 1 comment 0 points Most recent by Dustin Grabowski-Oracle Reporting and Analytics for ERP
-
Payroll Activity ReportSummary Page breaks in Payroll Activity ReportContent Hello, It would be really nice if the payroll activity report could page break between person. I think it would mak…Susan Anderson 158 views 3 comments 1 point Most recent by Richard Marko-47911 Reporting and Analytics for HCM -
I Cant find the Flexfield AR_CASH_RECEIPTS in OTBIContent Hi All, I did add Descriptive Flexfield to account receivable - Receipt Screen - under Additional Information ( global segment - Descriptive Flexfield name ( AR_…User_2025-01-29-22-38-36-974 80 views 3 comments 0 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP
-
Publishing a custom dashboard to one user from OTBI in HCM FusionSummary Need assistance in publishing a custom dashboard in OTBI out to a single userContent I have a custom dashboard that I only want one user to have access to. I kno…User_2025-01-25-04-17-41-399 143 views 8 comments 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM
-
Cross Subject Area Search Missing in OTBISummary Recently the instance we are working on (R12) Lost the ability to "Add a Subject Area" for OTBI reportsContent When we try to create a New Analysis and choose a …Sridevi Srikanth 107 views 7 comments 0 points Most recent by User_2025-01-30-21-01-20-715 Reporting and Analytics for ERP