Popular Tags
- OTBI 1,433
- Reporting 1,386
- FDI 1,087
- Analysis and Data Visualization 981
- BI Publisher 845
- Analysis 676
- Oracle Fusion Analytics 579
- Administration 555
- OBIEE 432
- OAC 426
- Analytics 395
- BI Publisher Data Models 350
- Security 291
- Answers 264
- HCM 257
- Analyses 254
- BIP 253
- Developers 244
- Data Modelling and Datasets 226
- Data Connectivity 211
- ERP Analytics Content 208
- BI Publisher Report Templates 204
- Report Output 184
- Oracle Analytics Cloud 177
- Customizing Reports 159
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.
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
-
Budget Distribution Data in OTBI FusionIs there any subject area in Fusion OTBI that contains data from the following budget distribution tables: xcc_budget_dist_lines xcc_budget_dist_headers Currently, I can… -
How can I join the DOO_HEADERS_ALL table with PO tables like PO_LINES_ALL in Oracle Fusion ?I’m working on a BI report for order and item details like order number and item number and description in Oracle Fusion, and I need to join the DOO_HEADERS_ALL table wi…
-
IBAN for OTBI analysisHello experts, we want to create an OTBI analysis with the IBAN info of the employees, does anyone know which subject area and which column we need to use? Thanks a lot …
-
query find history candidate pools in its different phasesHello. In which tables or subject area we can find the status history in its different phases of candidate pools. Thanks and regards.
-
Get current and future termination EE records in OTBIHi, We are trying to build a demographic file that should pull the data of EEs as of system date and also future terminations in next 7 days. I have tried using the pref…
-
Any Subject Area in OTBI to achieve employee wise fixed cost CTC based on selected monthHi, We have a requirement to display the sum of CTC of all employees for that particular month selected via month input parameter. Please find the below sample requireme…
-
How to Join DOO_HEADERS_ALL table with PO_HEADERS_ALL or PO_LINES_ALL table?I need Order number from DOO_headers_all, then item description from PO_LINES_ALL, also I need receipt_number and invoice number. HEADER_ID is not matching with PO_HEADE…
-
Unable to join the field Display Name in Requisition Preparer in Procurement-Requistions Real TimeHi All, Requirement : To add the 'Entered By' field from the Manage Requisition Header UI to an existing OTBI report (Full PO Report - Purchasing) Subject Area : Procure…
-
OTBI Prompt - Last Day of the Previous Month 23:59:59Hi all, Hope you are keeping well. So far, within a Prompt we are using the following code and this does indeed bring back the Last Day of the Previous Month successfull…
-
OTBI Question: comparing columns from two subject areasHi All, I have a question on creating a filter using columns from two subject areas. For example, "Workforce Management - Worker Assignment Real Time"."Worker Assignment…
-
How to build an Analysis on OTBI to show every colleague's default expense account?Summary: Need report to show all colleague's default expense accounts. Content (required): I need to create a report to show every colleague's default expense account so…
-
Duplicate rows in Active Employees ReportWhen running the Active Employees Report I am getting duplicate rows for only a few of the employees. What is the best workaround for this?
-
Equivalent table in cloud fusion for the EBS standard table fnd_responsibilityDear Experts, I am trying create a OTBI report using a simple query as shown below using standard EBS table 'fnd_responsibility'. But it throws an error 'ORA-00942: tabl…
-
How to get list of custom OTBI Reports run Details in FusionHi All, I am looking to extract the list of OTBI reports run details like report run date, who/when submitted, report path, report name etc.. Could you please help me wh…
-
Query that link Legal Employer to Reporting EstablishmentHello! Good morning/afternoon/evening ! I am in a need of a query that can list all the Reporting Establishment for a Legal Employer. Does anyone have it or know if it's…
-
Is there any specific Privilege to restrict To See/edit Scheduled Report Jobs From Other UsersBI Admin Unable To See/edit Scheduled Report Jobs From Other Users ( Doc ID 2497964.1 ) - This document ID referring to have BI Admin role, BI Admin is an admin role so …
-
Report on usage of OTBI reportsWe are reviewing our reports in OTBI, please can you provide the following: A list of folders that have not been run in the last 14 months? Can you please confirm whethe…
-
How to find if a specific day falls between two dates - OTBITrying to create a formula to show yes/no if the 12th of the month falls between {"Payroll Period"."Start Date"} and {"Payroll Period"."End Date"} I attempted a simple f…
-
Restrict visibility on self data on a OTBI reportHello, How can I restrict the visibility on self data for a user? in an OTBI report. For exemple : A HR representative opens a report. He will see all the population, ex…
-