OTBI
Discussion List
-
OTBI Analysis - Profile Option ValueSummary Is it possible to access profile option value in OTBI Analysis?Content We are creating a custom profile and setting the values at user level. Is it possible to a… -
EFF in Fusion ERPSummary EFF in Fusion ERPContent Hi All, What are EFF Flexfields in Fusion Financials and how to access them from OTBI subject areas and their tables. ThanksAmarnath Govindu 99 views 7 comments 1 point Most recent by Zlatko Alvir-Oracle Reporting and Analytics for ERP
-
Report Parameters in OTBI ReportsSummary I would like to be able to have the report parameters visible in OTBI reportsContent Hi Folks- Is there a way to have the report parameters included in OTBI repo…User_2025-01-30-21-33-20-426 154 views 7 comments 0 points Most recent by Neal Foley Reporting and Analytics for ERP -
Smartview and OTBISummary Smartview and OTBI not the sameContent When we run Smartview and OTBI reports simultaneously, many times they don’t balance. We are struggling to determine the c…Yasmin Kennedy 144 views 2 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP -
Is there a way to pass parameters to an Infolet?Summary Need to convert a report that passes a parameter into an infolet so I can easily share it with many users that are not familiar with running BI Publisher reports…Fede SD 143 views 9 comments 0 points Most recent by User_2025-01-22-19-56-59-022 Reporting and Analytics for ERP -
Modifying Configurable Expense Report TemplateSummary Access in current user detailsContent Hi,We want to access current logged in user details in configurable expense report template,1. Is it similar to how do it i…Mohak Kirtane 41 views 0 comments 0 points Most recent by Mohak Kirtane Reporting and Analytics for ERP
-
jai_tax_lines_all & jai_tax_types tables in oracle fusionSummary jai_tax_lines_all & jai_tax_types 2 tables which are in r12. Please send relevant tables for these.Content jai_tax_lines_all & jai_tax_types 2 tables which are i…Nageshwaran1 982 views 3 comments 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP -
OTBI Dashboard Prompts are not visible in Google Chrome BrowserSummary OTBI Dashboard Prompts are not visible in Google Chrome BrowserContent Hi All, When we open OTBI dashboards in google chrome ( Version: 80.0.3987.149), the dashb…Siva Kumar-Oracle 42 views 4 comments 0 points Most recent by Siva Kumar-Oracle Reporting and Analytics for ERP -
How to add one day to the PaymentDate in XSL Template?Summary Need to add one day to the PaymentDateContent I am trying to customize XSL Stylesheet (HTML/XML/Text) tempalte, My requirement is add one day to the payment date…OraFusionworld 61 views 0 comments 2 points Most recent by OraFusionworld Reporting and Analytics for ERP
-
Sync COA valuesSummary keep the COA’s in all reporting cubes in syncContent Is there some way to keep the COA’s in all reporting cubes in sync? We have had issued where SMartview does …
-
Limit IT support users to use OTBI within their folder onlySummary Limit IT support users to use OTBI within their folder onlyContent Hi all, is there any way to limit those IT support users to access his/her folder only? Not ab…User_2025-02-04-05-26-22-197 36 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
Open Prepayment OTBI ReportSummary Open Prepayment OTBI Report with Validation status of Available that can be back dated to the prior month.Content I have an Open Prepayment report in OTBI from s…
-
Supplier address withholding tax tableSummary Supplier address withholding tax tableContent Hi, Which view contain the Withholding Tax Exemptions details and how to connect it with POZ_SUPPLIER_ADDRESS_V vie…Shlomo Elnekave 59 views 8 comments 0 points Most recent by Shlomo Elnekave Reporting and Analytics for ERP -
Table "ALL_TABLES" - does not include all tables?Content Hi, When I run a query in BI Publisher Enterprise, I can for example, get results from this query: SELECT DISTINCT UPPER(table_name), num_rowsFROM all_tablesWHER…
-
Misaligned columns and lines in reportSummary When published in Excel, reports lines and columns are misalignedContent Hello everyone, Sorry if this topic was already created before (I didn't find it), but I…User_2025-03-28-01-07-13-341 43 views 8 comments 2 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Adding Project Classification (Class Code) to OTBI report duplicate Costs RowsSummary Adding Project Classification (Class Code) to OTBI report duplicate Costs RowsContent Adding Project Classification (Class Code) to OTBI report duplicate Costs R…User_2025-01-30-23-00-53-497 80 views 2 comments 1 point Most recent by User_2025-02-04-13-08-33-519 Reporting and Analytics for ERP
-
Subledger job inquiry for up to date reportingSummary Subledger job inquiry for up to date reportingContent We are just starting to develop reports in BI/OTBI Oracle Fusion as a newer client. We've previously only m…User_2025-02-04-18-03-15-131 39 views 3 comments 1 point Most recent by User_2025-02-04-18-03-15-131 Reporting and Analytics for ERP
-
Apply customer hierarchy to receivables subject areasSummary We are trying to build reports from the Receivables subject areas that can rollup values based on the CDM Customer HierarchyContent We have established hierarchi…User_2025-01-28-18-21-52-276 52 views 1 comment 0 points Most recent by Veronica Dumitriu Reporting and Analytics for ERP
-
NEW Analytics for ERP - 20ASummary NEW Analytics for ERP - 20AContent Hi, We have now 20A, but Oracle new buit in Analytics for ERP is not available, any idea on ERP analytics. Regards,Farooq Syed, CPA, PMP, CISA 87 views 3 comments 0 points Most recent by Farooq Syed, CPA, PMP, CISA Reporting and Analytics for ERP -
Export FRS reports as *.DES extension fileSummary Export FRS reports in 19D as *.DES extension fileContent Hi, Does anyone know how to export FRS reports as *.DES extension file ? Thnx Version R13 - 19D updatesAli Morsy-Oracle 153 views 1 comment 0 points Most recent by Hamish Vickers Reporting and Analytics for ERP
-
BIP Expense Report ApproverSummary Looking to find the appropriate SQL that will give me the approver name for Expense Reports using BI PublisherContent The goal of this report is to utilize burst…User_2025-02-04-18-47-46-124 95 views 3 comments 2 points Most recent by Andrew_Schmitz Reporting and Analytics for ERP
-
OTBI Action Link not passing parameter when complex logical query is usedSummary OTBI Action Link not passing parameter to another BI Content when complex logical query is usedContent In general, if we create OTBI analysis from a single subje…
-
anyone know how to accomplish that in OTBI?Summary show a report column based on a conditionContent I am using General Ledger - Journal Real time subject area to create a report to show Journal line amount and th… -
Customer Balance ReportSummary Customer Balance Report show me balance for All customerContent Hello i need report show customer,Transaction Type(Invoice,Credit Memo,Debit Memo,Receipt),Debit,…Mahgoub S.Mohamed 120 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Drill down GL to subledgerSummary Drill down GL to subledgerContent Hi all, Is there any standard OTBI reports to drill from GL to subledger like AP and AR? or not possible customize is the work …User_2025-02-04-05-26-22-197 145 views 2 comments 0 points Most recent by User_2025-02-04-05-26-22-197 Reporting and Analytics for ERP
-
Lookup Details from Subject AreaSummary Custom Lookup Details from Subject AreaContent Is it possible to fetch any custom lookup information from any Subject Area? The use case is like below: An analys…
-
Syntax Error While Using Evaluate in OTBI AnalysisSummary Evaluate function generates a syntax error when using REGXP_SUBSTRContent I am attempting to trim the following column in the General Ledger - Journals Real Time…User_2025-02-05-07-37-39-271 46 views 10 comments 2 points Most recent by User_2025-02-05-07-37-39-271 Reporting and Analytics for ERP
-
How do i put in multiple columns in the x axis of a rtf chart?Summary X axis contains values coming from a column and rtf does not allow multiple entries into the x axis label.Sumanth Kunimakki-21932 34 views 0 comments 1 point Most recent by Sumanth Kunimakki-21932 Reporting and Analytics for ERP
-
report accounts payable with cut-off dateSummary A report of accounts payable with cut-off date is requiredContent Does anyone know if in OCF version 19D there is a report of accounts payable with cut-off date …
-
Advanced CollectionsContent Hello All, Do we have any OTBI subject area which gives data related to Collections. Ex: Collector wise collections. Thanks, NishanthNishanth B Jain 120 views 7 comments 0 points Most recent by Veronica Dumitriu Reporting and Analytics for ERP