OTBI
Discussion List
-
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…User_OG8I4 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…
-
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…
-
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 84 views 10 comments 5 points Most recent by Veronica Dumitriu Reporting and Analytics for ERP -
Couldn't Integrate a OTBI report including Project details and Project Contract DetailsSummary Can i Create an OTBI Report combining Project Details and Project Contract DetailsContent When i create new OTBI report add in it Projects details from subject a…Mohamed Attia-Allah 49 views 2 comments 0 points Most recent by Mohamed AttiaAllah-Oracle Reporting and Analytics for ERP -
OTBI/BIP Reporting Gap AnalysisSummary Implementing Oracle ERP in all 3 modules ( HCM,SCM & Finance)Content Hi, In the process of implementing Oracle ERP modules, there are many custom reports to be b…Praveen Kumar-156819 92 views 5 comments 0 points Most recent by Shakher Sharma Reporting and Analytics for ERP
-
OTBI RequirementSummary Setting a Flag By Updating Attribute Column in Invoice Header TableContent Hi, We designed a report which send notification for cancelled invoices to vendors sho…AnsumanM 40 views 5 comments 2 points Most recent by Manish Pesswani Reporting and Analytics for ERP -
Deep Link to open Payment info in view mode?Summary Deep Link to open Payment info in view mode?Content Hi, The deep links page in Fusion cloud show the following for the link to the payment https://.oraclecloud.c…Michelle Haynes 424 views 2 comments 0 points Most recent by Manish Pesswani Reporting and Analytics for ERP
-
Does Oracle Fusion Allow a Link to Microsoft Power BI?Summary I'm looking to see if Fusion would allow Microsoft Power BI to link to the Servers In Order to Build ReportsContent My company uses Microsoft Power BI for alot o… -
How to remove EDIT option from User in AnalysisSummary How to remove EDIT option from User in AnalysisContent Hi, How to remove EDIT option from User in Analysis. ThanksFarooq Syed, CPA, PMP, CISA 53 views 2 comments 1 point Most recent by Farooq Syed, CPA, PMP, CISA Reporting and Analytics for ERP -
General Ledger - Journals Real Time Subject Area OTBI Analysis Posting Date shows next daySummary General Ledger - Journals Real Time Subject Area OTBI Analysis Posting Date shows next dayContent Hello All, General Ledger - Journals Real Time Subject Area OTB…Murali Gangidi 59 views 0 comments 1 point Most recent by Murali Gangidi Reporting and Analytics for ERP
-
Print Amount in Arabic in OTBI ReportSummary Print Amount in Arabic in OTBI ReportContent Hi, We have developed a report where every month we sent a balance confirmation letter to customer. This balance cou…Sanin Antony T 26 views 3 comments 0 points Most recent by Sanin Antony T Reporting and Analytics for ERP -
Adding a new Essbase dimension to the OTBI subject area 'General Ledger - Balances Real Time'Summary Adding a new Essbase dimension to the OTBI subject area 'General Ledger - Balances Real Time'Content p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helveti…
-
TODATE Function not working in 'Budgetary Control - Balances Real Time')Summary TODATE Function not working as expected in mentioned SAContent When using the TODATE() Function in Subject Area 'Budgetary Control - Balances Real Time' an error…Walter de Wit 38 views 3 comments 1 point Most recent by Avesh Ganodwala-57885 Reporting and Analytics for ERP
-
OTBI GL Balances with DFFSummary DFF shows in Subject Area but when selected, Balances will not displayContent We have a DFF on the Cost Center Segment. When that DFF is added from the Cost Cent…
-
Expenses - Expense Transactions Real Time Subject Area (OTBI Analysis) didn't result in any dataSummary Expenses - Expense Transactions Real Time Subject Area (OTBI Analysis) didn't result in any dataContent Expenses - Expense Transactions Real Time Subject Area di…Murali Gangidi 123 views 2 comments 0 points Most recent by Ramesh Nayak Reporting and Analytics for ERP
-
Copy Oracle Standard Report as Custom ReportSummary Copy Oracle Standard Report as Custom ReportContent I am new to OTBI in cloud version and have tried to create a very simple OTBI report. However, how to copy ex…
-
OTBI - COA HierarchysSummary Only child level of hierarchy's are visible in OTBI - General Ledger - Balances Real Time Subject AreaContent Hello, I want to use the General Ledger - Balances …
-
Project Period Close Exceptions DashboardSummary Project Period Close Exceptions DashboardContent Project Period Close Exceptions Dashboard - Anybody created as shown in release document. Attached screenshotPrasanna Reka-OC 78 views 2 comments 1 point Most recent by Dasaradh CHenji Reporting and Analytics for ERP -
Translation report for Foreign Currency Translation Reserve (FCTR) reconciliation.Summary Translation report for Foreign Currency Translation Reserve (FCTR) reconciliation.Content Hi, Is there any report in Oracle cloud ERP for Foreign currency transl…Tausif Mulla-139715 66 views 4 comments 0 points Most recent by Tausif Mulla-139715 Reporting and Analytics for ERP
-
OTBI - To Display Sum of a column based on other column in New ColumnSummary OTBI - To Display Sum of a column based on other column in New ColumnContent Hi, I want to Display Sum of a column based on other column in New Column in OTBI An…Murali Gangidi 720 views 8 comments 1 point Most recent by Murali Gangidi Reporting and Analytics for ERP
-
R13.19A OTBI Direct Database Query Privilege ChangeSummary In R13.19A OTBI direct database query has been disabled by default. To prevent reports generating system errors, BI Administrator can modify BI privileges to rev…User720640-Oracle 135 views 6 comments 3 points Most recent by Amarnath Govindu Reporting and Analytics for ERP -
OTBI Calculated Measure sum is incorrectSummary Trying to sum two columns by rowDebbie Herbert 65 views 2 comments 0 points Most recent by Chandra Yerra Reporting and Analytics for ERP
-
BI Publisher Report sporadically fails - database error?Summary Error message: SQL or ORA exceptions caused due to invalid SQL, database package state or some database exceptionsContent The error message "SQL or ORA exception…John Mulvihill 37 views 1 comment 0 points Most recent by Vishnu Singireddy-69744 Reporting and Analytics for ERP
-
SQL to Report on List of User Logins Per DaySummary seeking a listing of unique user loginsContent Can anyone provide SQL, or perhaps just table name, to get a list of unique user logins into Fusion? Thanks, Wendy -
Debtors / Supplier's view at consolidated level (Across Ledgers)Summary Debtors / Supplier's view at consolidated level (Across Ledgers)Content Hi, If I have a "supplier" with whom my organization is trading across BU and across Ledg…Tausif Mulla-139715 21 views 2 comments 0 points Most recent by Tausif Mulla-139715 Reporting and Analytics for ERP
-
Issue seeing requisitioner details in procurement subject areaSummary Financial users are unable to see requisitioner names for purchase ordersContent I am hoping someone can please advise in regards to this issue, we have a report…
-
GST Report for SingaporeSummary Anyone has built GST report for Sinagpore country?Content Anyone has built GST report for Singapore where output is bifurcated as per the tax rate and tax type c…
-
OTBI MobileSummary Documentation for best practice OTBI moblieContent Is there documentation for best practices for OTBI mobile? Should I use Oracle Business Intelligence Mobile or…
-
Filtering Issue on Data ModelSummary The results of the data model are not being filteredContent we are trying to create a simple data model with a variable. But the data is not being filtered as pe…