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
-
OTBI Subject area - Query for Work DaysIs there a subject area where we can find the employees Scheduled work days and any leave planned on those days any help would be appreciated. -
OTBI Subject area - Query for Work DaysIs there a subject area where we can find the employees Scheduled work days and any leave planned on those days any help would be appreciated.
-
Current Year Promotion ReportI want to get the promotions of current year in OTBI report, I am getting it but the if there is any action after promotion then system is not picking that employee reco…
-
Issue with multi-select filter in reportI'm developing a report and encountered a problem when trying to select items in a filter. In its current configuration, I can extract either ONE specific item or ALL it… -
How to create ess job that will directly use the parameter of the data model?Hello, We have an analysis that we wanted to be available in the Scheduled Process. Since we cannot link the Analysis itself to the ESS job report job ID, we tried to re…
-
How to query PVO in Oracle BI Publisher Data ModelI need to query PVO data in BI Publisher, here's the PVO name: HcmTopModelAnalyticsGlobalAM.HcmElementSetupAM.ElementEntryValue Any screenshots, ideas, hints? Thanks.
-
Client cannot view report dataI have create a report BIP with data model but when the user execute it the result is empty when I can see data example: My user view: Customer view:
-
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 …