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
-
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…
-
Person Legislative Information Field Teacher Reference Number no longer showing dataSummary: After 24c was implemented on our Production environment we noticed that one of the fields in the subject area was no longer producing any data. The field in que…
-
OTBI: Replace Line Feed characters from CLOB columnCLOB column contains line breaks in html. We tried following function which works only if CLOB column character length is less than 4000. REPLACE(REPLACE(REPLACE(CAST("P…
-
subject area to fetch Assignment status all column details in OTBIHi, I am looking for subject area which can be used to fetch the details available w.r.t assignment status under "Workforce structure".the details should be like the all…
-
Report with Question and answer of candidates. Source of JobSummary: We have partners whom we asked to do job scraping from our own orc career sites. We are not using the delivered Source Section to identify the source of the can…