Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Popular Tags

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

 
Sort Hot ▾

Discussion List

  • Asif Mahmood-2334
    How to run an OTBI Analysis and save output without having it delivered
    Summary How to run an OTBI Analysis and save output without having it delivered Content Is there a way to schedule an OTBI Analysis to run periodically and save the outp…
    Asif Mahmood-2334 21 views 1 comment Most recent by Rob F
  • Saswati Singh
    Problem with adding days in a date(sql)
    Summary Problem with adding days in a date (sql) Content Hi All, I’m building a bi report and I have the following problem when building the data model. Oracle provides …
    Saswati Singh 174 views 3 comments Most recent by Saswati Singh
  • Kristen Magno
    Cell Splitting based on special character
    Summary Split a field into two columns based on character Content Suppose I have a field (Name) in Last Name, First Name format. I want to make this into two columns ins…
    Kristen Magno 61 views 2 comments Most recent by Kim Welker
  • Lin Tiedemann
    Concatenate non text fields
    Summary Function Concat does not support non-text types. Content Is there a way to concatenate non-text fields? I would like to concatenate Req id and Candidate id to cr…
    Received Response
    Lin Tiedemann 158 views 4 comments Most recent by Reena Trangri
  • Kim Welker
    Return Candidate Name only for Specific CSW Selection steps/statuses
    Summary How to modify my SQL statement to remove redundancies Content Hi! I've created a report to return all Open Requisitions as well as Filled Requisitions for the pa…
    Kim Welker 191 views 11 comments Most recent by Rahul Thomas
  • Ruzwan Akram
    Help with my SQL Code
    Summary Help with my SQL Code Content I am trying to create a BIP Report to show Document Payslips pdf uploaded for each employee (with HDL) which covers the Tables like…
    Received Response
    Ruzwan Akram 102 views 1 comment Most recent by Ruzwan Akram
  • Mor Amsalem
    Users information in report
    Summary I need to create (or use one that exists) that will give me basic information on the users Content Hi, I need to create (or use one that exists) that will give m…
    Mor Amsalem 31 views 2 comments Most recent by Mor Amsalem
  • Andy French
    Email prompt does not allow for quotation mark
    Summary Email prompt does not allow for quotation mark Content We have a report built in Performance that pulls in a manager's full reporting hierarchy (both direct and …
    Andy French 53 views 3 comments Most recent by Andy French
  • Evan Jenkins
    Conditional Formatting on Column Sub-Total
    Content Hello, I've built a sickness report that counts the number of instances of sickness and number of days sickness over a time period. I've figured out how to add a…
    Evan Jenkins 41 views 1 comment Most recent by Caroline Gladwin-Oracle
  • Kim Welker
    Field Level Security and Folder Permissions
    Summary We want all user types to share one folder, but have user type permissions that can restrict certain confidential fields Content Hi - We are trying to find the b…
    Kim Welker 33 views 1 comment Most recent by Azfar Hussain-31614
  • Maria Lieberman
    Sorting alphabetically on name
    Summary Sorting alphabetically on name Content Hello - I have a sort on Candidate Name and I realized that names that are in lower case and names that have special lette…
    Maria Lieberman 51 views 5 comments Most recent by Rachel Martorelli-Oracle
  • Neil Peacock
    Agent Limitations
    Summary Encountering limitations on the exports from agents Content I am currently encountering an issue where exporting data through an agent is cutting off at 25,000 r…
    Received Response
    Neil Peacock 147 views 3 comments Most recent by Chris Dabel
  • Aaron Leggett
    SQL IS NULL error
    Content Hi We're trying to create multiple reports where we want to bring back a column with no data in (e.g. Missing Bank Details where the employee does not have a ban…
    Aaron Leggett 74 views 3 comments Most recent by Neil Peacock
  • User_EQ8R5
    Format prompt selections
    Summary Add specific formatting to prompted selections Content Is there a way to format the selections that show for prompts? For instance i need to have a prompt that f…
    Received Response
    User_EQ8R5 61 views 4 comments Most recent by User_EQ8R5
  • Wendy Ware
    Using Subject Area for Report: "Unable to retrieve metadata from data model"
    Summary Attempting to use Subject Area "Payables Payments - Payment History Real Time" in an OBI report which I have used before. Now I get error when I attempt to edit …
    Received Response
    Wendy Ware 33 views 2 comments Most recent by Wendy Ware
  • Peter Kirwan
    Stats
    Summary Stat Report Content is it possible to report where you have a count of the number of employees in a age range - the age ranges would be columns and then rows wou…
    Peter Kirwan 31 views 1 comment Most recent by Chris Dabel
  • Aaron Leggett
    How to stop employees viewing reports in 'Custom'?
    Content Hi We're having some trouble with report access. We're testing our reports and came across an issue where accounts with just the employee role can run reports co…
    Received Response
    Aaron Leggett 61 views 2 comments Most recent by Aaron Leggett
  • Andy French
    Link to Dashboard
    Summary Looking to provide a direct link to our Recruiting Dashboard for users not logged in Content I'm trying to create a link to our Recruiting Dashboard to be includ…
    Received Response
    Andy French 41 views 2 comments Most recent by Andy French
  • Peter Kirwan
    Terminated Line Manager
    Summary Report on where an employee's Line Manager is Terminated Content does anyone have a Report on where an employee's Line Manager is Terminated? This causes issues …
    Peter Kirwan 41 views 2 comments Most recent by Peter Kirwan
  • Erin Caby-47393
    Duplicates appearing - need true data
    Summary I have one field that is pulling different dates - need true data Content Hi Group, I'm having an issue getting a single date to pull in correctly in OBI. The fi…
    Received Response
    Erin Caby-47393 51 views 3 comments Most recent by Reena Trangri