OBI Answers
Discussion List
-
ERP - LAG / AGING reportSummary I need to create a LAG / Aging report and was hoping there's a report I could use as a starter.Content Not sure how the forums work as it's my first time here. A… -
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…
-
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 …
-
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…
-
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…
-
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
-
How to hide the VIEW IMAGE Button in AR invoice screen in FusionSummary How to hide the VIEW IMAGE Button in AR invoice screen in FusionContent Hi Team, Is there a possibility to hide the VIEW IMAGE Button in AR invoice screen in Fus…User_1B10X 129 views 6 comments 1 point Most recent by Nishanth B Jain 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 71 views 2 comments 0 points Most recent by Amarnath Govindu 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 241 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…
-
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 Tiger Liu-55147 Reporting and Analytics for ERP
-
Difference Between using /analytics and /xmlpserver?Summary What are the major differences in using OBIEE and BI Publisher?Content Had an issue recently wherein a folder was hidden and it was preventing me from customizin…Juan Miguel Isip-94819 334 views 5 comments 0 points Most recent by Amarnath Govindu 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…
-
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_II3DX 66 views 1 comment 0 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP
-
Wrong result for 'nls_calendar=''arabic hijrah''' conversionContent Hi , I have a problem when converting the sysdate with the use of 'nls_calendar=''arabic hijrah''' parameter as it returns difference in two days with the 'nls_c…
-
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 …
-
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 …Ayesha Thilakarathna-51043 84 views 8 comments 1 point Most recent by Bala Ch Reporting and Analytics for ERP -
R13 Financials OTBI subject area description documentationSummary R13 Financials OTBI subject area description documentationContent This documentation is published by Oracle OTBI development. This document provides users a func…User720640-Oracle 503 views 4 comments 8 points Most recent by Chris Lloyd-75810 Reporting and Analytics for ERP -
Need Outstanding Purchase Order Details Report in oracle fusion R13Summary Need Outstanding Purchase Order Details Report in oracle fusion R13Content Hello All Is there any report in oracle fusion r13 to display outstanding purchase ord…
-
PO Encumbrance Journal DetailsSummary PO Encumbrance Journal DetailsContent Hello All I need script to extract PO encumbrance and related journal line details in oracle fusion. Required Columns in qu…
-
Seeking Assistance Querying for Basic Transactional MetricsSummary How to get counts of journal lines, invoices, and payments per month?Content I'm hoping someone can give me a head start on how to query for the following transa… -
New OTBI Help Landing PageSummary Introducing a brand-new OTBI Help Landing PageContent This e-mail is sent by Oracle OTBI product management. Starting with Release 13.18.10, a brand-new OTBI Hel…User720640-Oracle 75 views 0 comments 6 points Most recent by User720640-Oracle Reporting and Analytics for ERP
-
Restrict Data in OTBI Based on Specific RoleSummary Is it possible to create role based restrictions on data within OTBI?Content In Cloud ERP, I can create data access sets and value set security rules and assign …Daniel Willmott 212 views 1 comment 1 point Most recent by Evan Danek-66892 Reporting and Analytics for ERP
-
Image is blown up when Report is shown via EmailSummary We modified a Layout to add our Organization Logo, however, when its delivered via Email, the image blows up and is too bigContent Hi, we're trying to modify our…Juan Miguel Isip-94819 53 views 1 comment 0 points Most recent by Juan Miguel Isip-94819 Reporting and Analytics for ERP
-
Column aggregates without showing measure columnsSummary Column aggregates without showing measure columnsContent Hi All, I have built a report with multiple measures. Is it possible to show only the column level aggre…Ishan B-112616 43 views 0 comments 0 points Most recent by Ishan B-112616 Reporting and Analytics for ERP
-
How to filter between Accounting Period Name in GL dashboard promptSummary How to filter between "Accounting Period Name" in GL dashboard promptContent Hi, I need to use "Accounting Period Name" in "General Ledger - Journals Real Time" … -
R11 ERP OTBI Subject Area Mapping to Fusion Database TablesSummary Release 11 ERP OTBI subject area database table mapping spreadsheetContent This spreadsheet is published by Oracle OTBI Development. This spreadsheet documents F…User720640-Oracle 462 views 14 comments 9 points Most recent by Koteswararao Yenikepalli Reporting and Analytics for ERP
-
Reports Generated from Schedule Processes to be mapped to spring boardSummary Reports Generated from Schedule Processes to be mapped to spring board e.g. GL Accounts AnalysisContent Hi All, Is there a possibility to map reports generated v…Achala Munasinghe 61 views 3 comments 0 points Most recent by User_AEMC1 Reporting and Analytics for ERP -
Default "Account Period Name" value in OTBI Prompt while scheduling AgentsSummary Is there a way to default Period name on the OTBI Prompt while scheduling the Analysis from Agents?Content We have an OTBIE analysis "AP Transaction Report" that…GopiKAutomus 274 views 5 comments 0 points Most recent by User_AEMC1 Reporting and Analytics for ERP