Popular Tags
- OTBI 1,433
- 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
-
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" =…
-
I want query for below columns, for AR Invoice Integration Exception report using interface Tables.Columns are ACCOUNT_CLASS, Distribution_Account, description, Invoice_Number, Distribution_Amount, Payment_Term, Currency, GL_DATE, Error_Reason, Ship_To_customer_Name, …
-
OTBI formula to modify stringHello, We have an analysis in OTBI from one subject area with strange behavior - in the column 'Employee' the values are in the format 'LastName, FirstName' (Doe,John), …
-
How to limit Prompts to Yes/No in Dashboard?I have a requirement to develop a table with yes/no prompts for ex: the contracts for the suppliers if the user select yes, it will retrieve all the suppliers who has th…
-
Delete Fusion Report Job Which is scheduled in Other AccountSummary: Delete Report Job Which is scheduled in Other Account. Content (required): We have requirement to delete the report job which is scheduled in other user account…