OTBI
Discussion List
-
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 585 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 173 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 271 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 22 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 101 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…
-
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 485 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 931 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 11 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…
-
Procurement Dashboard not showing amounts in ledger currency USDHi, We are using the standard procurement dashboards "Procure to Pay." Our ledger functional currency is USD; however, we have observed that the values displayed in the … -
PRJ: How to enable the Manage Project Cost DashboardDear Team, Can you please advise how to enable below dashboard. Regards Prashant
-
How to confirm PGP enabled report output is delivered with encryption on SFTP without checkingSummary: Is a way to confirm PGP enabled report output is delivered with encryption on SFTP without checking SFTP server Content (please ensure you mask any confidential… -
Need SQL QUERY for PPR details along with terminated status with no installments and stageNeed SQL query for PAYMENT PROCESS REQUEST details in oracle fusion cloud along with terminated batches where status='no available installments'Renuka Chougule 401 views 3 comments 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
Which table can I use to extract the Award Approved Date for each RFQ?Which table can I use to extract the Award Approved Date for each RFQ?
-
BI Report: multiple filters return no results but when filters used individually returns recordsSummary: I have a BI report relating to Opportunities. I'm using 3 subject areas and one is a custom subject area, a group initiative that allows us to group opportuniti…Tonya H 41 views 3 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales