Popular Tags
- OTBI 1,401
- Reporting 1,365
- FDI 961
- Analysis and Data Visualization 953
- BI Publisher 816
- Analysis 663
- Administration 553
- Oracle Fusion Analytics 543
- OBIEE 421
- Analytics 342
- OAC 336
- BI Publisher Data Models 335
- Security 271
- Answers 261
- Analyses 253
- Developers 240
- HCM 237
- 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
-
Pull a report of OTBI User Folder AccessSummary We need to be able to pull a report of all user access to all OTBI folders. Content We need to be able to pull a report of all user access to all OTBI folders. T… -
Deep Links (23B) the complete overview (all of them)We all know that you can create Deep Links from your OTBI / BI Publisher (incl notifications), otherwise check here Creating Analyses and Dashboards in Oracle Transactio…
-
Benefits - Enrollment Real Time - Dependent Data Not Coming InWe have a basic report that is supposed to bring in Employee and Dependent data into a report and now the report is not reporting on Dependent Data anymore. Either none …
-
How to change the week definition to ISO-8601 (1st day of the week being a Monday)In OTBI the week definition is using the American standard, Week = Sunday - Saturday. But in Europe we do use ISO-8601. Week = Monday - Sunday. Also week number itself c…
-
In the AOR Subject Area, why is my Last Update Date and Last Updated By values being overwritten?I am unsure as to why the Last Update Date and Last Updated By values are being overwritten in my OTBI report. My AORs are still assigned correct, it just appears that a…
-
Table for employees role history.Is there any table or related table in HCM that stores historical role assignment data and transaction data, and timestamps history for an employee?
-
unsupported report object's type - [catalog]Currently we are using the following webservice to upload a report into BI Publisher https://fa-exsj-test-saasfaprod1.fa.ocs.oraclecloud.com/xmlpserver/services/External…
-
Need translated names in the otbi report.we have developed otbi report for Workforce Structure for one of the UAE client, in that customer requires translated names to be reflected along with the English names.…
-
Need help with your site display name?Hi OA Community! Have you updated your profile to show your name, but are still seeing a generic ID? If so, message me and I'll fix it for you. There's an intermittent s… -
Fixed Assets - Clarity on Depreciation Source CodeWe are currently implementing Fixed Assets in Oracle Fusion ERP and would like assistance from FA SMEs as we have begun work on OTBI dashboards and reports: In the Fixed… -
How to query fusion tables in SQL developerSummary: We have a data model to select the email_address_id from fusion.PER_EMAIL_ADDRESSES but we want to be able to query this table or data from this table (or IRC_C…
-
Turnover by Ethnicity - Report AssistanceSummary: We are currently running into issues creating a Turnover report by Ethnicity due to how ethnicity is handled in Oracle. This is causing employees to be duplicat…
-
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…
-
OTBI link Receivables Customer Real Time to Transactions Real TimeHi- Financials Receivables Cloud BI Using the Real Time Subject Areas how can I get a list of all Customers & their Details (Sites, Accounts, Contacts, Addresses) and de…
-
OTBI Analysis result via SOAP request/response with proper column namesHi, I am using OTBI and I have created an Analysis. This works great. Now I want fetch the result via a SOAP call. This also works fine. I use the XmlViewService and the…
-
Unexpected Language Variation in Data Extraction - BIP ReportHi community, We are experiencing an unusual behavior with the "Environment Health and Safety - Incidents Real Time" subject area in a BI Publisher (BIP) report regardin…
-
Monitoring and analyzing HCM workflow email bounces--Please advise if this post belongs in a different forum-- As we know, bursting emails is possible in BIP, and OTBI provides bursting via agents. Recipients receive mes… -
DFF fetching only code in OTBIWe have many DFFs configured in HCM. On front end HCM, we can see the full description eg for local job title, but in OTBI the field only returns the job code. Is there …
-
Question on Using Semantic Modeler for Hybrid Data Sources (Fusion Procurement and ADW)Hello Group, Our analysis currently spans multiple topics, with data sourced partly from Oracle Fusion Subject Areas and partly from external data in ADW (Autonomous Dat… -
Cycle Time Analysis from Fusion Subject Area for NegotiationHi Group, Currently we're using Fusion Subject area to analyze RFQ Cycle time, and we'd like to fetch the time that the Buyer send the RFQ to approve, which status is ch…