Oracle Transactional Business Intelligence

Welcome to the Oracle Transactional Business Intelligence Community Forum!

Whether you're a seasoned user or just starting your journey with OTBI, the solution for transactional reporting in Fusion Apps, this forum is your go-to for questions and discussions. Connect with experts, seek advice, share insights, and post product recommendations in the Idea Lab.

If you're new to OTBI, visit our Doc Library and OTBI Resources pages for more details and answers to common questions - links to these and more are available in the Knowledge Base: https://community.oracle.com/products/oracleanalytics/kb/articles/62-resources-for-oracle-transactional-business-intelligence-otbi

For OTBI inquiries on subject areas and use cases, please direct your questions to one of our OTBI pillar forums (HCM, ERP, SCM, Sales, Field Service) on Customer Connect to receive tailored assistance.
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Oracle Transactional Business Intelligence

Discussion List

  • Prudence K
    Administration & Recruiting Reporting
    Summary I need to union report on these two environments Content I have gone through the other postings and from what I can see, I believe this is not possible, but want…
    Prudence K 22 views 1 comment Most recent by Kelly Basnett
  • Emmanuel Baillieu
    Publish Agent for Subscription
    Summary I need to know the limits of the functionality Content I used several OTBI Agents to deliver some OTBI Analysis to users. To avoid them to create their own agent…
    Emmanuel Baillieu 31 views 1 comment Most recent by Dimple-Nagesh-Support-Oracle
  • Charan Kollipara
    Scheduled Report Jobs
    Summary Deails of Scheduled Report Jobs Content Hi Experts, I would like to know is there any seeded report to pull the complete details of scheduled report jobs in BI o…
    Charan Kollipara 182 views 8 comments Most recent by Akshay Aiyer
  • Fongang
    List of OTBI inefficient Reports
    Summary looking for was to monitor OTBI reports performance and Frequency of use Content Hi All, I am looking for ways to monitor the performance of OTBI Reports in fuss…
    Fongang 71 views 6 comments Most recent by AshishERPCloud
  • Ruthie
    Hidden fields in OTBI
    Summary Need to find fields selected as 'Hide' as system default in column properties Content We have recently had an issue where one of our users has hidden a couple fi…
    Ruthie 236 views 5 comments Most recent by Nathan CCC
  • Vishal Gala
    Need a SQL query to list all the scheduled OTBI Analsis and dashboards
    Summary We need to review and track all the OTBI reports that are scheduled via agents Content Having the ability to query this out helps us understand who all have sche…
    Vishal Gala 212 views 2 comments Most recent by Akshay Aiyer
  • Jonathan Chan gmg
    Extract first sets of integer from entries
    Summary How to extract the first sets of integer from entries in "New Calculated Measure" Content Hello Oracle Community, In "New Calculated Measure" in Analysis, how ca…
    Jonathan Chan gmg 123 views 8 comments Most recent by Jonathan Chan gmg
  • Osama Fawzy
    call a procedure on oracle bi publisher 12c
    Summary oracle bi publisher add Global-Level Element by PL/SQL Content Hello all, How to call a procedure that return multiple parameters on oracle bi publisher data mod…
    Received Response
    Osama Fawzy 440 views 2 comments Most recent by Osama Fawzy
  • Jonathan Chan gmg
    Rows overcounting in Analysis
    Summary How to only count the number of rows showing in an analysis Content Hello Oracle communities, When I attempt to display the total number of rows shown in an anal…
    Received Response
    Jonathan Chan gmg 93 views 2 comments Most recent by Jonathan Chan gmg
  • Ruthie
    Hide Set at Default button under column properties
    Summary Hiding Set as default button under column properties in an Analysis Content Is it possible to hide the 'Set as Default' button under the column properties in an …
    Received Response
    Ruthie 41 views 3 comments Most recent by Ruthie
  • Lisa G.
    SQL to Query Report Library - OTBI Catalog
    Summary Looking for SQL or tables to report a list of all reports, properties and folder location Content Does anyone have a SQL or know the tables that would contain th…
    Received Response
    Lisa G. 813 views 4 comments Most recent by Lisa G.
  • Jonathan Chan gmg
    Error when using TODATE(REVENUE, YEAR) Oracle SQL function
    Summary TODATE function resulted in error, what are possible alternatives to get the needed results? Content Hello Oracle Community, The below error (per enclosed 2 scre…
    Received Response
    Jonathan Chan gmg 167 views 7 comments Most recent by Arun Raj
  • Orit Dekel
    How can I export a list of all active reports we have HCM?
    Summary I need to have a list of all our reports in HCM BIP (and/or)OTBI Content How can I found out how many reports there are in use at the sys? Who created them, acti…
    Orit Dekel 72 views 5 comments Most recent by [Deleted User]
  • Jonathan Chan gmg
    Sort drop-down list descendingly in Table Prompts in Analysis
    Summary How to sort drop-down list descendingly in Table Prompts in Analysis Content In OBIEE Analysis, how can table prompts value (per enclosed screenshot) be set to s…
    Received Response
    Jonathan Chan gmg 202 views 8 comments Most recent by Jonathan Chan gmg
  • Giuseppe Iacono
    How to upload css in a dashoard
    Content Hello Guys, Sorry for my ignorance, I have seen that it is possible to refer to style sheets when you want to edit sections of the dashboard. My question Is? Whe…
    Giuseppe Iacono 91 views 2 comments Most recent by Nathan CCC
  • Alvaro Couto
    List of Agents
    Summary List of Agents in "My Folders" Content Hi Team, Does anyone know how to list a list of Agents that were created by users and saved in their "My Folders"? I belie…
    Alvaro Couto 214 views 11 comments Most recent by Nathan CCC
  • Mr  H
    Referencing Parameters in the Layout Editor Filter
    Summary Referencing Parameters in the Layout Editor Filter Content Hi, What is the syntax we should use to reference a parameter in the Layout Editor Filter? BR Hany
    Received Response
    Mr H 121 views 9 comments Most recent by Mr H
  • Gaayathri Moulee
    BICC for GL Extract
    Summary BICC for GL Extract Content Hi, We do have an auditing requirement to extract large volume of data from GL Lines and GL balances which may have more than 3 milli…
    Gaayathri Moulee 42 views 3 comments Most recent by Mihaela M
  • Mr  H
    Report on Social
    Summary Need to create a report on Application Social Content Hi, We have a requirement to build reports on Social. Are there any OTBI Subject area or Tables to select f…
    Mr H 61 views 2 comments Most recent by Mr H
  • Alvaro Couto
    BIP Excel template
    Summary ER for Excel XLSX version Content Hi Everyone, Does anyone know the ER# - even better with ETA, regarding having XLSX for Excel Templates in BI Publisher reports…
    Alvaro Couto 42 views 2 comments Most recent by Nathan CCC