Popular Tags
- OTBI 1,432
- Reporting 1,386
- FDI 1,087
- Analysis and Data Visualization 981
- BI Publisher 844
- 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
-
How can I build a "read only" role for Payroll run results? I also need one for Time & Labor...We have users in our organization that need access to the results of the payroll run (earnings, deductions and taxes), but are not allowed to do the payroll related proc… -
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… -
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…
-
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…
-
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…
-
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 …
-
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…
-
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 …
-
OTBI Logical SQL complex query assembler - Updated to 10 subject areasSummary Combine analyses from up to 10 different subject areas Content While building a report on OTBI, you will encounter some cases where the Subject Area will only pr…
-
OTBI Assignment Event Future dated positions missing position name/codeI have a report that is picking up assignment changes in the last week, which is based on the subject area Assignment Events Real Time. For future dated changes to an as…