OBIEE Answers
Discussion List
-
Deep Link to open Payment info in view mode?Summary Deep Link to open Payment info in view mode?Content Hi, The deep links page in Fusion cloud show the following for the link to the payment https://.oraclecloud.c…Michelle Haynes 436 views 2 comments 0 points Most recent by Manish Pesswani Reporting and Analytics for ERP -
Does Oracle Fusion Allow a Link to Microsoft Power BI?Summary I'm looking to see if Fusion would allow Microsoft Power BI to link to the Servers In Order to Build ReportsContent My company uses Microsoft Power BI for alot o… -
BIP Report ParametersSummary BIP Report ParametersContent Hi -> BIP Report Parameters: Can we make BIP report parameters in the required order if there are more parameters. Ex: I have 20 par…Amarnath Govindu 62 views 3 comments 0 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP
-
CSV output Date FormatSummary CSV output Date FormatContent Hello all, I have created one Report using new data model (OBIEE data source) and an Subject Area Analysis based query. I have crea…Animesh Agrawal-79521 71 views 14 comments 2 points Most recent by Kamrul Alom Reporting and Analytics for ERP
-
Print Amount in Arabic in OTBI ReportSummary Print Amount in Arabic in OTBI ReportContent Hi, We have developed a report where every month we sent a balance confirmation letter to customer. This balance cou…Sanin Antony T 26 views 3 comments 0 points Most recent by Sanin Antony T Reporting and Analytics for ERP -
SQL Link between GL and ProjectsSummary Report which shows project transaction that have flown through to GLContent Hi Does anyone know the links/joins between GL and Projects, we are trying to build a…Kunal Daya-76859 642 views 4 comments 0 points Most recent by Michelle Haynes Reporting and Analytics for ERP
-
Copy Oracle Standard Report as Custom ReportSummary Copy Oracle Standard Report as Custom ReportContent I am new to OTBI in cloud version and have tried to create a very simple OTBI report. However, how to copy ex…
-
Is it possible to repete LOV(Data validation)to each row in BI Excel template outputSummary In the excel template row grouping we have created LOV for a single column, while generating excel reports and LOV applied to first row only, I need to repeat LO…Kalieswaran S-Oracle 22 views 0 comments 0 points Most recent by Kalieswaran S-Oracle Reporting and Analytics for ERP
-
R13.19A OTBI Direct Database Query Privilege ChangeSummary In R13.19A OTBI direct database query has been disabled by default. To prevent reports generating system errors, BI Administrator can modify BI privileges to rev…User720640-Oracle 134 views 6 comments 3 points Most recent by Amarnath Govindu Reporting and Analytics for ERP -
OTBI Calculated Measure sum is incorrectSummary Trying to sum two columns by rowDebbie Herbert 65 views 2 comments 0 points Most recent by Chandra Yerra Reporting and Analytics for ERP
-
BI Publisher Report sporadically fails - database error?Summary Error message: SQL or ORA exceptions caused due to invalid SQL, database package state or some database exceptionsContent The error message "SQL or ORA exception…John Mulvihill 34 views 1 comment 0 points Most recent by Vishnu Singireddy-69744 Reporting and Analytics for ERP
-
SQL to Report on List of User Logins Per DaySummary seeking a listing of unique user loginsContent Can anyone provide SQL, or perhaps just table name, to get a list of unique user logins into Fusion? Thanks, Wendy -
GST Report for SingaporeSummary Anyone has built GST report for Sinagpore country?Content Anyone has built GST report for Singapore where output is bifurcated as per the tax rate and tax type c…
-
How to extract Registration Number on OTBI?Content Hi I've used the mapping tables for R11 but cannot seem to find the 'Registration Number' under Registration Details (For Suppliers). What I do get back is 'Firs… -
eText Header RecordSummary I need to create a header record in an fixed position eText Template.Content I need to create a header record in an fixed position eText Template. Which contains…
-
Project Portfolio Management Cloud OTBI Release 12: 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…
-
Project Portfolio Management 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…
-
OTBI - Combining gl segments values with Suject areasSummary Problems whenusing the Real Time Subject Areas combining with the tree hierarchy for GL ValuesContent My customer is trying to build an OTBI report using the Rea…Angel Espadafor-47436 99 views 7 comments 1 point Most recent by Jairo Reporting and Analytics for ERP
-
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
-
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…Murali Gangidi 50 views 0 comments 2 points Most recent by Murali Gangidi 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 127 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 70 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 240 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…