OTBI
Discussion List
-
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 52 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 12 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 12 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 42 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 -
DFFs missing from few OTBI Subject areasWe have Multiple OTBI reports in which the DFF columns are missing from the subject areas. after running the “Import Oracle Fusion Data Extensions for Transactional Busi…Hitachi ServiceDesk 21 views 4 comments 0 points Most recent by Hitachi ServiceDesk Reporting and Analytics for HCM
-
Not able to join 3 subject areas including Quality Issue, Receiving Shipments and Purchase orderSummary: Content (please ensure you mask any confidential information): Not able to join 3 subject areas including Quality Issue, Receiving Shipments and Purchase order.…
-
[OTBI] "Workforce Performance-Performance Check-in Real Time" subject areaSummary: Duplication of "manager question text" and "manager response text" in "Workforce Performance-Performance Check-in Real Time" subject area. Content (required): A…kayoung lee 101 views 2 comments 0 points Most recent by Ilaria Petrosino Reporting and Analytics for HCM
-
Can we restrict jobs based upon roles?Summary: Hi Team, We are looking for a possible solution which might help us to satisfy the below requirement Step 1: A Custom roles to be created and assigned to a user…Dileep Varanasi 51 views 3 comments 0 points Most recent by Toyesh Patra Reporting and Analytics for ERP
-
How to add components under payables landing page in oracle fusion to create an infolet tile.How to add user defined component under Payables> Invoices in Oracle fusion to display the count of Not validated invoices. Attached the Screenshot below: I have tried w…MitaliMeshram 11 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
How to create a report combing planning and item category information with 2 subject areasSummary: Unable to create a report combing planning and item category information with 2 subject areas Content (required): There is an existing OTBI report created thru …Winky Chan 81 views 4 comments 0 points Most recent by Sudhir Behera Reporting and Analytics for ERP
-
Partially Accounted payment Accounting status is not able to fetch from data base tables or column.Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Travis Perkins Description (Required)…Bhanuchander Manthri 152 views 7 comments 2 points Most recent by Vivek Nigam Payables, Payments & Cash Management