OTBI
Discussion List
-
Avg Time to Resolve (In Hrs)Summary: We are using the "CRM - CRM Service Request Summary" table to prepare service request data using reports. As part of that, there is a report that provides week-…Anusha716 11 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
OTM BI Publisher - Run Report using Rest API or any other mediumDear Community We have a requirement where 3rd party application would like to run a report using REST API or any other medium (e.g. Webservices). We would like to know …
-
How to create OTBI for chart of account value ?Summary: Can I create OTBI for all segments in the chart of account value sets, like the hierarchy structure? Content (please ensure you mask any confidential informatio…
-
Role required to Search for Report JobsSummary: User X (with BI Admin role) is unable to search and view BI report submitted by user Y. Content (please ensure you mask any confidential information): User leil…Shubhojit 53 views 3 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Can we display alpha numeric values in Pivot table?Summary: Can we display alpha numeric values in Pivot table? Content (please ensure you mask any confidential information): We have a requirement to fetch the UDT (User …
-
Count of All Performance Goals is not showing properlySummary: Hello, can you pls check my filters below. The Count of All Performance Goals is not showing properly so I added the Goal Status filter but still not showing up…
-
OTBI Dashboard and Reports for ExpensesSummary An OTBI dashboard with a series of drillable reports for ExpensesContent The attached catalog files can be imported into an ERP Cloud instance to create a dashbo… -
SQL query that brings the fields to HDL for CostCenter?Summary: Content (please ensure you mask any confidential information): Does anyone have a SQL query that brings the fields to HDL for CostCenter ? Simple with the minim… -
Possible to trigger Learning Alert from Learning Status?Summary: Hello, Are we able to configure Learning alerts that will be triggered when a Learning Assignment is changed to a particular status? For example, Exempted, Not … -
OTBI Managers and Direct Reports Additional FieldsSummary: I need to create a report that summarizes the span of control for job levels that have direct reports. Looking for the right fields to use. Content (please ensu…
-
Historical Location Data Workforce Learning - Learning Records Real TimeSummary: Content (please ensure you mask any confidential information): We have started to move our reports to the Workforce Learning - Learning Records Real Time as the…Jeremy CSC 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Absence Date Start in OTBII created a report using Workforce Management - Absence Real time that shows absences employees have along with the date created, and date start of the request. I notice…
-
losing headcounts while using some columns in parameter FDIHello I'm facing an issue while using a parameter in FDI for the subject area HCM - Workforce Core. below an example when I use this paramater, I get the right headcount…Ayoub AFRASS 11 views 2 comments 0 points Most recent by Ayoub AFRASS Reporting and Analytics for HCM -
Is Learning Access working dynamically when add access based on 'analysis report criteria'?Summary: Content (please ensure you mask any confidential information): Is using 'analysis report criteria' dynamic when add access to learning items? for example: analy…
-
Length of Service based on Rehire date calculationContent I am trying to calculate Length of Service based on employee's latest hire date. I used Workforce Event Real Time subject area to calculate the rehire date (usin…Riti Malhotra 138 views 6 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to bring HCM UDT Columns into Fusion OTBI subject areaSummary: Need to access the UDT columns (HCM) in OTBI standard subject area's instead of using the "Payroll - User Defined Tables Real Time" as a separate subject area. …
-
Setup connection/API from Fusion reports to Azure data warehouseSummary: Hi Team, Any suggestions on sending the data from Fusion reports (OTBI/BIP) to our internal Azure data warehouse without using a flat file method of SFTP. Any o… -
How to identify who made changes to the DFFs we used in our OTBI reports?Summary: There are few OTBI reports in Dev env which resulted in error because of missing DFFs. we got the DFFs back by running the schedule process. but we want to know…Hitachi ServiceDesk 21 views 4 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
How to filter a column?Summary: Hello, I need help on how could I filter to show only the last row. Thank you in advance! Content (please ensure you mask any confidential information): Version…
-
Learning courses linked to any of the communityHi Team, Anyone developed the report to link the courses under the topic community? If so, please share. Thanks,
-
How to create BI report/analysis based on external data?Summary: Is it possible to create report/analysis based on external data, such as an external ERP system? What options does Fusion have for this kind of connection? Is i…Max Prestes 41 views 1 comment 0 points Most recent by Jain Piyush-Oracle Reporting & Analytics for Sales -
Is there any standard report for reject inspection in Oracle Fusion?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
CTO and OTBI practical tip as of 20AContent Dear SCPers! There are 2 points I would like to bring to ease troubleshooting and avoid filing SRs in the following scenarios. 1. OTBI fix will come in 20C. With…DinaJacobs-Oracle 54 views 2 comments 0 points Most recent by SARTHAK GOSWAMI Supply Chain Planning and Collaboration