Popular Tags
- OTBI 1,448
- Reporting 1,394
- FDI 1,123
- Analysis and Data Visualization 988
- BI Publisher 856
- Analysis 682
- Oracle Fusion Analytics 591
- Administration 555
- OAC 454
- OBIEE 433
- Analytics 403
- BI Publisher Data Models 356
- Security 293
- HCM 268
- BIP 264
- Answers 264
- Analyses 255
- Developers 246
- Data Modelling and Datasets 229
- Data Connectivity 210
- ERP Analytics Content 210
- BI Publisher Report Templates 204
- Oracle Analytics Cloud 197
- Fusion Data Intelligence 187
- Report Output 184
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
-
I need to add a date/time stamp to a task name when status is complete in PerformanceI have a performance analysis that includes the fields: "- Performance Task"."Manager Task Name", "- Performance Task"."Worker Task Name" and then it is pivoted so these… -
HRHD Subject Area Time Month formatHi Help Desk - HR Service Requests Real Time Subject Area have Time.Calendar Month field. The value is coming as '2024-12' (YYYY-MM) Format. We need to display the outpu…
-
How can I call a rest api from an bip data modelSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
OTBI Filter limitI'm working on a series of OTBI Graph Analytics and was wondering how would I go about limiting the Services and suppliers by the top 5 or top 10. I've provided my curre…
-
CE_RECON_HISTORY_ITEMSHI, I'm looking for a way to export via the BICC ce_recon_history_items table. However, it doesn't seem to be available in BICC... Or I can't find it in Rel13_23D_BICC_F…
-
trying to report on ORA_HRX_MX_CFDI_CONTRACT_TYPE in OTBIWe have this SQL which pulls this information for employees: select hl.meaning from per_all_assignemnts_m paa , hcm_lookups hl where paa.asg_information1 = hl.hcm_lookup…
-
Schedule OTBI reports to send to SFTPHello Raghu, First of all, thank you for all the content you have made available! I really appreciate your efforts. Perhaps you can respond to this question during the N…
-
Transfer BIP report Extract to Microsoft share pointSummary: Hi All, We have a business requirement to transfer the BIP report extraction to Microsoft share point. Please let me know is it feasible by writing the bursting…
-
Questions on Line Manager Dashboard Prompt LOV restrictionsWe are currently looking for a way to utilize the existing Line Manager Dashboard, In that we could see that the prompt LOV values that are displaying is not limited to …
-
Oracle OTBI maps are displaying cities in incorrect countries.As shown in the image, the city is listed as Cambridge, but despite specifying the state as Ontario and the country as Canada, it is still defaulting to Cambridge in Eng…
-
How to enable Reminder notifications and Expiration rule for specific Approval rules under Tasks?Summary: Hi Team, We are facing an issue wherein we can't see the option to send the Reminder and Expiration notifications for a specific rule under a task in BPM Task C…
-
Total After In pivot table Customize the Format labelI want to customize the auto total running in the pivot table to YTD Budget / YTD Expenditure / YTD Variance …. Does anyone knows how to make it Regards.
-
Dates on Gigs within OTBII am starting to explore the usage of gigs within my company's scope. My initial thought is to use gigs to post for positions that need coverage and to track absences & …
-
How can I get a notification on failed scheduled OTBI Job?Summary: The request is to recieve an email notification if the OTBI Job is failed. I know the option is available for BIP but how I can accomplish that for OTBI? Conten…
-
How to get the active encumbered amount in Oracle Fusion BIP reportSummary: How to get the active encumbered amount in Oracle Fusion BIP report In EBS we used the below Package to get the active encumbered amount, How to get the same in…
-
SQL Query Support Request: Payroll Run Results with Payment StatusHi, I'm using a data model to query payroll run results, but I'm only interested in the calculated amounts that were processed to payment. I'm struggling to link the res…
-
Service type in OTBI reportI have disabled/removed service type under lookup code and removed in template, but when I run the report in OTBI for the same template It still shows the service type n…
-
Need to Set Consistent Diagonal Label Alignment for X-Axis in BIP XPT Template Bar GraphsHi, We are currently creating bar graphs using the BIP XPT template and would like to know about adjusting the alignment of labels on the x-axis. At present, the label a…
-
Secured List Views and AORThe customer has a report that displays the total number of records per table. When a logged-in user views the report, they should be able to see the count of records th…
-
How to create Country Specific Context in DFF?Summary: We need to enable few fields only for Swiss Employees using a DFF and need to create Context Sensitive segments as well under the Context Value. Currently syste…