Popular Tags
- OTBI 1,432
- Reporting 1,386
- FDI 1,087
- Analysis and Data Visualization 981
- BI Publisher 845
- 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
-
BI SFTP connection no longer working due to Key Exchange Algorithm DeprecationOne of our SFTP delivery configuration in Oracle BI Publisher has stopped working due to deprecation of diffie-hellman-group14-sha1 SSH Kexs on the target server. Error … -
Extract the permission/actionable actions attached to Folders/reports in catalog OTBI.The requirement is to generate a report which extracts the actionable action attached to the Folders/reports in the catalog such as Update/delete/move.
-
query to restrict Business unit and organization code in parameter prompt in OTBI as per the userHi I want to know if there is any method where I can restrict Business unit and organization code in parameter prompt in OTBI as per the user roles assigned for example …
-
Security on reporting OTBIGood morning, I hope this message finds you well. I would like to kindly ask if it’s possible to assign a user the BI Author role only for a specific group of Subject Ar…
-
Oracle Fusion Cloud Applications 24C (11.13.24.07.0) OTBI Agent A unable to run per row Agent BI have a report (A) which lists out x number of locations based on a variable (Always less than the 100 limit) I created an agent based on this report A and wish for it …
-
Query for Workflow Details of NIRHi Everyone, I am looking for the query to get workflow task details of an NIR. Please refer to highlighted part screenshot for details. I am creating a custom BIP Repor…
-
is there a report or how to create one that displays all the existing OTBI/PUBLISHER reports ?Summary is there a report or how to create one that displays all the existing OTBI/PUBLISHER reports ? Content Hello,We would like to know if there is an existing report…
-
GettingError "ORA-00904:"CPI"CLEARING_CCID":invalid identifier" while running US 1099 PaymentsreportGetting Error "ORA-00904:"CPI"CLEARING_CCID":invalid identifier" while running US 1099 Payments seeded report Need to understand the root cause for this error, Can anyon…
-
We have one requirement, where we created one OTBI report and we want to give that report access toHI All, We have one requirement, where we created one OTBI report and we want to give that report access to one of the China user. Could you please help me with the proc…
-
Calculate Due Date Using Days LateHello, I need the correct information about Days Late so that I can calculate the due date. I am not using the Receivables - Standard Receipts Application Details Real T… -
How to get the last degree if the worker have 2 records in a Analysis and ReportHi @Everyone, How do we get the last degree if the worker has 2 or more records in an Analysis and Report? We need to get the last degree considering their last start da… -
Complete a customized standard Schedule Process in 'Warning' in case of no values in custom columnsI have customized the 'Print Commercial Invoice Report' and I would like to end the schedule process in warning if two new custom columns have no values. These columns a…
-
In Seeded OTBI report "Top 10 Spend Supplier"Summary: In the Seeded OTBI report "Top 10 Spend Supplier" for the column "Addressable Spend" and "Non-Addressable Spend" where the data and calculations are coming from…
-
Help with Transaction History Report in OTBI (DUE DATE and OUTSTANDING BALANCE)I aim to generate a comprehensive report of transaction history. I need the fields DUE DATE and OUTSTANDING BALANCE of the transaction to be displayed in my analysis. Fo…
-
In Procurement-Purchasing Agreements Real Time when I add expiration date column I am getting errorError Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65PState: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. …
-
Candidate ReportHallo How can i create a report with the candidates that had attached their CV and the corrispondent line manager? Thank you
-
defaulting a value in the child field dynamically based on the parent field selection.a. When a invoice type is selected as - credit memo/debit memo/standard, then document category should populate default values which are already set. b. If this match co…
-
Please can someone provide me the SQL to split out "Worker"."Employee Mailing Postal Code" AS IncodeHi, i am tyring to use a calculated measure to split the "Worker"."Employee Mailing Postal Code" (Workforce Management - Person Real Time Folder) to show a column with j…
-
Can we insert attachment of transaction to custom report?Hi We have some attachments in the transaction, for example PO. We want to insert these attachments to custom report. How to insert these attachments? Thank you Aji
-
How to show data in rtf stacked Bar Chart when hover the mouse overI'd like to display data when hover the mouse over when run the BI report graph using rtf template. Haven't find any documentation about it. Hope there is a way.