To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for ERP
Discussion List
-
OTBI Reporting for Project Portfolio Management (PPM) Cloud - Tips and TechniquesSummary The white paper addresses frequently asked questions in OTBI reporting for Project Portfolio Management (PPM) Cloud. It also includes tips to enhance report perf… -
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 …
-
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…
-
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…
-
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 … -
Supplier Tax informationSummary Find the supplier tax data on the OBIContent hi i need to create reports on supplier tax information like tax registration and taxpayer d. i do not found them on… -
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…
-
Need Report or script to get an item cost in oracle cloud r13Content Hi All, In EBS to get an item cost i used below query, but i am unable to see any data in cst_item_costs_v in oracle cloud r13. select item_cost from cst_item_co…
-
Payables to Ledger Reconciliation ReportSummary Difference in Prepayments Detail and Prepayment Accounting Detail amountContent Hello In Payables to Ledger Reconciliation Report, we are having a difference in … -
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…
-
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…
-
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.0
-
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 …
-
BI Publisher Reports - Default Email AddressSummary I would like to change the Current default email address which currently is bipublisher-report@oracle.comContent When running BI Publisher reports and selecting … -
Create a report by Standard Memo LineSummary Is there a report by Standard Memo Line?Content I am looking for a report with Revenue of a chosen Standard Memo Line for all customers (by customer would be bes… -
Translation - MIssing CompaniesSummary EUR Ledger with 5 Companies, Only One Company TranslatesContent Background - We have an EUR Ledger, Functional or reporting currency is EUR. We translate all led…
-
Oracle - SmartView How to Unpublish or Hide a Budget Scenario - Not Delete?Summary Oracle - SmartView - I need to Unpublish or Hide a Budget Scenario - Not Delete a Budget ScenarContent Hello, In Oracle - SmartView, I am trying to Unpublish or …
-
OTBI: Project Cost - Inception to DateSummary Project ITDContent Good People, How to get project inception to date cost ? Thanks, Soumya -
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…
-
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 … -
Payable to Ledger Reconciliation Summary - Account is outside of report rangeSummary Account is outside of report rangeContent We're trying to close our AP for December and ran into this error for the first time in our reconcilation process- "Acc…
-
Role needed for this subject area Cash Management - Bank Statements Real Time for OTBI AnalysisSummary Role needed for this subject area Cash Management - Bank Statements Real Time for OTBI AnalysisContent Hi All, I have this subject area 'Cash Management - Bank S…
-
Account Analysis Report mismatchSummary Account Analysis Report mismatchContent Hi Team Need suggestion to reconcile TB with Account Analysis . We are facing an issue where the Account analysis report … -
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…
-
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…
-
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…
-
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…
-
Creating Financial Reports with Rolls-Ups that Depend on More than One Value Set SegmentSummary Is it possible to create financial statement reports through Smart View or Financial Reporting Studio that have subtotals depending on more than one chart of acc…