Popular Tags
- OTBI 1,448
- Reporting 1,394
- FDI 1,123
- Analysis and Data Visualization 988
- BI Publisher 856
- Analysis 682
- Oracle Fusion Analytics 591
- Administration 555
- OAC 454
- OBIEE 433
- Analytics 403
- BI Publisher Data Models 356
- Security 293
- HCM 268
- BIP 264
- Answers 264
- Analyses 255
- Developers 246
- Data Modelling and Datasets 229
- Data Connectivity 210
- ERP Analytics Content 210
- BI Publisher Report Templates 204
- Oracle Analytics Cloud 197
- Fusion Data Intelligence 187
- Report Output 184
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
-
Fetch Proposed Department and location details from transaction tablesI was able to get employee's current department and his location directly from Worker assignment Real Time Subject Area but how do i get his future/proposed transaction … -
Unable to Connect to ADW using Oracle BI Administration ToolTrying to import metadta of ADW using the Oracle BI Administration Tool and we are facing issues while connecting Private ADW exposed to public via Load Balancer. nQSErr…
-
AP/AR Master DataHi Team, We need to pull the master vendor and customer data for both Receivables and Payables in Oracle Fusion. It should include the vendor/customer numbers, names, ad…
-
Unpivot the dataHi, Is there a way of showing date and hours worked in separate columns per person instead of the way it is on the visual below? I have tried casting and unpivoting but …
-
How to add Refund amount column in Refund listing report in OTBI report in oracle fusion.Could you please help us of how to add Refund amount column in Refund listing report in OTBI report in Oracle fusion Receivables.
-
Cast a Date field as CHAR but alter the format.Hi all, I have a Case Statement that displays a date field when a Fixed Choice List is NULL. To achieve this I have had to CAST the date field as CHAR, however the retur…
-
Work confirmation and complex po Subject area in OTBIPlease i need to know if there's a subject area in OTBI which stores the data for work confirmation for procurement purchase orders in oracle fusion?
-
How to display one record in two different languages in OTBIHi everyone, I created an OTBI report and clients want to view the output in two different languages. For example: a client creates a job request and that job is shown i…
-
Override Average weekly earning field that can be found in Absence Records in OT BIDoes anyone know if the Override Average weekly earning field that can be found in Absence Records under legislative information is available in OTBI? We know it is INFO…
-
Calculated Field in OTBI PromptSummary: Wish to have Calculated field in OTBI prompt. I want to have 3 prompts based on the given table data below: Assignment Last Update Date Grade Change Flag Grade …
-
BI Publisher : How to hide a sheet in excel based on parameter using Excel TemplateSummary BI Publisher : How to hide a sheet in excel based on parameter using Excel Template Content BI Publisher : How to hide a sheet in excel based on parameter using …
-
Passing a Dashboard date prompt variable to two different date filters based on conditionsHi, I have a dashboard date prompt variable which needs to be passed down to two different date filters on the same analysis based on a Case statement and execute the re…
-
Medical Examination Data OTBI report display problemHello, With a specific role created role of Medical examination I have a problem displaying the report while connecting as a nurse in my organization. At first there was…
-
Columns missing in PVO BICCHi We are trying to find below View columns in a VO, can you please help us on how/where can we find them. We can find the column in the mentioned table, but are not ava…
-
REST API to get Salary detailsHi all, Is there a REST API to retrieve salary details like (Basic Allowance, Housing Allowance, Transportation Allowance) please advise.
-
Oracle Fusion OTBI > Ability to Rotate Rows Into ColumnsHello, We would like to design a report where the columns ‘Date’, ‘Time Entry Start Date and Time’, and ‘Time Entry End Date and Time’ are rotated. Please find below scr…
-
Does anyone have a report that will return all users who are Read-only (FND_READ_ONLY_MODE)?Need SQL to create a report that list all users who are Read only in the system, thanks.
-
Ability to only return data based on user BUHello All We have an analysis developed in OTBI that we want to make available to users across our Business Units. However, we only want the data relating to the Busines…
-
Workforce Management data accessHi All, We are using custom Line Manager role instead of a seeded one to restrict Line Manager's access to HR processes. This means restricting their ability to read or …
-
how to edit a date parameter in OTBI report (based on Subject Area)I need to create a parameter to be able to filter different dates in a report. The report was created based on a subject area. When editing the parameters it only indica…