OTBI
Discussion List
-
Missing Fields in SaaS Table ZMM_NOTES Data Sources.Hi All, As Per Oracle Documentation We are able to see the NOTE_TXT field for the Data Source FscmTopModelAM.NoteAM.ExpenseReportHistoryNotePVO but not able to see the s… -
Need to create a BI report for AP Invoice Account Coding Status,Coder Name,Comments,Completion DateSummary: We have requirement to create BI report to give invoice level information along with the account coding status, coder name, coder comments and its completion da…Chowdari Malapati Monika 118 views 1 comment 0 points Most recent by Janaki Ankam-Oracle Payables, Payments & Cash Management
-
Transactions Available for Reconciliation Report changing mandatory parameters BankAccount IDSummary: We want to run the report Transactions available for Reconciliation in Cloud but unable to see it when going to Scheduled processes >Submit process. Therefore, …Jessica L. 99 views 3 comments 0 points Most recent by Jennifer-Leung Reporting and Analytics for ERP -
BPM Notification audit informationHi Team We have a requirement to get the audit log for BPM notifications. If anybody worked on similar requirement, please share the solution/document. Thanks Umang SainiSaini 21 views 3 comments 0 points Most recent by Parag Hiremath Payables, Payments & Cash Management
-
How to restrict an OTBI analysis by data access added to a user?Summary: There is a an analysis created which has supplier information based on Business units. A user with access to only one business unit is able to see suppliers fro…
-
Table for BPM - specifically CONFIGURATIONSContent We are looking for tables to be able to look at the workflow rule configuration. For example, we want to be able to create a report that will tell us things like… -
Subject Area to get real time ESS Job details for OTBI Analysis dashoboardHi, We have a requirement to create an ESS Job monitoring dashboard to show summary of ESS Jobs by status and few detail drill down reports. Is there any subject area wh…Ankit_Bhadja 61 views 1 comment 1 point Most recent by Wendy Horowitz-Oracle Fusion Applications Administration -
Associating the reconciliation history table with system transactionsIn the CE_RECON_HISTORY_ITEMS table stores the bank statements reconcile record. The field RECON_SOURCE shows where the matching item comes from. And I believe field SOU…July_Yanlin 13 views 1 comment 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management
-
BI report to extract GL Daily Rates table data for a range of corporate ratesSummary: Is there a report that can be schedules to export the GL Daily Rates table data out of Oracle Fusion? Content (please ensure you mask any confidential informati…
-
Is there any Standar report or functionality to fetch user details who logging via fusion mobile appSummary: Is there any Standard report or functionality to fetch user details who logging via fusion mobile app or table store the mode of login details (Example Mobile a…Vinuth1 21 views 2 comments 0 points Most recent by Kishore Padala-Support-Oracle Applications Security -
Procurement ReportingSummary: Our organisation needs to provide reports from the system such as below and I'm wondering if anyone has created any reports or knows of any seeded reports that …Stuart 1 view 1 comment 0 points Most recent by Shivam Chauhan-Oracle Payables, Payments & Cash Management
-
View Expense report receipts for approversSummary: Has anyone created a report or option to view (without download) Expense report receipts for approvers? Currently only option for approvers is through Expense r… -
What is the best way to prepare a consolidated Trial Balance of two business Units?Summary: What is the best way to prepare a consolidated Trial Balance of two business Units? Content (please ensure you mask any confidential information): There are man…Kirtee Jeetah-Naran 31 views 3 comments 0 points Most recent by Kirtee Jeetah-Naran Reporting and Analytics for ERP
-
financial categoriesSummary: ERP Financial Categories and Fusion Analytic Warehouse Content (please ensure you mask any confidential information): Customer is implementing Fusion Analytic W…VALENTE CORTES-Oracle 41 views 3 comments 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
How do I connect SmartView to ERP Cloud?Hi, It's been a long time. In the past when Cloud ERP was fairly new(4yrs ago). I remember on a project we connected SmartView to Cloud ERP. If I remember right, ERP spi…Hyperion_Junkie 231 views 2 comments 0 points Most recent by Hyperion_Junkie Reporting and Analytics for ERP
-
What are the native reivables dashboards and what is the execution path?Summary: I need to know what the native bashboards of the accounts receivable module are so that the client can use them Content (please ensure you mask any confidential…MARCO GARCIA TOVAR 34 views 1 comment 0 points Most recent by Helle Hennings-Oracle Revenue Management
-
Name of/where to find the OTBI report that produces the infotile on the landing page for ExpensesSummary: I would like to add some content to that infotile, but I have not yet discovered where to find it in the Reports and Analytics folders. At one time the infotile…
-
How to create analytics for fiscal document generation (FDG)Hi! I'm trying to create some analytics for the FDG but I can't find them in the analysis part, they are only available for part of the FDC, could anyone help me? This i…Jonatan Molossi 35 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
It is possible to add an additional is column in the Bank Statement Transactions dashboardSummary: There is a native cash management dashboard that shows bank statement lines, their status and other information. It is required that an additional column be add…Cezar Mata 75 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Payables, Payments & Cash Management
-
In which table is the "Resource Management" data stored?Which table stores the data displayed in Manage Resources search results? I want to retrieve these data with SQL. Path::Setup and Maintenance>Financials: Resources>Manag…REI TSUKAHAR-Oracle 210 views 1 comment 0 points Most recent by Shivashish Dwivedi-Oracle Project Management
-
Issues in syncronization of Columns in OTBI analysisSummary: Hello, I was trying to make a simple analysis with one subject area for which I added my Business Unit column and then added my Bank Account name in another. Th…
-
Are there downloadable dashboards for Financials modules?Summary: I am looking for downloadable dashboards like the ones created by Caroline Gladwin (please refer to link: OTBI Sample Dashboards - 1. How to Install and Configu…ShailenS 52 views 2 comments 0 points Most recent by Teresa Cabrita - Capgemini UK Reporting and Analytics for ERP
-
Are the tables related to OTBI reports available to report on in OTBI?Summary Would like to monitor changes to OTBI reports at the table level until OTBI reports are being monitored via Audit PoliciesContent Would like to monitor changes t…Jeff Hare CPA CISA CIA 161 views 6 comments 3 points Most recent by User_BZ5TP Reporting and Analytics for ERP -
Fusion Role Required for Approval & ReportsContent This sounds like a basic question, however we did not get a convincing answer via My Oracle Support. We are a Finance & SCM customer, and we would like to know (… -
What duty roles and privileges are needed to access withholding tax reports in Fusion?Summary: Hi Everyone, We have a case where a user needs to access the "Payables Withholding Tax by Tax Authority Report", WITHOUT being granted a payables role. The user…
-
Mapping Oracle eBS (12.2.8) tot Oracle CloudContent We are currently investigating moving from Oracle eBS on premise (12.2.8) to Oracle cloud. We have quite some customizations and reports build on the old datamod…Pam Koertshuis 400 views 3 comments 2 points Most recent by Manju Chugani Reporting and Analytics for ERP -
Are the BPM configuration tables exposed to OTBI?Summary Looking to query BPM configuration tables directly to support external audit change management populationContent Are the BPM configuration tables exposed to OTBI…Jeff Hare CPA CISA CIA 84 views 6 comments 0 points Most recent by Bianca Lei Villareal Reporting and Analytics for ERP
-
How to create a role with limited access (by module) to Reports and AnalyticsSummary: When you give a user access to the BI catalogue as a 'BI Consumer' then the person has access to data from all modules in play. We want to limit certain users t…Reinhard Klahn 37 views 3 comments 0 points Most recent by Reinhard Klahn Reporting and Analytics for ERP