Popular Tags
- OTBI 1,406
- Reporting 1,365
- FDI 970
- Analysis and Data Visualization 953
- BI Publisher 818
- Analysis 663
- Administration 553
- Oracle Fusion Analytics 546
- OBIEE 421
- Analytics 345
- BI Publisher Data Models 335
- OAC 335
- Security 272
- Answers 261
- Analyses 253
- Developers 240
- HCM 238
- BIP 232
- Data Modelling and Datasets 218
- Data Connectivity 205
- ERP Analytics Content 199
- BI Publisher Report Templates 184
- Report Output 180
- Agents 151
- Customizing Reports 146
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
-
Concatenated values for Depreciation Expense and Depreciation Reserve AccountHi, I am working on an OTBI report and using the Subject Area "Asset Balances Real Time". I am looking for Depreciation Expense and Depreciation Reserve Account(Concaten… -
Special characters not to be used for OTBIPlease suggest the special characters that are not to be used so that data will not be synced to view data in OTBI.
-
ZMM Notes columns - SOURCE_OBJECT_CODE, SOURCE_OBJECT_UID in Receivables - Transactions Real Time?Summary: Is anyone familiar with the subject area - Receivables - Transactions Real Time? I am looking for the equivalent of SOURCE_OBJECT_CODE, SOURCE_OBJECT_UID column…
-
Converting an OTBI report to a BIP reportI have an OTBI report that is causing an access error for the user. Could we convert this report to a BIP report and remove any access restrictions to ensure it function…
-
Graph not displaying the linesSummary: Hi, I want the graph to display the lines independently of if there are employees under each rating. It is only showing the data for the ratings where there are…
-
Consume external REST API in Fusion BIPIs there a solution to consume external REST API in BIP Report and use the response as data source?
-
How to identify missing Associations in a Taxable Benefits Calculation CardHi, We have started Payrolling Benefits this tax year and have identified an issue where a Calculation Component, along with the Calculation Component Details have been …
-
OTBI Pivot Table hide null valuesHello! I would like to hide columns that have null values in a OTBI Pivot Table, for example: These are columns made of incentive compensation measure results for a sing…
-
API to run custom BI Publisher reportSummary: I need to call report via API Content (please ensure you mask any confidential information): I'm performing this API call: https://xxxxx-test.fa.ocs.oraclecloud… -
Knowledge Management Article Views- Unable to view the data for Knowledge Article Status.Hello, I attempted to run an OTBI analysis using the 'Knowledge Management - Article Summary Historical' Subject Area to retrieve data on "# of Article Views," "# of Art…
-
How to enable email bursting for Print Commercial Document Report?Hi, I was trying out the bursting method for print commercial Document process but it seems to be failing even on the slightest changes to the bursting query. I wanted t…
-
Require navigation path and calculation in OTBI Subject area 'costing - work Order Costs Real Time'In OTBI Subject area 'costing - work Order Costs Real Time', we require the application navigation path and calculation logic for the following fields: 1) Work Order Cos…
-
How to get the manager assigned to the department to show in a OTBI reportHi team!I need to add this manager to my data model, so please can you help me with what tables or code I need to add in my SQL? In my report, the column will be called … -
How to access the link between OTBI column names to fields in the Oracle data tablesI'm designing reporting using OTBI, however there may be a requirement to query the tables directly using BIP. I would like to understand, where I am selecting columns f…
-
Group By Supplier in OTBISummary: Hi! How can i "group by" the amounts of paid invoices by supplier? I need the "Gross Amount" to be summed to one cell of payment amount, or just present the pay…
-
Unable to Add More Than 5 Columns in OTBI Pivot TableHi everyone, I’m creating a report in Oracle Fusion OTBI based on a data model, and I want the report to be displayed as a pivot table. However, when I try to select the…
-
Employee Final Feedback not returning value in OTBIWe Are using the subject area Workforce Performance - Performance Rating Real time and we want to get the below columns Digital Signature Employee Final Feedback We are …
-
BICC extract failing for HcmTopModelAnalyticsGlobalAM.OrganizationAM.PerDeptTreeStructureBICVOSummary: We are getting error while extracting data from below data store. the BICC job runs for phenomenally long time and then errors out. This is happening only in on…
-
How do you keep Row Numbers cascading?When adding a Row Number Column in OTBI using RCOUNT(1), how do you prevent the row numbers from changing order when you sort the report by a different column? We want t…
-
OTBI is NOT pulling Pending Workers Licenses/Certifications InformationHello, Need some assistance here! We are trying to create a report that will pull all licenses/certifications that have been updated in the last 7 days specifically for …