Popular Tags
- OTBI 1,360
- Reporting 1,350
- Analysis and Data Visualization 895
- FDI 879
- BI Publisher 787
- Analysis 652
- Administration 542
- Oracle Fusion Analytics 535
- OBIEE 415
- BI Publisher Data Models 321
- Analytics 309
- OAC 270
- Answers 259
- Security 253
- Analyses 251
- Developers 234
- HCM 219
- BIP 212
- Data Modelling and Datasets 208
- Data Connectivity 205
- ERP Analytics Content 192
- Report Output 178
- BI Publisher Report Templates 177
- Agents 148
- Customizing Reports 141
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
-
BI FTP Server setup screen missing Test connection buttonI am trying to 'Add Server' under Manage Publisher > FTP. The screen allows me to input all the details but 'Test Connection' and 'Apply' buttons are missing. I have emp… -
Report 2x - 5xing values when using the hierarchical tiersI'm having issues trying to get the right data when using the object 'Level 22 Value' in Natural Account Segment under the General Ledger - Transactional Balances Real T… -
Display of Total Row Cell at the Top of the Data TableIs it possible to display the Total Row Cell at the top of the table instead of last row in the data table. Currently, there are only 2 options displayed when hovering o…
-
R13.x Deprecated and New BI View ObjectsSummary This posting includes R13 deprecated Business Intelligence View Objects (BIVOs) that are unavailable for extraction using BI Cloud Connector (BICC) in Oracle App…
-
How to use multiple aggregates In OTBIHello, I am brand new to OTBI, and am having a little bit of difficulty providing the analysis that my business is requesting of me. The end result should look like this…
-
Logical SQL analysis- Prompt error -Failed to load(Error during query plrocessing (SQLExecDirectW).)Dear experts, I have created a logical SQL analysis and created column prompt for Requisition Number and getting below error, it is displaying the results when i go to r…
-
Where can i find incumbent details dates allocated in position through Subject Area OTBI?We created BI using the subject area” Workforce Management – Position Real Time” , but don’t find the “Position Entry Date” and “Position Exit Date”
-
Workforce Management - Worker Assignment Real Time: pulling Active and inactive assignment statusesHow to get the current assignment status of worker using "Workforce Management - Worker Assignment Real Time" , it is showing both inactive and active assignment statuse…
-
OTBI - Exported XML Data Model is not show in lower caseHello When exporting a report in XML format through BI, the XML tags are in upper case and not lower case. Please could you confirm if this behavour system?
-
Need to get referrer Job Title and Referrer assignment status in OTBIWe are using "Recruiting - Recruiting Real Time" subject area to get Requistion number, requistion title, referrer person number, referrer person name, worker person num…
-
Data Limit/size when we use BIP Report by calling SOAP Web Service in Fusion OIC layerWe are planning to Use BIP query to get the data from Fusion Order Management and Receivables by Sales order within OIC integration. We are storing batch number in ATTRI…
-
OTBI Usage and Performance Dashboard SampleReal Time OTBI Usage & Performance Two subject areas are available to monitor OTBI usage and performance: OTBI Usage Real Time: Monitors OTBI usage, including user, anal…
-
Trying to combine pay elementsHi I need to do a report that provides a total of a calculated field based on a specific pay element, and have had to strip this PE out of the input values of the other …
-
Hey team I want to create an OTBI reportwhich could pull up the additional info column details from payroll relationship. I have a screenshot showing three fields, and I need to populate their values along wit…
-
Deprecation risk for HCM Benefit PVOs?We are using below PVOs for extracting data for benefits from HCM Cloud. As these are not white-listed for FDI: can you please confirm if in the future these PVOs will n… -
Dashboard with analysis tested OK in Test environment, but no results in Production environment.Hi Experts, Please refer to the following screenshots. I got this situation that I have created a dashboard (composed by a dashboard prompt and an analysis report) to re…
-
Original Author of a DashboardIs there a way to determine the original author of a Dashboard within the Oracle Fusion Catalog after someone modified the ownership of the item? If this isn't possible …
-
what subject area can you report on DFF's on termination recordWe have added a DFF to the termination card under PER_PPS_DF and would now like to report on it in OTBI, which subject area can we do this from?
-
Is it possible to edit the "retirements" formula in Fixed Asset Balances Real Time?I put the "retirements" field in my report, but they are considering SOURCE_TYPE_CODE = RETIREMENT and ACCOUNT_TYPE = COST, DEPRECIATION_RESERVE e TRUE_DEPRECIATION_RESE…
-
PO Layout - Table HeaderHi, I would like to add new column in to my table in PO Layout. When i did it i have received an answer from the system as below ct = "//location.language/> I expect tha…