Popular Tags
- OTBI 1,428
- 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 407
- Analytics 382
- BI Publisher Data Models 346
- Security 288
- Answers 264
- HCM 256
- Analyses 253
- BIP 247
- 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 168
- 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
-
MATERIALS REQUIREMENT TOTALHello and good day! Dearest Oracle Community friends, I am trying to create an OTBI for materials requirement below, would anyone know how to create the formula for tota… -
OTL Audit Report HelpI am trying to create an analysis in OTBI to show the different versions of an employees timecard. I need to see the trail of the changes and when they were done. We are… -
Is there a way that a BI Administrator can archive/unarchive a specified user's catalog items?I have the BI Administrator role and can see the entire user base of My Folders. However, I cannot drill down to see reports nor do I have the capability of archiving/un…
-
Outer Join OTBI - Vacant PositionsSummary: I am trying to produce an analytic that can show the number of "Vacant" positions. The analytic requires two subject areas and I believe I may need an outer joi…
-
OTBI FOR TRACEABILITYHello and good day! Dear Oracle Community friends, I would like to create an OTBI for traceability using the review completed transactions function. Would you know what …
-
Is it possible to write log files for Custom ESS BIP jobHi Oracle Experts, I can define outputs in different formats for Custom ESS BIP Job, can you let me know whether it's possible to write log files for Custom ESS BIP job …
-
OTBI skills proficiency levelHi all, We need to take the gap between the Proficency Rating and the Required Proficency Level for the employees. We are looking for this fields in the OTBI: We are usi…
-
Submit a document of record request via the REST APIHi Team, there is an issue I encountered while working with the document record. When attempting to submit a request via the REST API, I noticed that the request appears…
-
Single select in VBCS Does it display the value in LOV when selected from the table dataI have a scenario when I do a Row select in a table It should navigate to a new page and display the selected value in the table from the list of values in the single se…
-
How to enable Customer ALIAS or LEGAL Names in Receivables?Hi Experts, Can you please let us know if we have any option to enable Customer ALIAS or LEGAL names in Receivables UI? Thank you,
-
I need to add the termination action to the standard resignation notification titleI have open an SR in oracle support to edit the resignation seeded notification to edit the title to reflect the action name after following the documents the result was…
-
How to get the correct last update date in the "Workforce Health and Safety Incidents" module?Good morning, some analysis have been developed on the subject area "Environment Health and Safety - Incidents Real Time" to extract the information in delta to feed the…
-
oracle fusion pre built BIP reports how to check source of data Modleoracle fusion pre built BIP reports how to check source of data Modle For example : Pre built reports for manufacturing module : Shared Folders/Manufacturing/work Defini…
-
Home Address changes - Data model/SQLHello, I've worked on a report that includes the employee's former address and current (new) address when a change has been entered in HCM. My SQL skills are kind of cru…
-
Required SQL to fetch the Unpaid Invoice amount with respect to Installment wiseWe need to display the gross unpaid installment amounts of the invoice totaling 1500, which consists of three installments due on May 15, 2024 (900), May 30, 2024 (300),…
-
How to merge rows if their 2 columns are the same in OTBI Analysis?Hello, I have an analysis where I'd like to merge multiple rows if they share the same value for "Item Description" and "Unit Price". Example: | Item Description | Unit …
-
Hi, I was trying to customize the lay out of SA Payslip seeded report.they want to customize the area that reflect the salary information so if the specific value of element equal to zero the hole area won't reflect. I tried to add conditi… -
How to extract and update fusion approval groups via get API request or any other web servicesI am building a web application to be integrated with Oracle Fusion. One of the key data I need is the approval groups that are defined in the BPM worklist. Is there a w…
-
how to freeze panes (Column) in Oracle Fusion OTBIIs there a functionality to freeze Columns in OTBI?
-
Issue with OTBI Subject areasI am trying to add one more subject area to the 'Workforce Career Development - Development Goal Overview Real Time'. I didn't find any proper fact column related to 'Wo…