Popular Tags
- OTBI 1,427
- Reporting 1,383
- FDI 1,061
- Analysis and Data Visualization 976
- BI Publisher 840
- Analysis 672
- Oracle Fusion Analytics 577
- Administration 555
- OBIEE 429
- OAC 405
- Analytics 382
- BI Publisher Data Models 346
- Security 288
- Answers 264
- HCM 255
- 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
-
How to use the Order Management Extension to retrieve attribute information using Standard Lookup?We need to retrieve attribute information using standard lookup, but there are errors occurring during the retrieval process. Code: import oracle.apps.scm.doo.common.ext… -
Exportable listing of all DFFs, DFFs names, and the Oracle assigned BI label nameExample: DFF defined at a journal line level Configured Prompt: Item Sku Number Key Value Oracle Assigned BI Label: ITM_SK_NBR_K_V_ How do we get a clean extract/export …
-
How to get the number of pages in report output (docx)Hello! Simple task has proven to be too complicated. I have a rtf template to generate report in docx format and in that report I need to show the total number of pages …
-
Fixed Assets - Asset Transactions Real TimeIn fixed Asset Subject Area (Fixed Assets - Asset Transactions Real Time), When I am pulling the data from two folders , it is showing the error as The specified criteri…
-
How to rename Sheet1, Sheet 2....to custom names as per Business User requestsHi, Business Users requests to display custom names for Sheet 1,Sheet 2.... in the excel output rendered from BI Publisher. How do I achieve it. I am creating the report…
-
How to add the number in BarChart in OTBISummary How to add the number in BarChart in OTBI Content I have created the Graph in OTBI, Pie chart and barchart but values is not showing on the charts . Like attache…
-
How to restrict access to HCM factory delivered shared folders to non-HR users.We want only the HR users to be able to access the HCM reports that are delivered by Oracle. Currently we were unable to change any permissions for Shared Folders. How t…
-
second subject area selected columns values are being null in OTBIwhen join procurement - Requisition real time with product management - item revisions subject areas, columns selected from product management - item revisions are being…
-
Schedule Report - 7 Days each MondayHello I've created a report with all tabs and modified them as needed. I'm to the point that a I need to create a formula potentially, via cloud R&A. We used to have ope…
-
Distributed Order Orchestration Extensible Flexfields PVOHello, we would like to build some analysis using order header and detail extensible flexfields. I have searched the documentation for existing PVO's for this purpose bu…
-
metadata file for the PO Header and PO Line DFFsCan you provide a sample extract or schema definition for the PO Header and PO Line DFFs that lists both the column names and their data types? FscmTopModelAM.POLineDFFP…
-
How do I report the total contractual working hours for a group of staff over a period of timeHello all, I have been asked to report on the total number of contractual hours (working Hours) for a group of staff (based on Job Role type) in a department over a peri…
-
Parameters field not populated in the bursting output excel fileThere is a custom report with two different datasets, with Excel template, client requested with to schedule the custom report daily to show the parameters(which we are …
-
Person Costing Details Export Using OTBI Subject AreaHi Experts, We have a requirement to extract employment and costing details for a person. We have used the following subject areas: Worker Assignment Real Time and Payro…
-
"Manage Map Data" For OTBI Dashboards and AnalysesHow to visualize the OTBI analysis output in "Map" view? After following the steps from https://docs.oracle.com/en/cloud/saas/otbi/otbi-admin/set-maps-dashboards-and-ana…
-
In the AOR Subject Area, why is my Last Update Date and Last Updated By values being overwritten?I am unsure as to why the Last Update Date and Last Updated By values are being overwritten in my OTBI report. My AORs are still assigned correct, it just appears that a…
-
Password Protect Scheduled OTBI Excel AnalysisSummary Question on whether it's possible to add a password to OTBI output Content Hi, I'm looking to add a password to the output produced by OTBI Analysis (excel forma…
-
Report on Application Prescreen and Disqualification QuestionsIs it possible to report out on Prescreen and Disqualification Questions? Anything as simple as the count of applicants who answered a question with 'yes' and how many a…
-
I see a table in ALL_TAB_COLUMNS, but when I try to query to table it says it doesn't exist.So I was looking for a table and I could see it in the ALL_TAB_COLUMNS using this query: SELECT DISTINCT TABLE_NAME FROM ALL_TAB_COLUMNS WHERE TABLE_NAME = 'ase_app_role… -
Oracle Fusion - OTBI Pivot Table - Display as a PercentageHi, Looking for some guidance on an OTBI Report using a Data Model sql where the report layout is a Pivot Table and displaying Percentages. Oracle Fusion - Report and An…