Popular Tags
- OTBI 1,432
- Reporting 1,386
- FDI 1,087
- Analysis and Data Visualization 981
- BI Publisher 845
- Analysis 676
- Oracle Fusion Analytics 579
- Administration 555
- OBIEE 432
- OAC 426
- Analytics 395
- BI Publisher Data Models 350
- Security 291
- Answers 264
- HCM 257
- Analyses 254
- BIP 253
- Developers 244
- Data Modelling and Datasets 226
- Data Connectivity 211
- ERP Analytics Content 208
- BI Publisher Report Templates 204
- Report Output 184
- Oracle Analytics Cloud 177
- Customizing Reports 159
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
-
Combining Project cost (Subject area) with General Ledger - Journals Real TimeHas anyone ever successfully created an OTBI report with Project - Costing Real Time and General Ledger - Journals Real time? Having some issues with the values. Thanks -
Hi, wanted to know if in W2 form we have any box id, if yes in which table it gets stored?I wanted information on if we have any box ids for W2 forms? If there are any such ids, in which table do they get stored?
-
How do I display Years in drop down list without the decimals?When I set the default to show as the current year it doesn't show with the decimals (second screenshot), but when I go to select the other values they display with deci…
-
OTBI: Find the number of Working/Business Days between two dates and exclude Public HolidaysSummary OTBI: Requirement to find the number of Working/Business Days between two dates, therefore the calculation must exclude days that fall on Weekends or Public Holi…
-
How to consolidate several rows in one line in OTBI Pivot table?Hi All, Thank you in advance for your assistance. I have a query regarding the OTBI report I was working on for asset depreciation. I was wondering if it is possible to …
-
How to add a calculated column in OTBI Pivot Table ?Hi All, Thank you in advance for your help and support. I have a query regarding the OTBI pivot table. I was wondering if there is a way to add a calculated column to th…
-
BI Publisher desktop Not working with Office 365I installed BI Publisher desktop 32bit and 64 bit on office 365, but both are not working, I am unable to see BIP Addin in office tool Bar, I tried to to enable the AddI…
-
Pivot Table in RTF - BI ReportHello I have pivot table report and that works fine. I have to add a url (in another xml tag) to be hyperlink of the across field of the pivot. I tried following but it …
-
Bursting output file name character limitContent Hi, I have defined Bursting Output file name in the query as below- LegalEntityName || BusinessUnitName || 'Report' || To_CHAR(SYSDATE,'YYYYMONDDHH24MISS','NLS_D…
-
Option to get the Permissions associated with BI reportsWe have noticed that few of our BI reports have permissions which are incorrect and we would want to anlyze all the BI reports and their permissions to correct the same.…
-
How to add sql query to OTBI filterI want to create an OTBI analysis that gives data between last 7 days. I tried creating a filter using SQL expression but it doesnt work. Can someone pls help with the r…
-
Where to find access and visibility information within the learning subject areasHello, we need to develop, within the learning module, two infolets relating to the editions to which managers can enroll their subordinates, and the editions to which p…
-
-
What's the column name for Requisition Number under Inventory Transfer Order Real Time subject area?I'm creating an OTBI report to pull open interorganization transfer orders and link the Requisition number from source org. These details are showing in 'Manage Transfer…
-
What's the column name for Requisition Number under Inventory Transfer Order Real Time subject area?I'm creating an OTBI report to pull open interorganization transfer orders and link the Requisition number from source org. These details are showing in 'Manage Transfer…
-
Notice on Deprecated PVOs in BICCCIn our solution we use normal PVOs and Extract PVOs, we observe that document available for Extract kind of PVOs . We load data by scheduling in BICCC. Can we continue t…
-
How to convert PO ordered amount in USD (Conversion type as SPOT)We are creating an analysis using 'Procurement-Procure to Pay Real Time' where we need to convert and display PO amount in USD. Using the conversion tyoe as SPOT. I coul…
-
When BIP report has an output of excel, how to adjust the cell size to fit the contents?Hello Oracle Gurus, Request your assistance. When creating the excel template, I normally increase the size of the cell. But sometimes there is data larger than expected…
-
Report for scheduled ProcessSummary Required Report to pull details of Scheduled Processes Content Hi Experts, I would like to know is there any seeded report or query available to pull the details…
-
How much time it will take to update the data in Archive table?We can get the requirement Invoice information from FND_BPM_TASK_HISTORY_B table which is an Archive table and recommended by Oracle as workflow tables would get purged …