Popular Tags
- OTBI 1,429
- Reporting 1,383
- FDI 1,062
- Analysis and Data Visualization 976
- BI Publisher 840
- Analysis 673
- Oracle Fusion Analytics 577
- Administration 555
- OBIEE 429
- OAC 408
- Analytics 382
- BI Publisher Data Models 346
- Security 288
- Answers 264
- HCM 256
- Analyses 253
- BIP 248
- Developers 243
- Data Modelling and Datasets 223
- Data Connectivity 208
- ERP Analytics Content 205
- BI Publisher Report Templates 201
- Report Output 183
- Oracle Analytics Cloud 169
- Customizing Reports 156
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
-
Audit Related: Last Logon SessionSummary Last LogOn Session: Looking for a audit related report that shows last time accessing Oracle Content I am able to query HCM related tables (such as per_users) to… -
Security and users access to OracleHi Gurus, can you please assist in what best practices available to control the below points in Oracle fusion, and is there any report from Oracle that show last activi…
-
Fixed Asset Register report returns current period date instead of selected past datesFixed Asset Register report is not working when you select a date in the past like OCT 2023. it only returns the current Open period after running depreciation. How will…
-
How can two different teams can use a single PVO with different set of columnsHi, We have a scenario where AP team can extract ledger PVO with different column set and similarly AR team also need to extract the same PVO with different column set. …
-
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 …