Popular Tags
- OTBI 1,448
- Reporting 1,394
- FDI 1,123
- Analysis and Data Visualization 988
- BI Publisher 856
- Analysis 682
- Oracle Fusion Analytics 591
- Administration 555
- OAC 454
- OBIEE 433
- Analytics 403
- BI Publisher Data Models 356
- Security 293
- HCM 268
- BIP 264
- Answers 264
- Analyses 255
- Developers 246
- Data Modelling and Datasets 229
- Data Connectivity 210
- ERP Analytics Content 210
- BI Publisher Report Templates 204
- Oracle Analytics Cloud 197
- Fusion Data Intelligence 187
- Report Output 184
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
-
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…
-
-
How can we add date parameters through advance SQL in OTBI?Hi All, We have a custom OTBI report that in which we want to add some date prompts, Can anyone guide me how to add date prompt from advance sql? How we refer parameter …
-
How to pass parameters through agents in OTBI?Hi All, We created a fully customized OTBI report to fetch balance details, all the customization is done through advance sql/XML, the report is running fine manually, b…
-
No data from User System Usage subject areaWe're using this analysis from the start of the implementation to know how many users are accessing the system. However, the data was stopped at October 2023 and I'm pre…
-
Roles to Create and Schedule an OTBI AgentGood Day, Just want to ask what roles should be given to the user to be able to create and schedule an OTBI Agent. Thank you.
-
What is the logic to add while creating the prompt in the Logical sql query in OTBISuppose a field/column- Effective Date of Balance in Payroll should be between two dynamic parameters such as Start date and end date. Start Date and End date will be as…
-
How to create a report/Analysis in OTBI to have details with respect to Security Audit?I need to create report with fields listed as below: User Name, User Email, Role Name, Role Provisioned date, Role provisioned by What are the steps/Subject areas/ SQL?