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 453
- OBIEE 433
- Analytics 402
- 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
-
Item Description error from Dashboard Promptcurrently working on Purchase history dashboard , using subject area- Procurement -Purchasing real time , when we are searching with item description (long item descript… -
How To Set First Day And Last Day Of Previous Month As Default Value For Parameters?Hi everyone, I’d like to know if there’s any way to set the Default Value of a Parameters date field to automatically get the first and last day of the previous month, o… -
Update “Contact Us” Section Contact Details in Journeys Checklist TemplateHi, In Oracle HCM Journeys (Checklist template → Display Settings), the “Contact Us” section by default shows the contact details of Payroll and other HR roles. Currentl… -
PVO for BICC SYNC - columns - TXN_XFACE_CTRL_ID and USER_BATCH_NAME Table PJC_EXP_ITEMS_ALLlooking for PVO for BICC SYNC having columns TXN_XFACE_CTRL_ID and USER_BATCH_NAME from Table PJC_EXP_ITEMS_ALL. Please help.
-
Need to restrict the User password updating field in one of the custom reports.We have one custom report for the User Access where in the report only roles added and deleting information needs to be shown along with the updating date. But along wit…
-
BICC : Reset Last Extract Date at PVO LevelSummary To allow users to reset Last Extract Date to a specific date at PVO Level instead of the current across all offerings level Content Currently there are two ways …
-
Some AP invoices are missing in the OTBI Payables ReportHi Team We have created OTBI report in Payables. In that report we have given three parameters 1) Accounting period 2) Supplier 3) Business Unit. If we download the repo…
-
While creating a credit memo in oracle fusion in credit transactions i am facing the below error.You can't overapply this transaction. (AR-855287) The transaction type assigned to the transaction doesn't allow overapplication. You can only apply a credit or receipt …
-
Need backend query to fetch audit details of Job profileHi, We have enabled audit for jobs and trying to fetch the job profile details through BIP Report who, when and what are the changes that are made but somehow we couldn'…
-
Using report parameter to call different excel template in different layoutHi, We have an requirement from our client. They have more than 10 RTF different template for a report. When the user run the report, user have an option to choose which…
-
Is there a way to find all data models using a specific field?I asked Oracle this question years ago (and the answer was no), but I wanted to check again with this group to see if anyone found a way to accomplish it. We need to fin…
-
OTBI analysis - problem with left outer joinHi, I tried this query but it seems that it's not working. It's throwing an error (Formula syntax is invalid). I'm using this query to determine if employees have submit…
-
OTBI - SHOW ONLY SUBTOTALHello and good day! Dearest Oracle community friends, Is there a way to show only the subtotal in OTBI? Hope to hear in the community with solution on this. Thanks and b… -
What subject area or field to display the corrected amount for Service POs in OTBIWe are using the subject area Receiving - Purchase Receipts Real Time to display PO Receipt information. We are using the field Receipt Amount to display the amount rece…
-
How to remove extra spaces from file generated from BIP reportI have tried unchecking , still generating these characters in the front for each row.
-
Unable to view VETS4212/EEO1 Output in OTBIHello experts, We have setup VETS4212/EEO1 reporting in our Dev environment according to the documentation provided: EEO-1 Establishment Electronic Report VETS-4212 Esta…
-
Subject Area: Payroll - Personal Payment Details Real TimeHello, Could anyone help or confirm if the Subject Area: Payroll - Personal payment details real time can extract the Account Suffix for our Personal Payment Method? Cou…
-
Field Location Help (License/Cert - Item Code )Summary: I am trying to add the 'Item Code' for license/certifications. I have gone through all the fields under Workforce Profiles - Person Profile Real Time related to…
-
-
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…