Popular Tags
- OTBI 1,428
- Reporting 1,383
- FDI 1,062
- Analysis and Data Visualization 976
- BI Publisher 840
- Analysis 673
- Oracle Fusion Analytics 577
- Administration 555
- OBIEE 429
- OAC 407
- Analytics 382
- BI Publisher Data Models 346
- Security 288
- Answers 264
- HCM 256
- Analyses 253
- BIP 247
- Developers 243
- Data Modelling and Datasets 223
- Data Connectivity 208
- ERP Analytics Content 205
- BI Publisher Report Templates 201
- Report Output 183
- Oracle Analytics Cloud 168
- Customizing Reports 156
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
-
Subject Area -- Custom Column Formula IssueWe have an analysis built off of "Workforce Management - Accrual Real Time" joined to "Workforce Management - Work Relationship Real Time." Results return on a data tabl… -
How to customize self Service Licenses to have drilldown capabilities to access OTBI & drilldown?When a Self-Service user with a Self-Service license uses our AR Inquiry tool (custom report built for Self-Service AR) in OTBI, they cannot drilldown into the transacti…
-
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…