OTBI
Discussion List
-
Custom BI Publisher Report SQL ErrorSummary SQL or ORA exceptions error.Content Hello, We are receiving the following error when running a custom built BI Publisher report. This report was functioning with…User_2025-02-05-07-37-39-271 87 views 14 comments 0 points Most recent by Tom Strudley Reporting and Analytics for ERP -
Subject Area in OTBI to extract default Expense Account information of userSummary Subject Area in OTBI to extract default Expense Account information of userContent Hi, I am trying to build a OTBI report which has cost center and company infor…Nidhi Chhajed 205 views 3 comments 0 points Most recent by Meshack Rakumakoe Reporting and Analytics for ERP -
Cannot see HZ_GEOGRAPHY_IDENTIFIERS_VL view with Custom Geography Type in Data ModelSummary Cannot see HZ_GEOGRAPHY_IDENTIFIERS_VL view with Custom Geography Type in Data ModelContent Hi I have LACLS Colombia reports into Oracle ERP Cloud. However, they…User_2025-01-30-22-31-23-162 42 views 1 comment 0 points Most recent by User_2025-01-30-22-31-23-162 Reporting and Analytics for ERP
-
How to set/enable the menu "Reports and Analytics" regardless of responsibilitySummary We’ve created the BI reports to General Ledger but is not possible see the “Reports and Analytics” option on the responsibility menu area, is possible enable thi… -
How to avoid special characters from rtfContent How to avoid new line feed coming as special symbols from rtf template.? Ex.. text entered to item description from application is like line 1. press Enter Line…
-
Drill Down from OTBI Subledger Accounting Reports to Subledger Journal Entry DetailsSummary Drill Down from OTBI Subledger Accounting Reports to Subledger Journal Entry DetailsContent Hi all, This is 19c new function, "Drill Down from OTBI Subledger Acc…User_2025-02-04-05-26-22-197 77 views 2 comments 0 points Most recent by User_2025-02-04-05-26-22-197 Reporting and Analytics for ERP
-
Custom Style in OTBISummary How to change graphs color, stlying in OTBIContent Hello - Is there a way to change or add custom style/color to a graph or chart within OTBI analysis and dashbo…Hari Thyagaraj 77 views 5 comments 0 points Most recent by Tom Strudley Reporting and Analytics for ERP
-
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 155 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 43 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 466 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 97 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 27 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 46 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 480 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 191 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 48 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 46 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 82 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 225 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 55 views 0 comments 1 point Most recent by Hari Thyagaraj Reporting and Analytics for ERP