OTBI
Discussion List
-
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 56 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 42 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 79 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 51 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 138 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 114 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 144 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 45 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 119 views 7 comments 0 points Most recent by Veronica Dumitriu Reporting and Analytics for ERP -
OTBI bar graph formatting for gradient not workingContent I've created a dashboard and saved the supporting analyses and prompts in My Folders. When I copied it to a shared custom folder, no one in my company could view…Mike Burnett 23 views 5 comments 0 points Most recent by Senthilrajan V Reporting and Analytics for ERP -
How to Publish New DashboardContent Hi i have new dashboard in BI and i need to publish after finish and i stuck in below error Destination same as source: /shared/Custom/_portal see in attached Th…Mahgoub S.Mohamed 43 views 1 comment 0 points Most recent by Senthilrajan V Reporting and Analytics for ERP
-
Some users do not have the archive and unarchive optionContent Some users do not have the archive and unarchive option, any ideas? Please share if you know. Thanks.User_2025-02-04-05-26-22-197 45 views 6 comments 1 point Most recent by Karthikeyan Sukumar Reporting and Analytics for ERP
-
Can we invoke a ess job uisng action link on BI DashboardSummary We are creating go to reports dashboard and we need to create a link on a dashboard that invokes account analysis reportContent Is it possible to create action l…
-
Period Name- In OTBI reportSummary Need perod name should populate like DEC-FY-20 (DDDFFYY)Content Hello Team, We want to have the Period name in our OTBI report in the format 'DEC-FY-20', 'SEP-FY…Saurabh Sharma_HCL 176 views 1 comment 0 points Most recent by ndryden Reporting and Analytics for ERP
-
How to display VAT for an expense line/reportContent Hi, Between EXM_EXPENSE_REPORTS and EXM_EXPENSES how do I get to display the VAT paid for an expense line/report? Either through a data model/SQL or with an anal… -
Identify OTBI / BIP reports using a particular columnSummary Identify OTBI / BIP reports using a particular columnContent Hi All, Is there a way to identify OTBI report and BI Publisher reports that are using a particular …User_2025-02-06-00-02-39-946 53 views 5 comments 1 point Most recent by Skolli-Oracle Reporting and Analytics for ERP
-
otbi reports - how do i find out you last modified report?Summary otbi reports - how do i find out you last modified report?Content otbi reports - how do i find out you last modified report? i only see owner and that is person …Angela.Ahrens 216 views 3 comments 2 points Most recent by Skolli-Oracle Reporting and Analytics for ERP
-
Report that tracks receipted PO'sSummary Does anybody have a report that tracks receipted PO's?Content Hi all Just wondering with the accruals of receipted items each month, which reports are being run …Tony Roff 52 views 5 comments 0 points Most recent by User_2025-02-01-08-03-13-309 Reporting and Analytics for ERP