OBIEE Answers
Discussion List
-
OTBI HOW TO TURN MEASURE COLUMN INTO YTDSummary OTBI HOW TO TURN MEASURE COLUMN INTO YTDContent Hi Xavier, As per the below the YTD amount gets calculated from 1/Jan to till date. However we have requirment to…Avesh Ganodwala-57885 205 views 0 comments 0 points Most recent by Avesh Ganodwala-57885 Reporting and Analytics for ERP -
Invoice Approval and Notification InformationSummary Cannot find the table name for Invoice Approval and Notification InformationContent We want to extract details of Invoice Approval and Notification Information b…User_2025-01-22-19-25-44-650 64 views 3 comments 0 points Most recent by User_2025-02-05-11-38-57-253 Reporting and Analytics for ERP -
OTBI/BIP Reporting Gap AnalysisSummary Implementing Oracle ERP in all 3 modules ( HCM,SCM & Finance)Content Hi, In the process of implementing Oracle ERP modules, there are many custom reports to be b…User_2025-02-05-04-43-06-903 93 views 5 comments 0 points Most recent by Shakher Sharma Reporting and Analytics for ERP
-
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 524 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 61 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…User_2025-01-30-21-01-20-715 71 views 14 comments 2 points Most recent by User_2025-02-03-21-40-10-404 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…User_2025-01-30-20-23-15-920 814 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…User_2025-02-04-05-26-22-197 95 views 4 comments 0 points Most recent by Chandra Yerra Reporting and Analytics for ERP
-
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 24 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 135 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…User_2025-02-01-06-21-55-603 34 views 1 comment 0 points Most recent by User_2025-01-30-01-18-25-142 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…Manish Gianani 53 views 1 comment 2 points Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP
-
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…Aaron Leggett 60 views 2 comments 1 point Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP -
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…User_2025-01-28-20-26-08-493 50 views 1 comment 1 point Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP
-
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…Rohan Lobo-Oracle 137 views 3 comments 1 point Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP
-
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…Rohan Lobo-Oracle 54 views 1 comment 1 point Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP
-
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…User_2025-01-28-07-58-18-982 100 views 7 comments 1 point Most recent by Jairo Rojas Méndez 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…User_5F4G3 52 views 2 comments 1 point Most recent by Jairo Rojas Méndez Reporting and Analytics for ERP
-
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 135 views 3 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
-
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 404 views 3 comments 1 point Most recent by Jairo Rojas Méndez 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
-
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
-
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 128 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