Popular Tags
- OTBI 1,428
- Reporting 1,383
- FDI 1,061
- Analysis and Data Visualization 976
- BI Publisher 840
- Analysis 673
- Oracle Fusion Analytics 577
- Administration 555
- OBIEE 429
- OAC 405
- 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
-
Need to get referrer Job Title and Referrer assignment status in OTBIWe are using "Recruiting - Recruiting Real Time" subject area to get Requistion number, requistion title, referrer person number, referrer person name, worker person num… -
Data Limit/size when we use BIP Report by calling SOAP Web Service in Fusion OIC layerWe are planning to Use BIP query to get the data from Fusion Order Management and Receivables by Sales order within OIC integration. We are storing batch number in ATTRI…
-
OTBI Usage and Performance Dashboard SampleReal Time OTBI Usage & Performance Two subject areas are available to monitor OTBI usage and performance: OTBI Usage Real Time: Monitors OTBI usage, including user, anal…
-
Trying to combine pay elementsHi I need to do a report that provides a total of a calculated field based on a specific pay element, and have had to strip this PE out of the input values of the other …
-
Hey team I want to create an OTBI reportwhich could pull up the additional info column details from payroll relationship. I have a screenshot showing three fields, and I need to populate their values along wit…
-
Deprecation risk for HCM Benefit PVOs?We are using below PVOs for extracting data for benefits from HCM Cloud. As these are not white-listed for FDI: can you please confirm if in the future these PVOs will n… -
Dashboard with analysis tested OK in Test environment, but no results in Production environment.Hi Experts, Please refer to the following screenshots. I got this situation that I have created a dashboard (composed by a dashboard prompt and an analysis report) to re…
-
Original Author of a DashboardIs there a way to determine the original author of a Dashboard within the Oracle Fusion Catalog after someone modified the ownership of the item? If this isn't possible …
-
what subject area can you report on DFF's on termination recordWe have added a DFF to the termination card under PER_PPS_DF and would now like to report on it in OTBI, which subject area can we do this from?
-
Is it possible to edit the "retirements" formula in Fixed Asset Balances Real Time?I put the "retirements" field in my report, but they are considering SOURCE_TYPE_CODE = RETIREMENT and ACCOUNT_TYPE = COST, DEPRECIATION_RESERVE e TRUE_DEPRECIATION_RESE…
-
PO Layout - Table HeaderHi, I would like to add new column in to my table in PO Layout. When i did it i have received an answer from the system as below ct = "//location.language/> I expect tha…
-
24C OTBI Enhancement: Email a link to analysis results - Not workingWe see a new 24C feature listed as OTBI product enhancement. But we do not see any option on how to use that functionality. Can someone please assist here. The link Orac…
-
One Prompt to query against multiple columns in an analysisI'm trying to figure out a way in OTBI when querying the Natural Account Segment - Value object, to also query against Natural Account Segment - Level 31, Level 30, Leve… -
What is the subject area that would have "returned quantity of a PO" information?Hi Experts, May I ask what is the subject area that would have "returned quantity of a PO" information? I have another CCC post submitted in "Inventory Management" categ…
-
OTBI report to see where catalog DM or item is usedWe need to understand if DM is used in any report or not. The same for some images. Is there any way to iddentify it ? Thanks
-
Why "contains all" or "is like" operator is displayed between the prompt name and the list of valuesI created a OTBI prompt for a dashboard. Unfortunately the operator "contains all" is displayed between the prompt name and the list of values. Why the operator is displ…
-
Extracting Goal SuccessCriteriaText from hrc_txn_data that is greater than 4000 Characters using OraSummary Extracting SuccessCriteriaText for Performance Goals in Draft or Pending Approval from hrc_txn_data using SQL when SuccessCriteriaText is having more than 4000 C…
-
BICC: How to find current run extractsSummary: I an trying to submit BICC extracts through esswebservice. I see extracts are being submitted and completed without any issues. However, when I check UCM for th…
-
Why does an OTBI report run successfully for me but when the end user runs it, its spinning?The client created an OTBI Analysis for an Asset Categories report with the following columns; Major Category Default Life in Years Minor Category Asset Book Asset Cost … -
OTBI link Receivables Customer Real Time to Transactions Real TimeHi- Financials Receivables Cloud BI Using the Real Time Subject Areas how can I get a list of all Customers & their Details (Sites, Accounts, Contacts, Addresses) and de…