OTBI
Discussion List
-
TOPN Function in OTBISummary: Content (required): Hi, The ultimate requirement is to create a dashboard; Analysis 1 - Annual Revenue in a Bar chart Analysis 2 - Revenue for each cost center …Sheneli Fernando 42 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Transactional Reporting (OTBI) -
Which table store User category and Password expiration DateSummary Which table store User category and Password expiration DateContent Hi Guru's Please let me know Which table store User category and Password expiration Date und…
-
How to properly address P2T ERP missing subject areas when support remains unresolved after a week?Summary: Missing OTBI subject areas after every clone, support unresolved Content (required): Every clone has same issues with OTBI subject areas missing. We follow SR g…Melissa Goodrich 14 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Financials – General
-
What is the recommended way for an external system to extract data in bulk from Oracle Fusion?Summary: I'd like to understand the recommended way for an external system to extract data in bulk from Oracle Fusion? Content (required): I understand the various ways …
-
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… -
Audit Report for OTBI Reports Metadata ChangesSummary Audit Report for OTBI Reports Metadata ChangesContent Hi Gurus, It is year end Audit time and we need some information on the changes made to "Key Reports" durin… -
How to find the View Object for Latin American Localization JL BR ARSummary: We was create OCI Data Integration from SaaS, and we need information to JL_BR_AR tables. For example: JL_BR_AR_BANK_OCCURRENCES, JL_BR_AR_BANK_RETURNS_ALL, JL_…Wendel Andrade 37 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Receivables & Collections
-
Need a query to get the Receipt methods with its bank accounts and GL account combinationsSummary: Need a query to get the Receipt methods with its bank accounts and GL account combinations Content (required): Version (include the version you are using, if ap…
-
Record Identifier In GL InformationSummary Record Identifier In GL InformationContent Is there any additional info resubject area apart from this note. Record Identifier In GL Information under Manager De…
-
Is it possible to have default prompt value specific for each user in an OTBI dashboardSummary: We have an OTBI dashboard for which each user is searching a specific account combinasion. Instead of always typing the account in the prompt of the dashboard, …Remi Grégoire-Jacques 4 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Financials – General
-
OTBI Column NameSummary: Hi, We have requirement to capture account balances as at a particular date (entered as a parameter) in an OTBI report. How do we cater this requirement? Regard…
-
Changing User IDsSummary:We use our email addresses as our user ids in Oracle. Our company is getting ready to change the prefix of our emails from ex. [email protected] to [email protected]…
-
Is it possible to have default prompt value specific for each user in an OTBI dashboardSummary: We have an OTBI dashboard for which each user is searching a specific account combinasion. Instead of always typing the account in the prompt of the dashboard, …Remi Grégoire-Jacques 13 views 2 comments 1 point Most recent by Nathan CCC Reporting and Analytics for ERP
-
ERP - OTBI Advanced Features event on Sep 22th 9am Pacific TimeSummary: After the record interest from this community on the previous OTBI event 'ERP - OTBI Made Easy' in May, and several requests for an advanced session, we decided…Maria Centeno-Cloud ERP-Oracle 22 views 1 comment 0 points Most recent by Aaron Tanek Financials – General
-
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 &… -
GL Audit Data export from SAASContent We are in the process of GL Auditing with Audit agency, Any body could share the template of DM and REPORT from Oracle SAAS environment to EY. Version 21C
-
Cloud Financials on Macbook / Mac OSSummary Is Oracle Cloud Financials supported on Macbooks/MacOS?Content Hi, I'm posting to find out what level of support is offered for Cloud Financials on Macbooks/MacO…
-
Scheduling/Automation software available to support Oracle Fusion.Summary Scheduling/Automation software available to support Oracle Fusion.Content Hi Experts, We have a requirement to automate and schedule process in oracle cloud. Exa…
-
Need table name which store Fiscal Classification CodeSummary Need table name which store Fiscal Classification CodeContent Hi Guru's, Please let me know which table store the Fiscal Classification Code which comes under "M…
-
How to add more descriptive flexfields in Business UnitsSummary How to add more descriptive flexfields in Business UnitsContent Hi We would like to ask if there is a way to add more descriptive flexfields in Business Units? T…JOHANN CHRISTIAN MORDENO 17 views 1 comment 0 points Most recent by Vaishnavi Aryasomayajula-Oracle Financials – General
-
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… -
OTBI KFF Description In The GL Subject Area Is Displaying As Concatenated Code + Description: How toSummary Doc ID 2537985.1 Describes how to fix KFF value descriptions so that they are consistent with the GL KFF descriptions (not concatenated), but it didn't work for …SimonTomey 24 views 5 comments 2 points Most recent by Anca Amarghioalei-Oracle Financials – General -
HOW TO: Embedding Contextual Dashboard — Page Binding ParametersSummary Documentation to embed a dashboard as a webpage in ERP pages with contextual prompts using binding parametersContent We've been live with Oracle Cloud Financials… -
ERP - Testing Automation ToolsContent We would like to know of any success stories of companies who have automated their testing in Oracle ERP (Financials or Procurement). I've been looking around, a…
-
OTBI Manual User for financial UsersSummary OTBI Manual User for financial UsersContent HI, All Can anyone send me an OTBI Manual user for financial Users? How financial users create their Reports using OT…Mohamed Elwan-Oracle 39 views 10 comments 4 points Most recent by Mohamed Elwan-Oracle Financials – General -
A company wants to sell part of its businessSummary Typical Organization planning for De-MergerContent There is a Company A, who is on oracle Cloud and now it wants to split the business into two parts i.e. Compan…
-
How to remove access to Approval Group in BPM worklistContent We need to remove the access to Approval Group in BPM worklist for edit/update for all business users and only IT team should have access. Which role/previlege c…DPM 21 views 3 comments 2 points Most recent by Cezar - Fusion Oracle Support-Oracle Financials – General
-
How to use Validation type "View Object" in the valuesets?Summary How to use Validation type "View Object" in the valuesets?Content Hi Experts, I am trying to understand how to use the validation type with "View Object" in the …Balakrishna Sivappagari 60 views 1 comment 1 point Most recent by Nadia Khan-73252 Financials – General
-
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… -
Oracle Fusion-Manage Allocation Formulas- Complex formulas to allocate fees calculated based on reveSummary I want to know what the most effective approach would be for automating fee/royalty calculations for different contract agreements.Content I am trying to help st…