OTBI
Discussion List
-
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 Saini -
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 11 views 1 comment 0 points 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 10 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 13 views 2 comments 0 points Most recent by Kishore Padala-Support-Oracle Applications Security -
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…
-
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…Mona Mantry 22 views 5 comments 0 points Most recent by Mona Mantry Financials – General (READ ONLY) -
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 20 views 0 comments 0 points Started by Chowdari Malapati Monika Payables, Payments & Cash Management
-
User who is executing that report(BIP/FRS/OTBI) should display results for his data access only.Summary: User who is executing that report(BIP/FRS/OTBI) should display results for his data access only not all the ledgers but Currently reports shows data for all led…Chowdari Malapati Monika 1 view 1 comment 0 points Most recent by Baidehi Nanda–Support-Oracle Financials – General (READ ONLY)
-
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 32 views 3 comments 0 points Most recent by Kirtee Jeetah-Naran Financials – General (READ ONLY)
-
Criteria to Filter BICC output for current and previous periodSummary: Criteria to Filter BICC output for current and previous period Content (please ensure you mask any confidential information): Below are the PVOs im using in my …Jaeyshree K K 12 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Financials – General (READ ONLY)
-
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 Financials – General (READ ONLY)
-
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 57 views 2 comments 0 points Most recent by Hyperion_Junkie Financials – General (READ ONLY)
-
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 32 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 33 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 66 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 73 views 1 comment 0 points Most recent by Shivashish Dwivedi-Oracle Project 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. 72 views 2 comments 0 points Most recent by Aaron Leggett Reporting and Analytics for ERP -
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 51 views 2 comments 0 points Most recent by Teresa Cabrita - Capgemini UK Financials – General (READ ONLY)
-
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 Financials – General (READ ONLY) -
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 (…Rihan Jameel 60 views 10 comments 2 points Most recent by PradeepPR Financials – General (READ ONLY) -
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 321 views 3 comments 2 points Most recent by Manju Chugani Financials – General (READ ONLY) -
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 Financials – General (READ ONLY)
-
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 31 views 3 comments 0 points Most recent by Reinhard Klahn Financials – General (READ ONLY)