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 406
- 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
-
UK PAYE Scheme Reference Number LocationI am attempting to output the PAYE Scheme Reference from the Payroll - Calculation Cards Real Time Subject Area but am unable to locate the column header. Can anyone adv… -
OBTI report for Maintenance programFor a Maintenance Program forecast i want to make a OTBI report that anyone can easily understand the activities. The built-in Program Gannt chart is very difficult to u…
-
Generate report for Transactional tables in API want to create a data extract for transactional tables (AP_BATCHES_ALL, AP_CHECKS_ALL, AP_INVOICES_ALL etc). I cannot find the Views for these tables in Financials to … -
I am trying to build an OTBI report that shows PRS with the statusI am trying to build an OTBI report that shows PRS with the status, if it's pending approval i need the name of the current assignee Is it applicable by OTBI ?
-
Where to find Postgraduate Loan InformationI am attempting to extract Postgraduate Loan information in OTBI and have gone through every header (and some contents) in the Subject Area Payroll - Calculation Cards R…
-
Creating Custom PVO's on oracle fusion custom tables for BICC jobsIs there any process to create Custom PVO's on oracle fusion custom tables to export data using BICC connector. If yes, what are permission roles required to develop.
-
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…
-
OTBI Analysis for history recordsHi Team, Is it possible to create a dashboard in OTBI analysis where I need to check the transfers, promoations, location changes happened in the last 12 months every mo…
-
How to add a new columns in OTBI subject area?Hi Team, How do we add a new column in the OTBI subject area not present in the existing model?
-
Date format parameter on excel reportHi I have an OTBI report with excel template; on the template there are 2 parameters that contain date inserted from user. The date format of the parameter is : dd-MM-yy…
-
Can we restrict an OTBI Analysis report so that only users with a specific role can run it?Is there a way to set permissions on an OTBI Analysis report so that only users with a specific role. Example We have used the Subject Area Project Costing - Unprocessed…
-
Seeded Report to track User's last login in Oracle Fusion 24CHi Team, Is there any Seeded Report to track User's last login in Oracle Fusion 24C? Appreciate your responses.
-
-
Issue while creating Data Model with HTTP POST Method in OTBIWhen attempting to run a data model in Oracle Transactional Business Intelligence (OTBI) that utilizes an HTTP dataset, an error occurs indicating that no response is re…
-
In OTBI How to set TIMEZONE using Data format setting properties?When we change the column properties in the Data Format tab regarding the TIMEZONE, it always reverts to the default setting. We cannot set the timezone as required. The…
-
Migrating an OTBI Dashboard to another instances gives errorI have an OTBI dashboard that is working in an instance. However when I migarte to another instance I get lot of SQL errorrs. Some ofthe errors are Code: 43113. [nQSErro…
-
HCM Extract failing with error "user: fusion_apps_hcm_ess_appid, permission: 2240"HCM Extract failing with error, please let me know how to resolve this issue: ================ BIPJobExecutable Execution failed with Client received SOAP Fault from ser…
-
Performance when extracting journal entriesI am having trouble with poor performance when extracting GL journal entries. The number of journal entries is about 5 million per month and it takes a long time to outp…
-
Report UsageI've been tasked with establishing a report catalog for my company that shows reports used by the company and organized by functional area. I first need to identify repo…
-
We need to insert audit actions in role reports according to cons sec. Wich table is appropriate?This is SQL code --**FUNCIONARIOS ATIVOS PARA A------------------------------------ SELECT DISTINCT PU.USERNAME AS "USUARIO" ,PPNF.FULL_NAME AS "NOME COMPLETO" --,ROLL.E…