OTBI
Discussion List
-
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 -
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 23 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 55 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 84 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 151 views 7 comments 2 points Most recent by Vivek Nigam Payables, Payments & Cash Management
-
Exclude Bank Holidays from Absence Days calculationSummary: Bank holidays are counted in the absence days calculation for a sickness absence but should be excluded Content (required): We have a number of sickness absence…Dawn Cawston - CPS 111 views 22 comments 2 points Most recent by Dawn Cawston - CPS Workforce Management -
How to Create a Grand Total Column in OTBI ReportSummary: We created a Payment advise report using the Payables Subject area, but the customer wants us to create a Grand Total column to Sum up all the columns, please h…Chukwuemeka Aniukwu 1.1K views 5 comments 0 points Most recent by Estefanía Payables, Payments & Cash Management
-
How to merge rows in OTBI?Summary: Hello, how can I merge these rows below? There seem to be an extra row under Role/Assignee and Due Date. Thank you Content (please ensure you mask any confident…
-
Work Schedule future dated rows not joining correctly OTBISummary: We have a report comparing the work schedule vs the work schedule assignment. Work schedule (Assignment real time) Work Schedule Assignment ("Person Schedule As…
-
How to know and then set the PO Approval limits for all the Approvers in the System?Summary: We are currently using Supervisory Hierarchy for PO Approvals . There is a requirement to find out the PO Approval limits of all the Approvers in the system and…