OTBI
Discussion List
-
Make a REST call from an ESS Job - Ideas needed!Summary Make a REST call from an ESS Job - Ideas needed!Content Hi Guys, Is there an option to call a REST service from an ESS Job? Please share your inputs. Thanks, Abh…Abhilash K - Deloitte USI 51 views 3 comments 1 point Most recent by Arun Raj Reporting and Analytics for ERP -
OTBI Subledger Journals subject areaSummary OTBI Subledger Journals subject areaContent Hi, In OTBI Subledger Journals Subject area, We have a date supporting references in the format YYYY/MM/DD. Since sup…Vinod Kumar Mohanraj 32 views 2 comments 1 point Most recent by Vinod Kumar Mohanraj Reporting and Analytics for ERP -
AR Docket generation - optionsSummary Business is looking to generate an AR Docket - from Oracle fusion - what options, extensions, enhancements are available for the sameContent Business is looking …Dhruvjoshi23 15 views 0 comments 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
Why can't I see the information for flexfields from subject areas in Results tab?Content Hi, We have Oracle Business Intelligence 11.1.1.9 and Oracle Cloud Application 21B (11.13.21.04.0) We are development an Analysis using Receivables - Bills recei…Henry Cabrera 36 views 0 comments 1 point Most recent by Henry Cabrera Reporting and Analytics for ERP -
How to give an access to specific users to custom ess jobSummary How to give an access to specific users to custom ess jobContent Hello All, We have one custom report and we have created a ess job to it and now wats to give an…Koteswararao Yenikepalli 43 views 2 comments 2 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP -
Highlight duplicate values based on a value in another columnContent Could somebody help me with the following issue, please: In an OTBI report with data from the Enterprise Contracts module, I would like to highlight (eg. with co… -
OTBI Catalogs for Primary Statements (Balance Sheet, Cash Flow, Income Statement)Summary OTBI Catalogs for Primary Statements (Balance Sheet, Cash Flow, Income Statement)Content Hi Is there standard catalog files available for primary statements whic… -
From To Accounting period condition in OTBISummary From To Accounting period condition in OTBIContent Hi all, Is it possible to keep 'From' and 'To' Accounting period as input prompts in PTBI GL/Subledger subject…Vinod Kumar Mohanraj 58 views 1 comment 1 point Most recent by SimonTomey Reporting and Analytics for ERP -
What Role/Privilege grants access to edit Scheduled Agent "RUN AS" in OTBI?Content Does anyone know what Role/Privilege allows access to update the "Run As" field in a Scheduled Agent for an Analysis in OTBI? I've assigned the following to a te…Mike Burnett 23 views 1 comment 2 points Most recent by Syed Misbauddin-Support-Oracle Reporting and Analytics for ERP -
Receiving - Purchase Receipts Real Time returns no data for ReceiptContent Hi, We have a requirement to create a report that provides details for Receipts. I'm trying to build the report using the Receiving - Purchase Receipts Real Time…User_2025-02-06-06-53-48-161 68 views 3 comments 3 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
Add new permission to existing custom folder in BI CataglogSummary Error when adding new permission to existing custom folder in the BI catalogContent 'Assertion failure: !tAccountId.isEmpty() at line 282 of project/websecurity/…Hannah Dorman 31 views 5 comments 1 point Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
Selecting multiple column headers for styling in OTBI analysisContent Hello all, May I know, if there is an option to select all the column headers and apply a certain style rather than selecting each and every column and applying … -
BI Publisher report in Oracle fusion not completing after 21B upgradeSummary BI Publisher report in Oracle fusion not completing after 21B upgradeContent Hello Peers- Posting our experience with one of the BI Publisher reports after upgra…Dhruvjoshi23 69 views 11 comments 2 points Most recent by Dom Galano Reporting and Analytics for ERP -
Analysis BI displays duplicate values in parametersContent This problem appeared on May 5th and disappeared with update 21B. All Analysis BI in our production instance showed the same behavior. We validated that the anal… -
Invalid Subject Area Error in OTBI report creationSummary Invalid Subject Area Error in OTBI report creation using Create Analysis from simple logical sqlContent Hi, We are getting an Invalid Subject Area Error while cr… -
Restrict users from sending reports to external email addressesContent Hi, As we know, Oracle allows to include the email address when adding a Destination for a report output in both OTBI and BIP reports. Is there a way to restrict…Madhu Chalamalasetty 178 views 6 comments 1 point Most recent by Madhu Chalamalasetty Reporting and Analytics for ERP -
UK Payslip CustomisationSummary UK Payslip CustomisationContent Hello Experts, Need your help. Can you please help if you have already done UK Payslip Customisation; Like the details of the cus…User_2025-01-30-20-59-13-989 63 views 2 comments 0 points Most recent by User_2025-01-30-20-59-13-989 Reporting and Analytics for ERP -
Why is there no output from a scheduled OTBI report when the interactive version works fineSummary A report with csv output with parameters can be run interactively, but when scheduled no output can be found in scheduled processes, but available though e-mailC…Warren Murray 53 views 3 comments 2 points Most recent by Warren Murray Reporting and Analytics for ERP -
Subledger Period Close Exceptions Report query timeoutSummary SQL query time exceeds the limit (2400 sec). Stopped processing.Content Hi, just wondering if anyone has any experiences with the Subledger Period Close Exceptio…User_2025-02-10-13-18-56-927 32 views 0 comments 2 points Most recent by User_2025-02-10-13-18-56-927 Reporting and Analytics for ERP -
Invoice attachment link in OTBI analysisContent Hi, Looking to see if there is a way to provide a hyperlink in an OTBI analysis that would open up (preferably in a new window) an attachment associated with an … -
Updating KFF tree versions causes OTBI Analyses to fail when created in “General Ledger – Balances RSummary We are testing changes to the KFF segment values and hierarchies (aka trees). All seems fine with all changes, and GL OTBI reporting until ‘something’ happens an… -
What are the Correct Parameters for OTBI Fusion GL for ESS "Import Oracle Fusion Data Extensions forSummary This ESS request is the very last process in updating KFF OTBI Trees (so we can use OTBI "GL - Balances Real Time"). "All" or (just) "ERP" doesn't work, but "ERP… -
Report and Dashboard prompts on multi tab DashboardSummary Prompts not clearing and show selections from other report promptsContent I have a multi tab Dashboard with two to three reports on each tab. Each report has it'…User_2025-01-28-20-19-02-475 63 views 1 comment 2 points Most recent by SantoshKumarBhairi Reporting and Analytics for ERP -
How to Add the OTBI Dashboard to the Financial Reporting Center?Summary How to Add the OTBI Dashboard to the Financial Reporting Center?Content How to Add the OTBI Dashboard to the Financial Reporting Center? OR If i can make it more…User_2025-02-11-09-27-02-564 202 views 6 comments 2 points Most recent by Raghavan p-Oracle Reporting and Analytics for ERP -
How do we distinguish between custom reports and standard reports?Summary We want to know how many custom reports are created in reporting center. How do we distinguish between custom reports and standard reports?Version Oracle Fusion …Patrick Chrabieh 227 views 2 comments 7 points Most recent by Skolli-Oracle Reporting and Analytics for ERP -
If we need to run a report or a query on all the profile options currently set for our client in FusSummary If we need to run a report or a query on all the profile options currently set for our client in Fusion, is there any way?Version 21AUser_2025-02-08-12-06-31-659 38 views 1 comment 1 point Most recent by OmkarAdkar Reporting and Analytics for ERP -
Account Segment Group ObjectsContent Our team is looking to group together certain accounting segments for use in some of their reporting and imports. They currently have specific payroll object gro… -
Configuring Key Flexfield Segments in Oracle Financials Cloud to leverage OTBI for ad-hoc analysesSummary Configuration Steps to enable OTBI reporting of Key Flexfields (KFF's) in GL, Budgetary Control and Fixed Assets (Rel 11)Content To report on Key Flexfield Segme…Anand DN-Oracle 1.7K views 8 comments 12 points Most recent by Chris Lynch - AST Reporting and Analytics for ERP -
Budget balances not available in General Ledger subject areasSummary Can we query budget balances in General Ledger subject areas?Content Budget balances not available in General Ledger subject areas like 'General Ledger - Balance… -
Can Saved Custom Groups be used in Calculations/Formulas?Summary Using Custom Groups in Calculated ItemsContent In OTBI, I've designed an analysis where I've created custom groups of the Natural Account Segment Code using GL -…User_2025-02-11-07-08-23-440 19 views 1 comment 2 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP