Popular Tags
- OTBI 1,429
- Reporting 1,384
- FDI 1,064
- Analysis and Data Visualization 976
- BI Publisher 840
- Analysis 673
- Oracle Fusion Analytics 577
- Administration 555
- OBIEE 429
- OAC 409
- Analytics 384
- BI Publisher Data Models 346
- Security 288
- Answers 264
- HCM 256
- Analyses 253
- BIP 248
- Developers 243
- Data Modelling and Datasets 224
- Data Connectivity 208
- ERP Analytics Content 205
- BI Publisher Report Templates 201
- Report Output 183
- Oracle Analytics Cloud 170
- 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
-
Seniority Dates v3 causing issueWe are currently building a report using the "Payroll - Payroll Run Results Real Time" subject area. When we add attributes from the "Workforce Management - Person Senio… -
Alter OTBI column properties on multiple columns in one actionIn an OTBI Analysis, is it possible to change the column properties on multiple columns (without having to access column properties on each column separately) - IE; can …
-
Headcount filter by quarter end date too low and jumps aroundI want to report on headcount and FTE (also by age, grade etc.) for each department over the past 10 or so reporting/fiscal quarters. I am running an Analysis in OTBI, u…
-
i am working on OTBI report Payables Invoices - Transaction real time Subject areai am working on OTBI report Payables Invoices - Transaction real time Subject area . where i am pulling the details of Account Debit and Account Credit , accounting date…
-
How to fetch Sales Engineer column from OTBI in oracle fusion using subject areasHi, We have a requirement to fetch the sales engineer column from Leads page using OTBI Subject areas. But we are unable to fetch the sales engineer column using subject…
-
Dunning History report showing letters sent based on InvoiceHi All, Do we have any seeded report or real time area where we can find history of dunning letters sent or at what stage dunning letters are based on Invoice. I have qu…
-
OTBI - How to create Drill Down with custom data model reportsHi everyone, I’m working with two custom Data Model Reports in Oracle BI Publisher, and I’d like to know if there’s a way to drill down from one report (Project) to anot…
-
What is the difference between Archiving and Downloading BI objects?What is the difference between .catalog and .xdmz/.xdoz BI objects, the archive and download options thru OTBI (/analytics) and Oracle Analytics Publisher (/xmlpserver)?…
-
Is there a field in OTBI to tell if a Receipt was created in Redwood vs Classic page?Im looking for a field in OTBI that I can use to develop a report to identify if a Receipt was created in the new Redwood Expected Shipments Lines page vs the Classic Re… -
How do I change YTD to FYTD in a measure column?In the General Ledger Transactional Balances Real Time, there are measures for "Entered YTD CR" and "Entered YTD DR". This gives totals for the calendar year. How do I u…
-
How to restrict OTBI reports data not to send to external mail idsUsers are able to access and schedule OTBI reports. We want to restrict not to send users to external email domains other than organization domains.
-
Item Description error from Dashboard Promptcurrently working on Purchase history dashboard , using subject area- Procurement -Purchasing real time , when we are searching with item description (long item descript… -
How To Set First Day And Last Day Of Previous Month As Default Value For Parameters?Hi everyone, I’d like to know if there’s any way to set the Default Value of a Parameters date field to automatically get the first and last day of the previous month, o…
-
Update “Contact Us” Section Contact Details in Journeys Checklist TemplateHi, In Oracle HCM Journeys (Checklist template → Display Settings), the “Contact Us” section by default shows the contact details of Payroll and other HR roles. Currentl… -
Need 'PO First Approved Date' in the OTBI Subject AreaPlease guide me where we can find in report “PO first approved date”. Because the current reporting is completely wrong since it is always giving the “PO last approved d…
-
Retrieve only managers with at least one report having a specific legal entityHello experts, we would like to create an OTBI report with a list of managers (only managers name and person number). In particular we would like to retrieve only manage…
-
PVO for BICC SYNC - columns - TXN_XFACE_CTRL_ID and USER_BATCH_NAME Table PJC_EXP_ITEMS_ALLlooking for PVO for BICC SYNC having columns TXN_XFACE_CTRL_ID and USER_BATCH_NAME from Table PJC_EXP_ITEMS_ALL. Please help.
-
Need to restrict the User password updating field in one of the custom reports.We have one custom report for the User Access where in the report only roles added and deleting information needs to be shown along with the updating date. But along wit…
-
BICC : Reset Last Extract Date at PVO LevelSummary To allow users to reset Last Extract Date to a specific date at PVO Level instead of the current across all offerings level Content Currently there are two ways …
-
Some AP invoices are missing in the OTBI Payables ReportHi Team We have created OTBI report in Payables. In that report we have given three parameters 1) Accounting period 2) Supplier 3) Business Unit. If we download the repo…