Popular Tags
- OTBI 1,447
- Reporting 1,394
- FDI 1,123
- Analysis and Data Visualization 988
- BI Publisher 855
- Analysis 682
- Oracle Fusion Analytics 591
- Administration 555
- OAC 453
- OBIEE 433
- Analytics 402
- 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
-
Seeded Learning Dashboard designsHi Team, We have a new requirement to develop a new learn dashboard. However, we would like to understand what oracle offered for customers. Can someone share seeded pat… -
How do I show 1 row per employee based on ranked address typeSome employees have multiple address types on file. I am trying to show 1 row per employee based on address type. I want it show home address (address rank 1) but if non…
-
What privilege grants access to data in the Purchase Order Measures folder columns?I have a user who is trying to use columns from the Purchase Order Measures folder in the Procurement - Procure to Pay Real Time subject area. I've created a custom role…
-
Supplier Registration Analysis?Hello, Has anyone ever used OTBI to create an analysis showing info on suppliers, specifically which have access through the iSupplier Portal, and which are able to crea…
-
Report retrive data well by user who developedHi We have A Report RTF template work fine and retrive data when opened by user who developed the report while not working by any other user
-
Access procurement approval workflows in OTBIHello, Is it possible to access the requisition/order approval workflows to add into an OTBI analysis, the people that a requisition/order is pending to be approved? Tha…
-
SQL query for retrieving information from Work Definitions TableWe are having issues identifying the relevant table for work definitions and their associated operations/resources. Can anyone provide a query (or give some direction) o…
-
PER_SHARE_INFORMATION table not returning any dataI came across the following code in one of the seeded query, but it isn't returning any data when executed. Could anyone help me understand what information is supposed … -
Displaying the Receipt Date for the Purchase Order in PO Details ReportSummary Displaying the Receipt Date for the Purchase Order in PO Details Report Content Hi , I have PO Details Report with the following fields. PO Number, PO Date, PO S…
-
What is the use of FlexFields in Oracle BIPHello Expert, I'm learning BIP, and I want to learn how to use Flexfield in an Oracle BIP parameter. Can anyone explain end to end with an example.
-
BIP Keep rows grouped together so they don't break between pagesWe have a custom PO BIP report and each record (PO line) of the PO is comprised of three rows within a table structure (for-each repeating element). The issue we're faci…
-
Issue with OTBI Report Access for Non-Administrator UsersDear All, I have successfully created an OTBI report as an administrator using the subject area "Payables Invoices - Installments Real Time", and the report is working f…
-
How to fix inconsistent positions of column?Hello, I have an odd problem with my report. When the 'activity description' column is at the end, additional columns are showing at the right. When it is placed before … -
Dependent parameters are not showing LOV'S when new custom ESS job created by copying standard ESSHi All, We have made customizations to the standard report and are currently attempting to create a new custom ESS job by duplicating the standard ESS job. The functiona…
-
How do I convert comma separated values to columns in OTBI ReportHi Team, How do I convert comma separated values to columns in OTBI Report. For eg- We have created a multiple select choice list field and data is showing in comma sepa…
-
Recommended frequency to extract the active primary keys/application dataWe are currently using BICC to extract FSCM, CRM, etc. data to build a data warehouse for analytics (one time full load followed by incremental loads). Noticed that BICC…
-
HCM - Calculate average number of goals per employeeHello, What would be the best way to Calculate average number of assigned performance goals per employee with breakdown per department? Formula needed is = Total count o…
-
Oracle Catalog Manager DownloadCould anyone please provide URL to downloading catalog manager? I have request to pull all reports using X column and found through other community posts that catalog ma…
-
OBIEE - Creating Agent from Analysis with "Is Prompted" fields - returning 0 rows.Hi, First time post here with hopefully a simple question. I have created an analysis with various prompts; on the analysis there are also 3 fields that are set as “Is P…
-
OTBI duplicate linesHi. Does anyone have any idea how to deal with duplicate lines in OTBI? The subject are we are using is Receivables - Standard Receipts Application Details Real Time. We…