OTBI
Discussion List
-
Adding prompt with manager for get the entire hierarchyContent Hi, any suggestion on how to insert a prompt in a OTBI to filter the result on manager and display the direct and indirect reports. Thanks NicolaNicola Petri 74 views 12 comments 2 points Most recent by Kylie Hauenstein Reporting and Analytics for HCM -
Default values from Fusion Cloud is not showing in OTBISummary: We are using Oracle Transactional Business Intelligence (OTBI) to generate reports from Fusion PLM. However, when we attempt to generate reports for attributes … -
Default values from Fusion Cloud is not showing in OTBISummary: We are using Oracle Transactional Business Intelligence (OTBI) to generate reports from Fusion PLM. However, when we attempt to generate reports for attributes … -
Participant Feedback Report RequestSummary: Does anyone have a good way to report on 360 participant feedback within a performance document? We've tried to use the Workforce Performance - Performance Rati…Anton Rzhanov 43 views 3 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to get Week of the Year in OTBI ReportsWEEK_OF_YEAR(dateExpr) not giving expected/correct valuesSagarChadha 1 view 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
Differences in Assigned Learning Item Title / Duplicate Lines - Learning Records Subject AreaSummary: I've started to re-build our learning reports in the Learning Records subject area, but I'm having problems with the way the data displays. Content (required): … -
Learning Records Subject AreaSummary: This document provides an overview of Learning Records Subject Area. This document contains details of all folders and dimensions exposed in the learning record… -
Learning subject area Workforce Learning - Learning Management Real Time scheduled removalSummary: Hello, Back in 21B, Learning subject area Workforce Learning - Learning Management Real Time was scheduled for removal. Has there been any update as to when thi… -
Learning Records Real Time - Reporting on RecommendationsSummary: Trying to report on recommendations using the Learning Records Real Time subject area. It appears that a recommendation is an event which doesn't appear in the …Rob F 1 view 3 comments 0 points Most recent by Tomasz 'TJ' Jublewski Reporting and Analytics for HCM -
Unable to view the Export option while accessing the OTBI report via Performance TileSummary: Hi. I think I have a similar issue to https://community.oracle.com/customerconnect/discussion/561120/unable-to-view-the-export-option-while-accessing-the-otbi-r… -
Can we create a custom dashboard for Managers to check all subordinates RFQ /Order detailsSummary: Can we create a custom dashboard for Managers to check all subordinates RFQ /Order details Content (please ensure you mask any confidential information): Need t… -
PPM - REST API to Extract Fusion Project data for EPBCS Integration?Summary: Dear Community, We are currently working on integrating Fusion Project Portfolio Management (PPM) data with EPM Cloud Planning (EPBCS). Please note that due to … -
AR Aging ReportSummary AR Aging ReportContent Hi all, I am doing a AR Aging Report using OTBI. For example: AR aging report has following columns: Customer Name, Transaction Date, Tran…User_2025-02-04-05-26-22-197 136 views 8 comments 1 point Most recent by Ayala01 Reporting and Analytics for ERP -
Maintenance Work Order Cost OTBI Subject AreaWhere can i find Subject Area for Maintenance Work Order Cost, I am using Costing Subject area but it only shows Manufacturing Work orders. Please help -
Is it possible to report on default validity rules of courses?Summary: Is it possible, using BI Publisher or OTBI, to report on courses Default Assignment Rules (specifically the fields: Validity Period Starts/Validity Period Optio… -
System AlertContent Hi i need system send alert to user when order line status change from waiting shipping to waiting billing Thanks
-
OTBI - ConcatenationSummary Is it possible to create a field that concatenates two or more text fields in an OTBI analysis?Content I am trying to create an OTBI Analysis using the Procureme…User_2025-01-28-20-11-21-100 958 views 3 comments 1 point Most recent by Ayala01 Reporting and Analytics for ERP -
Ability to Report on Person Profile Competency Rating vs. Model ProfileSummary: Hello, I need guidance on whether it's possible to generate a single analysis that compares an employee's rated competency with the competency level associated …Emily Cox 121 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Do we have any standard report in Oracle Accounts Payable for Payment exception and EncumbrancesSummary: Business want to find the report for the below need. It looks we have no report, please advice Content (please ensure you mask any confidential information): Li…Kish_Hariharan 3 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management -
OTBI dashboards using 2 fields prompts based on oneSummary: Dashboard with two prompts fields based on one field, and currency prompt Content (please ensure you mask any confidential information): I'm creating a dashboar…MYassikaya 33 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Dependents not displaying on reportSummary: I had a detailed Benefits Enrollment report that had the employee's information and dependent information displaying on the same report. I started with Benefits… -
Position Hierarchy queryHi, I need a small query that returns parent position name and code of positions. Is it possible for you to share the query about it? Regards -
Assistance Required for Converting OTBI Query to Oracle Standard TablesSummary: I am reaching out to seek your expertise regarding the conversion of an OTBI query subject area into Oracle standard tables. Specifically, I am looking to under…Guthi Mallikarjun 21 views 8 comments 0 points Most recent by Guthi Mallikarjun Inventory Management -
OTBI project costing assets subject area filtering on in-service date results in no recordsI created an OTBI analysis using the project costing assets subject area. See fields in the screenshot below. The analysis returns correct results. However, when I filte… -
Subject Area Related to CE_BANK_ACCOUNTS to get bank account Num & Asset Code Combination IDI am using "General Ledger - Journals Real Time" Subject Analysis & need to Join using Code Combination ID to get above bank account numSagarChadha 22 views 2 comments 1 point Most recent by SagarChadha Reporting & Analytics for Fusion Service -
Need a report with employee's default expense account and position informationSummary: I need a report with the employee's default expense account and position information so I can verify the account is correct. Is there a trick to connecting the … -
Print Page Number of Total PagesSummary: Case 1: In an analysis, how to print Page # of total pages? Case 2: Same analysis embedded in a Dashboard, how to print all lines from the analysis in PDF forma… -
How to add last_updated_by column in the report/data downloaded from "Submit Vacation Rules Report"How to add last_updated_by column in the report/data downloaded from "Submit Vacation Rules Report" in "Manage Workflow Rules in Spreadsheet". Please help to find standa…Thanigainathan R 1 view 0 comments 0 points Most recent by Thanigainathan R Reporting and Analytics for ERP