OTBI
Discussion List
-
Financials Cloud OTBI Release 11: Subject Area Description DocumentSummary This document provides a comprehensive description of each subject area including the key business questions that can be answered using the same.Content Use this…Anand DN-Oracle 112 views 3 comments 2 points Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP -
Release 11 Data Lineage Guide for FSCM (Financials, Projects, Supply Chain)Summary The Data Lineage Guide provides a mapping of the BI Subject Area columns to source data base tables and columns. It also has the View Object (VO) names for each …Anand DN-Oracle 139 views 3 comments 2 points Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP -
Cross-Application, Cross-Subject Area OTBI AnalysisSummary Ability to include cross-application analysis within one PPM dashboardContent I have a requirement to build a Project Portfolio Management dashboard in OTBI. Mos…Charles Heishman 172 views 2 comments 2 points Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP -
Using My Oracle Support (MOS) site as an OTBI Knowledge ResourceSummary Using 'search' box on MOS as additional resource to seek Reporting and Analytics answers/find documentsContent Many a time the issue you are encountering would a…Anand DN-Oracle 75 views 1 comment 4 points Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP -
Not able to find "Invoice Self-assessed Tax amount" at the Invoice line folder in Payables TransactiSummary We are trying to get the Invoice Self-Assessed tax amount at the Header level and also at the line level from Payables Invoices - Transactions Real time subject …GopiKAutomus 55 views 2 comments 2 points Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP -
Customize a Trial Balance Report predefined by OracleSummary Add a new column with the Client description which their balances are included in the same account.Content Hello all, I don't know if there is an 'easy' way to c…Sergio De Gracia 424 views 3 comments 1 point Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP -
Missing Tax Static Data and Missing Tax Config ReportSummary Missing Tax Static Data and Missing Tax Config ReportContent We are in Fusion R13 18C and I'm looking for SQL help to write a report in OTBI or BI Publisher 1/ E…Raj Mohanraju-128052 31 views 0 comments 0 points Most recent by Raj Mohanraju-128052 Reporting and Analytics for ERP -
Can't see Allias for new value in Smart ViewSummary Can't see Allias for new value in Smart ViewContent Hi I cannot see the alias for the attached new values in Smart View even though I published to the respective…Pablo Schenquerman 19 views 0 comments 1 point Most recent by Pablo Schenquerman Reporting and Analytics for ERP -
EXTRA BLANK ROWS IN REPORTS WITH PERSON PROFILE REAL TIME DEGREES OR MAJORContent Hi Team, Removing the comments Thanks, Niketa Version 11.13.18.10.0Niketa Ashwini 27 views 0 comments 0 points Most recent by Niketa Ashwini Reporting and Analytics for ERP -
OTBI-QuestionsSummary OTBI-QuestionContent Hi All, OTBI Questions. 1. What might be the reason for displaying data from OTBI in a scenario, like the analysis was displaying data till …Amarnath Govindu 90 views 2 comments 0 points Most recent by Amarnath Govindu Reporting and Analytics for ERP -
OTBI: Project Cost - Inception to DateSummary Project ITDContent Good People, How to get project inception to date cost ? Thanks, SoumyaSoumya Prakash Parhi 114 views 8 comments 1 point Most recent by Xavier Cuinier Reporting and Analytics for ERP -
Get the Code and Meaning from FND_LOOKUP_VALUES_TL for OTBI ReportingSummary Get the Code and Meaning from FND_LOOKUP_VALUES_TL for OTBI ReportingContent Hi All, We are trying to build an OTBI Analysis for Bank Transaction Codes. The Subj…User_2025-02-03-21-08-45-135 47 views 0 comments 2 points Most recent by User_2025-02-03-21-08-45-135 Reporting and Analytics for ERP -
MddsException when trying to consume a WebService from Oracle Cloud BISummary MddsException when trying to consume a custom WebService from Oracle Cloud BIContent I have problem when trying to consume a WS I deployed on my Oracle WebLogic …User_2025-02-04-13-18-34-458 31 views 0 comments 0 points Most recent by User_2025-02-04-13-18-34-458 Reporting and Analytics for ERP -
Subject Area in Account Paybles to get information for OTBI from AP_PAYMENT_TEMPLATES tableSummary Subject Area in Account Paybles to get information for OTBI from AP_PAYMENT_TEMPLATES tableContent Hi All, I need to pull the Template Name and Template Descript…User_2025-02-03-21-08-45-135 42 views 4 comments 0 points Most recent by Veronica Dumitriu Reporting and Analytics for ERP -
SUBSTRING based on non-numeric character in the expression (OTBI Analysis)Summary SUBSTRING based on non-numeric character in the expression for OTBI ReportContent Hi All, I have a requirement in OTBI Report, to get the 20 characters after the…User_2025-02-03-21-08-45-135 363 views 4 comments 0 points Most recent by User_2025-02-03-21-08-45-135 Reporting and Analytics for ERP -
Self Service Reporting -- Home PageSummary Want to explore the option of self service reporting for the business user.Content Hi All, I want to explore the option of self service reporting for the busines…Amarnath Govindu 70 views 2 comments 0 points Most recent by Amarnath Govindu Reporting and Analytics for ERP -
General Legder - Actual vs Budget in OTBI ReportSummary General Legder - Actual vs Budget in OTBI ReportContent Hi Team, We have a requirement to build a report GL, Actual vs Budget in OTBI and display the report in t…User_2025-02-04-11-14-39-386 181 views 2 comments 0 points Most recent by BOF Reporting and Analytics for ERP -
Custom OTBI View Only Role for use across subject areas in ERP CloudSummary Need instructions to create customl OTBI View Only Role for use across subject areas in ERP CloudContent Hi Experts, I've searched and read lots of related docum…User_2025-01-31-01-53-04-402 87 views 1 comment 0 points Most recent by Milind Dalvi Reporting and Analytics for ERP -
Unarchive error message: Error saving security accountSummary Error saving security accountContent When I Try to Unarchive a catalog in BI publisher, I'm getting the error message "Error saving security account" -
How to Calculate MTD and YTD in Oracle BI Analysis ReportsSummary How to Calculate MTD and YTD in Oracle BI Analysis Reports using Project Costing Actual Costs Real Time and Project Control Budgets Real TimeContent Hi, I am try…Avesh Ganodwala-57885 242 views 2 comments 0 points Most recent by Avesh Ganodwala-57885 Reporting and Analytics for ERP -
Add Account Parmeter to Custom BI Puslisher ReportContent Hi Friends, I want to add account form and account to parameters to custom bi publisher report. I tried using add flex field process but unable to create paramet…User_2025-02-03-21-33-20-159 50 views 0 comments 0 points Most recent by User_2025-02-03-21-33-20-159 Reporting and Analytics for ERP -
Procurement - Spend Real Time Field mappingSummary Incorrect field mapping observedContent I have observed that the " Accounting Date" and "Accounting Period" columns in the "Time-Fiscal Calendar" presentation ta…Rohith Thomas 52 views 2 comments 0 points Most recent by User578443-Oracle Reporting and Analytics for ERP -
Spend in functional currency and what is "Invoice measures OBSOLETE"?Summary How to get spend in functional currencyContent I have created a spend analysis based on "Spend Real Time" subject area. Problem is, some of our suppliers invoice…User_2025-01-29-01-07-02-312 47 views 2 comments 0 points Most recent by User_2025-01-29-01-07-02-312 Reporting and Analytics for ERP -
Custom Subject Areas for Cloud ERPSummary Custom subject areas can be created under application composer for CRM, but is this available for ERP?Content Hi, I have been using the Fusion Rel 13 partner env…Daniel Willmott 81 views 1 comment 3 points Most recent by User_2025-01-28-21-08-12-167 Reporting and Analytics for ERP -
Hide Operator (is LIKE (pattern match)) from dashboard promptSummary How to hide operator (is LIKE (pattern match)) appearing on Dashboard PromptContent Hi Experts, I have a requirement in my report to just show the heading and hi… -
Predefined Filters in OTBI Subject AreasSummary Predefined Filters in OTBI Subject AreasContent I have the spreadsheets that document R13 Fusion Financials OTBI subject areas, the corresponding View Objects an… -
OTBI report needed for real-time Assets source linesSummary Has anyone created an OTBI report that provides current asset source lines?Content I work with Fusion Assets and am wondering if there is a standard report or if…User_2025-01-28-20-11-21-100 65 views 1 comment 0 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP -
Need Account inquiry(Fund Availability) details Task or Report in Oracle ERP Cloud R13Summary Need Account inquiry(Fund Availability) details Task or Report in Oracle ERP Cloud R13Content Hello All Is there any Task to search (or) Report in oracle fusion …User_2025-02-03-21-33-20-159 45 views 2 comments 0 points Most recent by User_2025-02-03-21-33-20-159 Reporting and Analytics for ERP -
Tables or views to pick values from manage data access for users functionContent Hello, Is there anyone know any table or view to get values from manage data access for users function? Purpose is to create a custom report and we need to find …User_2025-01-28-21-18-43-496 86 views 8 comments 1 point Most recent by Bala Ch Reporting and Analytics for ERP -
DFF columns in OTBISummary How do we pull DFF (attribute) fields when creating report using OTBIUser_2025-01-30-23-57-59-639 232 views 4 comments 1 point Most recent by UjasB Reporting and Analytics for ERP