OTBI
Discussion List
-
Begin/End Balance for Accumulated depreciation of an AssetSummary Begin/End Balance for Accumulated depreciation of an AssetContent Customer asks: We're building a Fixed Asset Balances report out of Subject area Fixed Asset Bal…Z-Man-Oracle 43 views 0 comments 2 points Most recent by Z-Man-Oracle Reporting and Analytics for ERP -
Balance Sheet in OTBISummary Balance Sheet in OTBIContent I have a requirement to build out a balance sheet specifically in OTBI. Some folks have recommended using the subject area for Gener…User_ZZQJ0 142 views 1 comment 2 points Most recent by Skolli-Oracle Reporting and Analytics for ERP
-
Accounts Receivable Reconciliation ReportContent Hello, I am looking to build a reconciliation focusing on the Accounts receivable transactions, I want to show the number of Accounts Receivable transactions tha…Elliot Hall-Walker 45 views 3 comments 0 points Most recent by Elliot Hall-Walker Reporting and Analytics for ERP
-
Fetch Data from Last run dateSummary Only get updates and creates after the previous run of the reportContent This is something I know can be done in hcm extract but I would like to knoe if at all i…Prateek Parasar - GTUK, ACE Pro 460 views 5 comments 0 points Most recent by Prateek Parasar - GTUK, ACE Pro Reporting and Analytics for ERP -
Prompt Variables Not Being PassedSummary Selections from Prompt variables are not passedContent I have a custom Subject Area/data set derived from a logical SQL query joining the existing subject areas,…
-
Logical SQL Error - OTBISummary When attempting to create a new Analysis using simple Logical SQLContent I am attempting to create a new analysis using the logical SQL below; however, whenever …
-
OTBI: Receivables - Transactions Real Time Subject AreaSummary OTBI: Receivables - Transactions Real Time Subject Area don't show collectionsContent I am trying to develop a report on this subject area to show the customer a…M.Adnan.Ansari 92 views 5 comments 0 points Most recent by Veronica Dumitriu Reporting and Analytics for ERP
-
PO and Invoice Amount - OTBISummary Need to show PO and Invoice Amount in a reportContent Hello - I have a requirement to show the Invoice Amount and PO Approved amount in the same report. I can se…Hari Thyagaraj 98 views 6 comments 0 points Most recent by Karthikeyan Sukumar Reporting and Analytics for ERP
-
Convert SYSDATE to Mon-YY format in oracleSummary Convert SYSDATE to Mon-YY format in oracleContent Hi , Can you please suggest how to convert SYSDATE to Mon-YY format. Version 19B
-
OTBI-Parameter-DependentSummary OTBI-Parameter-DependentContent All-> Can we show the parameter values based on another parameter from OTBI? Example: Subject Area: General Ledger - Journals Rea…
-
Who can edit the report?Summary Who can edit the report?Content Can any user edit the OTBI reports or is that something that only the owner of the reports (for example : FASETUP) can edit the r…Mukund Kudrimoti-144443 28 views 5 comments 0 points Most recent by Senthilrajan V Reporting and Analytics for ERP
-
OTBI Project Reporting - ForecastsSummary Unable to locate any measures that relate to past versions of forecasts in OTBIContent Hi, I am in then process of building an in-year expenditure/budget/forecas…StuartHibbert 117 views 1 comment 0 points Most recent by User10772173-Oracle Reporting and Analytics for ERP
-
Manager Email AddressSummary I need to know how to add a field which includes manager's email addressesContent Using the Expense - Expense Transactions Real Time subject area, I need to add …User_2025-02-04-18-47-46-124 56 views 1 comment 3 points Most recent by Aaron Leggett Reporting and Analytics for ERP -
Drill Down Facility in Reporting and AnalyticsContent Drill Down Facility required in Reporting and Analytics. can you please guide me about this task.Baskar.Chakravarthi 47 views 5 comments 0 points Most recent by User_2025-02-01-08-03-13-309 Reporting and Analytics for ERP -
Deep Link for AR Invoice creationSummary Deep Link for AR Invoice creationContent We were going through document 'Drill down from OTBI adhoc reports to Receivables' and there is Deep link for AR invoice…Rakesh Ramesh-Oracle 433 views 5 comments 0 points Most recent by Veronica Dumitriu Reporting and Analytics for ERP
-
How to have dashboard at My dashboard specific to userSummary How to have dashboard at My dashboard specific to userContent Users can be from different departments, we want to have user specific dashboard at My dashboard li…Usman Ul Haq 193 views 4 comments 1 point Most recent by Hannah Dorman Reporting and Analytics for ERP
-
OTBI Create Analysis with columns for different account balancesSummary Making Account a Column with Account ValueContent Hello, Is it possible to create this type of report in OTBI (I'm not having any luck)? Balancing Segment accoun…Stephen Bryant-131052 49 views 2 comments 1 point Most recent by Stephen Bryant-131052 Reporting and Analytics for ERP -
Fusion Cloud AnalyticsSummary Fusion Cloud AnalyticsContent Hi -> Any one please let me know details about Oracle Cloud Analytics? Thanks,
-
Missing FolderSummary i missing custome folderContent Please help me to found my custom folder under share folder in custom ThanksMahgoub S.Mohamed 47 views 4 comments 1 point Most recent by Tom Strudley Reporting and Analytics for ERP -
Permissions or custom roles to view only OTBI or BIP reportsSummary I need to enable a SCM roles users to just display custom financial reports which created by using BI publisher or OTBI.Content I need to enable a SCM roles user…Mohamed Mahmoud-157904 84 views 9 comments 0 points Most recent by Tom Strudley Reporting and Analytics for ERP
-
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
-
Key Flexfields and Descriptive Flexfields Supported in OTBI FinancialsSummary The purpose of this White Paper is to help clarify the Key Flexfields and Descriptive Flexfields supported in OTBI Financials and the subject areas in which they…Veronica Dumitriu 158 views 10 comments 9 points Most recent by Sudha KOVURU Reporting and Analytics for ERP -
OAC drill into ERP transactionsSummary Drill ability from OAC dashboard into ERP transactionsContent Hello - I created a Invoice report in OAC cloud with Payables Transactions subject area. Is there a…Hari Thyagaraj 56 views 0 comments 1 point Most recent by Hari Thyagaraj 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
-
Unable to use 2 Subject Areas in the OTBI reportSummary OTBI error while using Payables Payments - Disbursements Real Time and Payables Invoices - Transactions Real TimeContent Team, We have created an OTBI report usi…Sathyaseelan Chandran 90 views 7 comments 1 point Most recent by Sathyaseelan Chandran Reporting and Analytics for ERP
-
MOAC in BIP ReportsSummary Implementing MOAC in BIP ReportsContent Hello,Trying to implement security based on the role assigned to a user. Following below note, however, have not been abl…
-
Invoice Line Level Account Combination (Distribution) ReportSummary Invoice Line Level Account Combination (Distribution) ReportContent Can someone tell me what Subject Area and specific Subject in Reports and Analytics should be…racheltx 109 views 4 comments 1 point Most recent by Sridhar Tumati-55392 Reporting and Analytics for ERP
-
OTBI Custom Report Scheduling -- Date Parameter IncrementSummary How to increment date parameter to run with sysdate for Scheduled OTBI reportContent OTBI Custom Report has PO Date which is a parameter with in between operator…User_2025-01-28-17-34-41-546 539 views 1 comment 1 point Most recent by Ramesh Nayak Reporting and Analytics for ERP
-
How to add OTBI report parameter to filter out those zero outstanding balance and date in range?Summary Add report parameters to filter those zero outstanidng balance and date in rangeContent hi all, I have two OTBI report parameters would like to add: 1) In the Su…User_2025-02-04-05-26-22-197 97 views 3 comments 3 points Most recent by Senthilrajan V Reporting and Analytics for ERP
-
Drill Down using Invoice NumberContent Hi, I have created analytical report which has Ledger Name, Supplier Name and Invoice Number When the invoice number is clicked i would like to drill down to tra…Mohammed Rafi 86 views 10 comments 6 points Most recent by Veronica Dumitriu Reporting and Analytics for ERP