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
-
Retrieve specific length of characters from a stringIn our case the string is a combination of segments concatenated with a '.'(Full Stop)-- Segment1.Segment2.Segment3... How do i fetch Segment2, i tried using SUBSTRINGN … -
Grouping of managers in OTBI dashboardsHello, we have to get the Level5/Level4/Level3/level2 manager details alone in the report while we are selecting the reportee details, but instead, we are getting all th…
-
How to update an existing OTBI report using SOAP Web Service calls?Using the updateObject SOAP call doesn't include all report changes (i.e. security, metadata) - is there a web service that can be used to update existing OTBI reports t…
-
Are REST APIs supported for OTBI reports in Oracle cloud/Fusion?Are REST APIs supported for OTBI reports in Oracle cloud/Fusion?
-
Enable SSO for oracle APEX and Cisco Duo.hi we have oracle apex instance installed on cloud DBCS at private subnet , we need to configure SSO with our Cisco Duo identity or using oracle Fusion Cloud. is there a…
-
Running an OTBI analysis report from a new tab attached to a form using Forms composerIs there any documentation or advise on how to configure (using page composer) a new tab on a form that when clicked opens up a previously configured OTBi analysis repor…
-
Add division parameter to OTBI ReportSummary: I am trying to create an OTBI report under the expense report templates to show approvers of given POs. I am able to add fields for company, department, and acc…
-
Is there a document that shows all attributes and and their subject areas?I'm still trying to understand OTBI and reporting and I needed a list of all sttributes and the subject areas they'll be under.
-
Which Subject area & folder to use to extract Manager Hierarchy fields (up to level 10) correctly?I'm creating a HR Core report that needs the employee exact Manager Hierarchy fields and I was using Workforce Management - Person Real Time subject area to get the Mana…
-
Can we run the OTBI Analysis from Scheduled Processes?Hi Folks, Is there any way to make the OTBI Analyses available under Scheduled Processes so that it is easy for all users to run them straight from the Scheduled Process…
-
Fetch Proposed Department and location details from transaction tablesI was able to get employee's current department and his location directly from Worker assignment Real Time Subject Area but how do i get his future/proposed transaction …
-
Unable to Connect to ADW using Oracle BI Administration ToolTrying to import metadta of ADW using the Oracle BI Administration Tool and we are facing issues while connecting Private ADW exposed to public via Load Balancer. nQSErr…
-
AP/AR Master DataHi Team, We need to pull the master vendor and customer data for both Receivables and Payables in Oracle Fusion. It should include the vendor/customer numbers, names, ad…
-
Unpivot the dataHi, Is there a way of showing date and hours worked in separate columns per person instead of the way it is on the visual below? I have tried casting and unpivoting but …
-
How to add Refund amount column in Refund listing report in OTBI report in oracle fusion.Could you please help us of how to add Refund amount column in Refund listing report in OTBI report in Oracle fusion Receivables.
-
Cast a Date field as CHAR but alter the format.Hi all, I have a Case Statement that displays a date field when a Fixed Choice List is NULL. To achieve this I have had to CAST the date field as CHAR, however the retur…
-
Work confirmation and complex po Subject area in OTBIPlease i need to know if there's a subject area in OTBI which stores the data for work confirmation for procurement purchase orders in oracle fusion?
-
How to display one record in two different languages in OTBIHi everyone, I created an OTBI report and clients want to view the output in two different languages. For example: a client creates a job request and that job is shown i…
-
Override Average weekly earning field that can be found in Absence Records in OT BIDoes anyone know if the Override Average weekly earning field that can be found in Absence Records under legislative information is available in OTBI? We know it is INFO…
-
Calculated Field in OTBI PromptSummary: Wish to have Calculated field in OTBI prompt. I want to have 3 prompts based on the given table data below: Assignment Last Update Date Grade Change Flag Grade …