OTBI
Discussion List
-
Onboarding/Recruiting Employee Name fieldSummary: What is an alternative for updating the "Employee Name" in OTBI, where it displays First Name Last Name for Onboarding/Recruiting, and not change any of the exi… -
Scheduling analysis for last day of monthSummary: Analysis schedules for end of month Content (please ensure you mask any confidential information): Hi everyone, Is there a way to schedule reports (analysis) in…
-
OTBI schedulingHello everyone, we need to schedule a report that needs to be sent to the client on the last day of the month for each month of the year. Currently the report is schedul…
-
Users able to access OTBI without security rolesSummary: Users without who do not have security roles to access reports and analytics are able to bypass this by using the below URL https://FUSIONURL.COM/analytics Is t…Tara Samari-237472 41 views 7 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
How to show Attachment Link in the ReportSummary Is there a way to show actual attachments link in a report whether in analysis or BIPContent Is there a way to report on actual attachment which was attached as …Prateek Parasar - GTUK, ACE Pro 1.4K views 25 comments 3 points Most recent by Neha_Naik004 Reporting and Analytics for HCM -
Employees with and without goalsSummary: Hello, I need help on this report. I need to show employees even if no goals. It used to show properly but now the report is only fetching the "with goals" stat…
-
How to Find Table with Approver Details for General Ledger Lines.Summary I am trying to create a audit report for GL entries however i need to retrieve the journal approver details. Please advise which table would have this informatio…Dave Sherrard 580 views 9 comments 1 point Most recent by Deepak Kumar Dev-Oracle General Ledger & Intercompany
-
OTBI - Join/Union Subject Area Payables Transactions Real Time to Payables Installments Real TimeSummary: Content (please ensure you mask any confidential information): We need to pull Due Date from Subject Area Installments Real Time against columns Invoice Number …Rory Mullin 161 views 5 comments 0 points Most recent by Alek Strader Payables, Payments & Cash Management
-
OTBI Workforce Trend: For better performance, use equi-filter on Calendar Month End Date columnSummary: This is an announcement to provide guidance to improve response time of Workforce Trend reports and dashboards. Content (required): 1- Response time of reports …Abhishek Dixit-Oracle 272 views 7 comments 5 points Most recent by MMS Reporting and Analytics for HCM -
Compensation - Indvidual compensation real time not showing any detailsDespite of having the necessary roles I still don't have access to show data from this subject area I added everything from this document, Document 3052888.1 but still, …Joliver Caangay 21 views 4 comments 0 points Most recent by Joliver Caangay Reporting and Analytics for HCM
-
How to know what AP invoice approval rule was triggered for a particular invoice?Summary: How to know what AP invoice approval rule was triggered for a particular invoice? Content (required): How to know what AP invoice approval rule was triggered fo…User_2025-03-10-23-59-44-230 1.1K views 5 comments 2 points Most recent by Prudhvi_S-Oracle Payables, Payments & Cash Management
-
Goals Created or Not Created by Country CodeSummary: When I use the union report suggested by Oracle/the community forum the no of workers without goals is not returning enough workers Content (please ensure you m…LynneLBL 11 views 1 comment 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM -
Past Incumbents in position tableSummary: HI, I have checked there is no column for past incumbents in HR_ALL_POSITIONS_F and also in subject area "Workforce Management - Position Real Time", But we can…Reddykrishna Chidella-Oracle 102 views 4 comments 1 point Most recent by Soumya Suravita Reporting and Analytics for HCM -
Some of the fields in the OTBI subject area are not populating valuesWe are trying to select "check number" from the OTBI subject area "Payables Payments - Disbursements Real Time" but the field results no values in it due to which the da…
-
Employee Name ChangesSummary: Employee Name Changes Content (required): I'm trying to determine via OTBI the history of someone's name and their changes, but I don't see any values where I t…
-
Deep Link to view the Purcahse Order details from OTBI report is not workingSummary: Deep Link to view the Purcahse Order details from OTBI report is opening a PO Web page but the page is blank Content (please ensure you mask any confidential in…
-
OTBI missing journey tasksWhen creating an analysis to report on deferred journey tasks, I am not seeing ALL results. I am getting some, but there are definitely others that are seen in the UI, b…Jessica D 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
I am looking for a filter to add to a date to show values in the current financial yearSummary: I have an OTBI analysis for terminated workers and I am wanting only those terminated in the current financial year to return in a filter. how to I write and ap…Sharon Ferguson 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Max Effective Date Record on a Combined Subject Area Report Or Null ValueSummary: We are trying to bring back one row for Performance Task Completion Date, either the Null row or the latest completion date. Using "- Performance Task Status De…Kristin Montoya TWU 11 views 2 comments 0 points Most recent by Gretch Atienza Reporting and Analytics for HCM
-
How to optimize SQL query on MOO_OPTYSummary: A BI Report must extract daily a specific set of specific opportunities Content (please ensure you mask any confidential information): We want to query on MOO_O…Luca Angheben 31 views 3 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
Is there any report to show that assets has already gone through physical count process?I would like to know whether there are any report/field which identified that assets has gone through physical count process. For Instance, Asset A has gone through phys…User_1W1HV 11 views 1 comment 0 points Most recent by Louise Gareau - Support - Oracle-Oracle Assets
-
Build a BI Publisher Report that tracks incremental changes in Core HRSummary Build a BI Publisher Report that tracks incremental changes in Core HRContent Hi Experts, I have a requirement for a BI Report wherein I need to pull a lot of ch…Aloka Bhattacharya 484 views 10 comments 1 point Most recent by Naresh Choudhary Reporting and Analytics for HCM -
User Account Details (Email Address) in Security ConsoleSummary Need table names to be able to pull email address kept in Security ConsoleContent Hi All, I am struggling to find and link tables to pull User Account Email Addr…User_2025-01-28-05-11-13-165 851 views 11 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Fixed Assets ReportSummary: We need a report in Fixed Assets Module which shows the beginning balances for the selected company and year in the parameter and then multiple columns showing …
-
Maximum report data size for offline (scheduled) reports value changeSummary: Maximum report data size for offline (scheduled) reports value change Content (please ensure you mask any confidential information): Hi Team, Greetings! How do …Parag Hiremath 21 views 3 comments 0 points Most recent by MitG-Oracle Reporting and Analytics for HCM -
We need to display the Tax Rate value of the Purchase Order line in OTBI.Summary: We need to display the Tax Rate value of the Purchase Order line in OTBI. So, we need to find out the subject area that we can create OTBI and display the value…
-
Transportation intelligent Global Currency not working as per expectationFor Shipments without Rate offering id, global currencies are not converting the cost to the assigned currency, and feeding the data to Transportation Intelligent. But t…ZeenathMafitha 21 views 3 comments 0 points Most recent by Narayana Rangollu Transportation Management
-
I need to create an analytic in OTBI To identify what work schedule is assigned to employeesI am trying to create a simple analytic in OTBI to show all employee names, their assignment numbers and the names of the assigned Work Schedule for each assignment. It …Peter Downer 15 views 4 comments 0 points Most recent by Peter Downer Reporting and Analytics for HCM
-
Need a SQL query to find the names of the procurement & requisitioning business units on a PO.Hi Team, I need a SQL query to find the names of the procurement & requisitioning business units on a PO. The output of the query will have the following columns, someth…