OTBI
Discussion List
-
OTBI including an header sectionSummary: We have defined an OTBI that exports lines with the images uploaded in the Fusion Product Hub module (SCM). Can be possible to include before the table section …adelsorbo-Oracle 41 views 5 comments 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
21D known issues - Just a thread to note down any issues ppl with this release have facedSummary: Opening this thread to note down issues with 21D. Currently we have this release in our lower environment and are testing - so I thought to have a thread that c…Dhruvjoshi23 11 views 3 comments 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
Procurement > Dashboards > Procure-to-Pay no 'Period' list of valuesSummary There is no value in the list of values for 'Period'Content Hi, I'm trying to open the seeded dashboard Procurement > Dashboards > Procure-to-Pay But with any us… -
Using BICC PVO in data model for BI publisher reportingSummary: is there way to configure data model to use BICC PVO? we need some custom reporting built and would like to leverage BICC PVO in data model Content (required): …Roman Havrylyak 43 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Do BICC and OTBI have access to the same data?Summary Wondering if there any differences in what data can be accessed via BICC vs OTBIContent Am wondering if there any differences in what data can be accessed via BI…Jeff Hare CPA CISA CIA 76 views 3 comments 3 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Analysis Report Prompt is not appearing when running from the InvoicesSummary: Prompt added to the analysis report is not appearing when running it using invoice window. Content (required): Hi, I have created a OTBI analysis report (Not fo…Miyuru Guruge 11 views 2 comments 0 points Most recent by Miyuru Guruge Reporting and Analytics for ERP
-
Subject Area Security - Unable to view data from relative subject area despite having role assignedSummary: Subject Area Security - Unable to view data from relative subject area despite having role assigned Content (required): I am currently attempting to troubleshoo…User_2025-02-11-21-40-21-159 253 views 3 comments 0 points Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP -
No data in balances when using Natural Account SegmentSummary: When working with Subject Area General Ledger - Balances Real Time I cannot see any data in balances: Beginning Balance, Period Net Activity and Ending Balance …JJ_DTU 12 views 2 comments 0 points Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP
-
Is there any OTBI subject area where "associated collaboration documents fields" can be found?Summary: Fields details: Navigation: Supplier > Sites > General > Associated Collaboration Documents Service Provider Trading Partner ID Partner ID Type Document Associa…Atul Aloke 31 views 1 comment 0 points Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP -
Manager Proficiency result for Competency Assessment ReportSummary i cant find the competency assessment column that shows assessment resultContent I wanted to compare target competency assessment and manager competency assessme…Michael Nega Gebrehawariyat 24 views 1 comment 0 points Most recent by User_2025-02-10-15-51-50-906 Reporting and Analytics for ERP -
Newly created Financial Categories do not show in BI report list of valuesContent I'm looking to pull in 3 new Financial Categories into a BI report I created. I've created the lookup codes under GL and attached the categories to the account s…User_2025-02-05-22-11-22-331 135 views 16 comments 1 point Most recent by Sourabh Choudhury Reporting and Analytics for ERP
-
OTBI Cost Centre lists all parent valuesSummary Cost Centre in OTBI returns all parent values as well as the lowest levelContent Hi all, Hoping someone could point me in the right direction. I am attempting to…StuartHibbert 220 views 2 comments 0 points Most recent by Anders W. Langholm Reporting and Analytics for ERP
-
Analytic needs to work with Prompt in DashboardSummary Analytic needs to work with Prompt in DashboardContent Hi, I have a Dashboard include one analytic and one prompt. When i open the dashboard, analytic is searchi…User_2025-02-05-02-38-04-251 45 views 4 comments 2 points Most recent by A.JOSH Reporting and Analytics for ERP
-
How to show Payment Amount by Fiscal Period?Summary: I have a requirement to write an OTIB report to show total payments by fiscal period and supplier. Content (required): I've created the report using the Payable…Marlowe Matoba 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
All assets that have been created in projects but have not been capitalized yetSummary All assets that have been created in projects but have not been capitalized yetContent I need to create a report in Project Costing - Assets Real Time subject ar…Andrew_Schmitz 25 views 3 comments 0 points Most recent by Anders W. Langholm Reporting and Analytics for ERP -
Error Receive when View ReportSummary: Error Receive when View Report Content (required): User receive the error message below when generating dashboard Version (include the version you are using, if…CraigX 11 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
Expense Report - all expenses by cost centerSummary: Content (required): We have an analysis created using Expense - Expense Transactions Real Time. When a user runs the report, they get their own expenses. When a… -
Invoice Not reflecting in OTBISummary: Invoice Not reflecting in OTBI Content (required): Invoices created are not reflecting in OTBI Payables Transaction Real Time. Is there a time limit that the in…CraigX 121 views 1 comment 0 points Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP
-
Report Using Procure to Pay Subject AreaSummary A new subject area called “Procure to Pay Real Time” has been added to Procurement’s Oracle Transactional Business Intelligence or OTBI. You can use this subject…Manavalan Ethirajan 967 views 13 comments 14 points Most recent by Surajit Roy-Oracle Reporting and Analytics for ERP
-
Procurement - Pending Change Orders Subject area does not correctly reportSummary The Change Order Creation Date is actually the PO Creation DateContent Has anyone else noticed that the "Change Order Creation Date" - a vital field in this subj… -
How to Handle Null or Not Present tags in xml file in BI Publisher?Content Hi all, I have an issue where I'm stuck at making an XML condition for a check print. I used this SQL query for the same condition, and now I want it to be imple…Sushan Peiris 1.1K views 4 comments 3 points Most recent by Sushan Peiris Reporting and Analytics for ERP -
Need a query to get ending balances for current cost,impairment,depreciation for fixed assets for aContent Hi all, Can someone provide me with a query to get ending balances for current cost, impairment, depreciation for fixed assets category wise for a specific perio…Sushan Peiris 159 views 7 comments 3 points Most recent by Sushan Peiris Reporting and Analytics for ERP
-
Why there is a delay in data loading for BI reports in fusion?Content Hi all,I found that some of the customs made BI reports in the fusion by me, has a delay in displaying data when a transaction or any change is done in the syste…Sushan Peiris 341 views 3 comments 2 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
Receivables - Customers Real Time subject area access issueSummary Results errors when adding multiple fields to analysisContent I created a Customer Detail Dashboard using one analysis and one prompt. It was built from the Rece…Mike Burnett 43 views 10 comments 1 point Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
How to access the New DashboardSummary How to access the New DashboardContent I have seen this post online but not sure is this Oracle Fusion OTBI Dashboard or need separate license or product. Please… -
Contracts Deliverables ReportContent Hello, Does anyone have a Contracts Deliverables Report that they can share? When I am building a report using OTBI Subject Area - I am getting many different st…Troy Collard 8 views 0 comments 0 points Most recent by Troy Collard Reporting and Analytics for ERP
-
Include 'Comments' from Contract Risks into Subject Area "Enterprise Contracts - Contracts Real TimeContent Hello, I am wanting to include a field called 'Comments' from Contract Risks into an OTBI report that uses the Subject Area "Enterprise Contracts - Contracts Rea…Troy Collard 3 views 0 comments 0 points Most recent by Troy Collard Reporting and Analytics for ERP
-
Vendor name not available at source lines for assets in FAContent Hi all, I face an issue where I don't get the vendor name for the table FA_ASSET_INVOICES where I take invoice no, PO no for source lines of an asset. When I add…Sushan Peiris 38 views 3 comments 2 points Most recent by Sushan Peiris Reporting and Analytics for ERP
-
Reports Failing after upgrade to 20BSummary Reports Failing after upgrade to 20BContent Does anyone experiencing these issues after the upgrade over the weekend? 1. Reports parameters are blank not display…
-
OTBI AP Report including approversSummary Can I access a field containing approvers in an OTBI Payables transaction report?Content We have a report that returns all payables transactions for the prompted…User_2025-02-11-03-09-13-126 26 views 2 comments 1 point Most recent by User_2025-02-11-03-09-13-126 Reporting and Analytics for ERP