OTBI
Discussion List
-
How to create one report that shows users, roles, and privileges on those roles?Summary: I need to create one report that shows all users and assignment info, the security roles on their accounts, and the privileges associated with each role. Does a…jpar 218 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Need sql for all Content including Catalog Item the Content is tied to from Learning moduleSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Sivaram Injeti 31 views 3 comments 0 points Most recent by Sivaram Injeti Reporting and Analytics for HCM
-
How to Report on the Learning Initiative Start Date and Initiative Stop Date in OTBI analysisSummary: Report on Learning Initiative details , How to get fields Initiate Number/Name, Initiative Start Date and Initiative Stop on OTBI analysis using Learning Record…
-
Receivables - Customer Real Time OTBI is not showing any report dataSummary: We have an OTBI report where we are using Receivables - Customer Real Time subject Area. When I run the report, its not showing any data. I have BI admin, Accou…
-
Error: This folder is read only. You cannot create a Data Model here.Summary Error: This folder is read only. You cannot create a Data Model here.Content When saving a BI Publisher data model in a particular folder I get this error: This …Ruzwan Akram 481 views 10 comments 0 points Most recent by John Guner Reporting and Analytics for HCM
-
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 41 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 124 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 925 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 1 view 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 31 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