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

  • 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 223 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 43 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
  • Jonathan Chan gmg
    How to override NULL values with existing values
    Summary How to override null value with values from another column in OBIEE Analysis Content When building an analysis in OBIEE, what would be the code to enter into the…
    Received Response
    Jonathan Chan gmg 446 views 8 comments Most recent by Jonathan Chan gmg
  • Doron de Jong-57089
    How to do an average days to approve formula?
    Content Hi all, I am trying to do an average days formula from a requisition submission date and when it was approved, and then put another column in with the month it w…
    Doron de Jong-57089 42 views 1 comment Most recent by aconavay
  • Nathan CCC
    What is catalog folder Extension?
    Summary Does anyone know the purpose of the empty shared folder Extension in the catalog? Content The folder is empty. A duty role exists for it, BI_EXT_REPORTING_DUTY, …
    Nathan CCC 32 views 1 comment Most recent by User_7836
  • Silvia Guido
    Suspended job report
    Summary Suspended job report Content Hi, I have a question about using a BIP job report: I have a job report that is scheduled to be sent every night if the day before s…
    Silvia Guido 22 views 2 comments Most recent by FPonte
  • Jonathan Chan gmg
    Building BOM using analysis
    Summary How to build a hierarchical BOM analysis showing on-hand quantity and item cost all for components in all levels Content In OBIEE, pre-built analysis "BOM" and "…
    Jonathan Chan gmg 41 views 2 comments Most recent by Jonathan Chan gmg
  • Kevin Lee Choon
    Deferred Termination field in OTBI
    Summary looking on how to determine a deferred termination Content Hello, I have been asked to create a report showing the associates with a deferred termination. When t…
    Kevin Lee Choon 51 views 3 comments Most recent by prjohnson
  • Rosenerie Castillo
    Help with Formula: most recent offer
    Summary I need help creating a formula to pull in the most recent offer Content I'm pulling together a list of YTD offers. I am finding records where the candidate has a…
    Received Response
    Rosenerie Castillo 95 views 7 comments Most recent by Jonathan Chan gmg
  • Aaron Hager-17476
    Lost Functionality in OTBI after PB 10.17
    Summary After taking PB 10.17, we saw that icons did not work in OTBI. Content We test after every monthly patch. What we found was that, after 10.17, we could no longer…
    Aaron Hager-17476 41 views 1 comment Most recent by Matthew Carothers-Johnson
  • Prudence K
    Link OTBI Summary Report to BIP Detail Report
    Content Hi all - we have a request to link report A to report B. Report A will be like a summary report - name, manager, person #, job title. Report B will have signific…
    Prudence K 74 views 5 comments Most recent by Prudence K
  • AshishERPCloud
    Feasibility of having SQL Developer Connection to Oracle HCM Cloud Enviornment?
    Summary Feasibility of having SQL Developer Connection to Oracle HCM Cloud Enviornment? Content Hi Experts, I hope that most of you who have worked on an On-Premise syst…
    AshishERPCloud 96 views 5 comments Most recent by narasimha arekatla
  • Neha_Takkar
    Reports Run Count
    Content Is there a way to find out how many times a report was run and who ran it? Like we may have 10 reports and want to find out which is the report that is used the …
    Neha_Takkar 92 views 2 comments Most recent by Julian Challenger-Oracle
  • Lisa Spence
    Sharing OTBI Analyses
    Summary Need guidance on how to share OTBI templates with other internal users Content Hi all! I am new to Fusion and OTBI. I have searched Oracle Support and the Librar…
    Received Response
    Lisa Spence 316 views 11 comments Most recent by Onkar Tiwari
  • David Rabalais
    BI Publisher, First Time Setup, Report Server
    Summary I cannot find a clear guide to where I get the report server URL. Content The URL I tried it with is: https://podurl.fa.us2.oraclecloud.com:9704/xmlpserver/ I've…
    Received Response
    David Rabalais 101 views 5 comments Most recent by David Rabalais
  • Sian S
    Custom BI Webcat Reporting Duty
    Summary Trying to hide seeded reporting folders and understand the updated options within 19D Content We are keen to have the option to hide seeded folders from users. C…
    Sian S 387 views 5 comments Most recent by [Deleted User]