Popular Tags
- OTBI 1,429
- 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 408
- Analytics 382
- BI Publisher Data Models 346
- Security 288
- Answers 264
- HCM 256
- Analyses 253
- BIP 248
- 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 169
- 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
-
Disable or Hide Email option on the results page of an OTBI ReportWhen we click on the Email option that appears along with Export, Print, Copy on the Results page of an OTBI report, the raw data is dumped to the email address. This is… -
Automatic Backup of All Custom BI Reports and AnalysesFusion Applications BI - How To Take a Automatic Backup of All Custom BI Reports and Analyses Hello, We want to take backup of All Custom BI Reports and Analyses & custo…
-
Usage of PVOs GLOBALPERSONPVOVIEWALL and PERSONDETAILSPVOVIEWALLWe are building a BICC extract to extract person and their assignment data, wanted to understand when should we use GLOBALPERSONPVOVIEWALL and PERSONDETAILSPVOVIEWAL
-
is it possible to copy all users' reports from their own folders to the Share folder?Summary: Hi, Who can advise: is it possible to copy all users' reports from their own folders to the Share folder? For example, I have created a report and saved it in M…
-
How to create an RTF TemplateHi all I've tried to create a RTF template but I have a problem with the first step about the guide. I don't understand what it means " To obtain the sample XML file, su…
-
How to archive whole catalog (Shared and Users)?With an administrator role, I would like to archive the whole analytics catalog to backup all Analytic Objects (even the objects in users folders). During P2T or when a …
-
Compare two fields from different Subject Areas in OTBII have written an OTBI analysis containing several fields however I am having an issue when I create a field with a Case statement to compare the below fields. Subject A… -
Calculating wrong values in Subtotals.As I calculate the subtotals in the tabular report for which I work as a BI developer, the calculation is automatically producing incorrect results.
-
How to Fetch more than 1000 records with BIP or OTBI reportSummary: Fetch more than 1000 records with BIP or OTBI report. Content (required): Hi, How to fetch more than 1000 records with BIP or OTBI report. I tried with Paramete…
-
Oracle BICC SOAP based extractionWe are trying to run a BICC extracts via SOAP API, Is it mandatory to have WSA-Addressing in header of the SOAP API payload? submitRequest 1234567 As per oracle document…
-
Assignment logic in data store: HcmTopModelAnalyticsGlobalAM.PersonAM.GlobalPersonPVO?We have an employee that has two assignments. The assignment fields that are populated in GlobalPersonPVO pertain to the 'old' assignment. I can't figure what the logic …
-
BICC ExtractsHi All, How do we identify whether the files generated by BICC on UCM are the files for Full or incremental extracts. The files generated have the same naming convention… -
24A - OTBI Data Exporting updatesExactly what object types in OTBI are impacted by this 24A advanced notice. Does impact extend to csv or tab delimited files which are manually generated using rtf templ…
-
Reporting for the recruitment/hiring processI need to build a report for the recruitment process that includes YTD counts for candidate slates, candidates on shortlist, interview slates and candidates interviewed …
-
Excel template of BI Publisher: specific requirement on Grouping of 1 FieldHi, Attached are the samples from BIP as I cannot use ours due to security issues. But the Output requirement is mentioned exactly required marked in GREEN.
-
Newly Created Order Management Line and Header EFF not available in OTBI Subject AreaNew Order Management Extensible Flexfields created with BI enabled flag checked. Flexfield deployed. ESS Job - Publish Extensible Flexfield Attributes successfully compl… -
Listing of Email CorrespondencesIs it possible to report on email correspondences? We are looking for a report either in OTBI or OBI which would list out all our email correspondences, status, recipien…
-
System Notifications ListingIs it possible to report on system notifications? We are looking for a report either out of OTBI or BI that will list all our system notifications, status, recipients, f…
-
I want query for below columns, AR Invoice Integration Exception report using interface Tables only.Columns are ACCOUNT_CLASS, Distribution_Account, description, Invoice_Number, Distribution_Amount, Payment_Term, Currency, GL_DATE, Error_Reason, Ship_To_customer_Name, …
-
OTBI formula based on presentation variable promptHi, I have tried to create report and in the fact amount using the following formula "CASE WHEN "Ledger"."Ledger Name" = @{COMPANYA} THEN 1 WHEN "Ledger"."Ledger Name" =…