OBIEE Answers
Discussion List
-
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…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 -
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…User_2025-01-31-18-04-59-292 410 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…
-
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 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 User_2025-01-30-04-35-21-746 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…User_2025-02-03-21-33-20-159 693 views 2 comments 1 point Most recent by User_2025-02-03-21-33-20-159 Reporting and Analytics for ERP
-
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…User_2025-02-03-21-33-20-159 43 views 0 comments 0 points Most recent by User_2025-02-03-21-33-20-159 Reporting and Analytics for ERP
-
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 222 views 1 comment 1 point Most recent by User_2025-01-29-23-00-32-611 Reporting and Analytics for ERP
-
Transaction time in the report and in Payables Application are differentSummary Transaction time in the report and in Payables Application are differentContent Hi all, Developed a report using Payables -transactions real time subject area.In…Dev Thota 56 views 4 comments 0 points Most recent by Manish Pesswani Reporting and Analytics for ERP -
user role security context security context value reportSummary user role security context security context value reportContent Is there a report where we can retrieve all values as shown in screen shot below?User_2025-01-28-19-49-26-512 249 views 1 comment 1 point Most recent by User_2025-01-30-20-43-00-868 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 60 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 320 views 5 comments 0 points Most recent by User_AEMC1 Reporting and Analytics for ERP -
Custom Data Model - Remittance Advice - Change From Check to Wire Payments?Summary Custom report using SQL data model - How to change from check payments to wire payments?Content We have a custom report for AMEX remittance advice which gives us…
-
What table joins required to link PO Receipts to GL lines in Data Model?Summary Need to Extract GL lines with PO Receipt details, PO Number with Data ModelContent Hello, We are trying to create a custom GL Report that will show subledger det…user6675104 319 views 2 comments 0 points Most recent by Zlatko Alvir-Oracle Reporting and Analytics for ERP
-
Preparing a custom fixed asset reportSummary Custom report designContent Hi, I would like to create a custom fixed asset report.What data model should I select or create or how can I do that ?(BI Publisher,…Armagan Sahin-57534 189 views 1 comment 0 points Most recent by Jennifer Sherbrook - CNL Reporting and Analytics for ERP
-
I Cant find the Flexfield AR_CASH_RECEIPTS in OTBIContent Hi All, I did add Descriptive Flexfield to account receivable - Receipt Screen - under Additional Information ( global segment - Descriptive Flexfield name ( AR_…User_2025-01-29-22-38-36-974 80 views 3 comments 0 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP
-
How to do an average days to approve formula?Content Hi all, I am trying to do an average days formula from a requisition submission date and when it was approved, and then put another column in with the month it w…User_2025-01-29-02-09-34-137 82 views 1 comment 0 points Most recent by Aaron Leggett Reporting and Analytics for ERP
-
After R12 upgrade BIP and OTBI reports are not defaulted to custom Inquiry roleSummary After R12 upgrade BIP and OTBI reports are not defaulted to custom Inquiry roleContent After R12 upgrade BIP and OTBI reports are not defaulted to custom Inquiry… -
R13 Risk Management OTBI subject area Description documentationSummary R13 Risk Management OTBI subject area Description documentationContent This documentation is published by Oracle OTBI development. This document provides users a…User720640-Oracle 88 views 1 comment 5 points Most recent by Youssouf Reporting and Analytics for ERP
-
Data mapping for Oracle Business Intelligence Cloud Connector ConsoleSummary Mapping details for file extracts offerings from 'Oracle Business Intelligence Cloud Connector Console' and BI Apps Tables.Content We get 'Oracle Business Intell…Senthilrajan V 157 views 1 comment 0 points Most recent by Rohan Lobo-Oracle Reporting and Analytics for ERP -
Uk compliant VAT report in r12Content All,We are trying to find a uk compliant report or processes/white paper that we can use to run our vat returns from, are you please able to point me in the righ…User_2025-01-29-02-09-34-137 39 views 1 comment 0 points Most recent by Veronica Dumitriu Reporting and Analytics for ERP