Fusion
Discussion List
-
Table to retrieve records from Audit reports in Oracle Cloud Fusion ERP 22ASummary: Table to retrieve records from Audit reports in Oracle Cloud Fusion ERP 22A Content (required): Which table in SaaS stores information for Audit Reports? Table …Abhilash Karappankutty 12 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI) -
How to restrict the PPM contract data based on the roles of the user logged in in OTBI DashboardSummary: We are trying to restrict the data based on the roles available for the user logged in specifically Principal Investigator role (PI role). Content (required): V…Abhilash Karappankutty 2 views 4 comments 0 points Most recent by Abhilash Karappankutty General Transactional Reporting (OTBI)
-
Employee salary details not able to view through Compensation - Salary Details Real Time Subject AreSummary: We are trying to create a OTBI report for Employee assignment details with Salary details using Compensation - Salary Details Real Time % Assignment Real Time S…Srinivas Sakinala 1 view 3 comments 0 points Most recent by Srinivas Sakinala General Transactional Reporting (OTBI) -
When archived report files re uploaded it is appearing as .catalog. Not as reportsSummary: What needs to be done to make it work as report. Previous instance it was appearing as report Content (required): Version (include the version you are using, if…DIPAK KUMAR JENA 11 views 6 comments 0 points Most recent by Rajasekhar Bandaru-Oracle General Transactional Reporting (OTBI)
-
How to customize the banner - color and logo on OTBIContent Did anyone tried customize the banner - color and logo on OTBI. At time business users are confused between PROD and non-PROD environments. If we have a color ba…Vijay Ramani VJ 20 views 7 comments 0 points Most recent by Vijay Ramani VJ General Transactional Reporting (OTBI) -
R13.x Deprecated and New BI View ObjectsSummary This posting includes R13 deprecated Business Intelligence View Objects (BIVOs) that are unavailable for extraction using BI Cloud Connector (BICC) in Oracle App…Rohan Lobo-Oracle 1.8K views 5 comments 7 points Most recent by Sahil Makhiza General Transactional Reporting (OTBI)
-
Selecting the latest Order revisionSummary Need to retrieve the latest Orders revisionsContent Hi, While creating an Analysis to retrieve the Sales Orders details we need to show only the latest revision …Mr H 13 views 8 comments 1 point Most recent by Andrew_Schmitz General Transactional Reporting (OTBI)
-
How to run an OTBI Analysis and save output without having it deliveredSummary How to run an OTBI Analysis and save output without having it deliveredContent Currently in Schedule option of of OTBI analysis , there is option to deliver to e…Shivaji Muttarapu 24 views 8 comments 0 points Most recent by Shivaji Muttarapu General Transactional Reporting (OTBI)
-
BIP performance recommendations guide v1.0 for FA SaaS (2800118.1) is available on MOS PortalSummary BIP Performance Recommendations Guide is intended for FA SaaS BI system integrators, BI report developers and admins. It covers advanced performance tuning techn…Pavel Buynitsky-Oracle 17 views 2 comments 4 points Most recent by Srinivas Pendyala-Oracle General Transactional Reporting (OTBI)
-
OTBI Usage and Performance Dashboard SampleSummary OTBI Usage and Performance Dashboard SampleContent Real Time OTBI Usage & Performance * Two subject areas are available in 20D to monitor OTBI usage and performa…Noelle Bartlam-Oracle 663 views 18 comments 18 points Most recent by Srinivas Pendyala-Oracle General Transactional Reporting (OTBI)
-
Forward and Backward Button in BI AnswersContent Currently, the challenge is that you can't reset changes in BI Answers. Accordingly, a deleted field or a changed expression cannot be reset, but must be created…User_5HU7Y 15 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle General Transactional Reporting (OTBI) -
Sharing the reports from My Personal folder (Report and Analytics)Summary Sharing the reports from My Personal folder (Report and Analytics)Content We have some users in the business team created the reports on their personal folder (M…Vijay Ramani VJ 21 views 8 comments 3 points Most recent by Srinivas Pendyala-Oracle General Transactional Reporting (OTBI)
-
Pivot table in RTF TemplateContent Hello, I am trying to create a pivot table for an asset number per row and period name and depreciation amount in columns. I have followed this doc to create the…Nalinee Uppiah 16 views 10 comments 0 points Most recent by Anil Kola-Oracle General Transactional Reporting (OTBI)
-
OTBI: Diff of Two dates to get Age is rounded to next highest valueSummary OTBI: Diff of Two dates to get Age is rounded to next highest valueContent OTBI: Diff of Two dates to get Age is rounded to next highest value Example: If differ…Srinivas Challa 77 views 3 comments 1 point Most recent by Matthias Ludewig General Transactional Reporting (OTBI)
-
Embed BIP Report with URL on page (HTML) and have parametersSummary Embed BIP Report with URL on page (HTML) and have parametersContent Hi, I've embedded my BIP Report on the Purchase Requisitions page succesfully using an iframe… -
How To Merge Quote and Quote Line Item In Advanced Custom Objects (Subject Area)Summary How To Merge Quote and Quote Line Item In Advanced Custom Objects (Subject Area)Content Hi, I'm working to extract all Quotes and their respective Quote Line Ite… -
BI publisher API uploadReportObject completed with errorContent I would like to upload BIP directory object by using BI pub APIs, the directory contains RP and DM. Tried out this operation with appropriate parameters; reportO…shun nakamura 12 views 1 comment 2 points Most recent by shun nakamura General Transactional Reporting (OTBI)
-
Is it possible to do map visualisations in OTBISummary Is it possible to do map visualisations in OTBIContent Hi, Using only Oracle Transactional Business Intelligence (OTBI) with all the limitation of old Oracle Bus…Nathan CCC 17 views 2 comments 1 point Most recent by Nathan CCC General Transactional Reporting (OTBI) -
AR Aging Bucket (Fusion OTBI)Content I am facing a problem with OTBI. I need to create an analysis using a subject area for receivable aging bucket but there is no subject that is called aging I tri…Maram Abuzaid 34 views 1 comment 0 points Most recent by Sahil Makhiza General Transactional Reporting (OTBI)
-
set metric alert for dashboard or analysis (Fusion OTBI)Content Hello, I have a question regarding metric alert or email notification, let suppose there is KPI for total sales MTD (1M), I want to add a condition to alert the …Maram Abuzaid 13 views 2 comments 0 points Most recent by Maram Abuzaid General Transactional Reporting (OTBI)
-
BI Publisher Data Model completes with errorsSummary BI Publisher Data Model completes with errorsContent Hi Everyone, I'm trying to create a BI Publisher report using HRC_TXN_HEADER and HRC_TXN_DATA tables. Here I…Dhanuka Chamal 27 views 3 comments 3 points Most recent by Dhanuka Chamal General Transactional Reporting (OTBI) -
Libro GiornaleSummary What report are people using for the Libro Giornale?Content I have a requirement from our Italian Office that they require a report called the 'Libro Giornale' I…Josh Martinez-Perez 25 views 9 comments 2 points Most recent by Josh Martinez-Perez General Transactional Reporting (OTBI) -
Presentation Variable Prompt causes Error on Results tab, but not in Open linkSummary AsOfDate prompt causes errors OPR4ONWY:U9IM8TAC:OI2DL65PContent I added the follow prefix to my analysis: SET VARIABLE PARAM_EFFECTIVE_DATE='@{AsOfDate}'; Then I…Brenda Jacks-49721 83 views 8 comments 0 points Most recent by CB General Transactional Reporting (OTBI)
-
Remove empty folders in /CustomContent Hi, When being provisioned an environment, there are often a lot of empty folders already in the Shared Folders/Custom folder. See screenshot below of what we cu…
-
Report on BIP Catalog Folders detailsSummary Report on BIP Catalog Folders details like Roles and Permission etc.Content Dear Team, How to report on BIP Catalog Folders details like Roles and Permission etc…Karthik_ks 80 views 9 comments 2 points Most recent by User_DDGZ5 General Transactional Reporting (OTBI) -
Dashboard with multiple BI Publisher reports export to excel is blankSummary When using the Export entire workbook to excel function the exported excel sheet creates all the correct worksheet pages and headings however, the data is blank.…Sarah Munro 12024679 21 views 2 comments 0 points Most recent by Sarah Munro 12024679 General Transactional Reporting (OTBI) -
Wrap Text in MHTML formatSummary Wrap Text in MHTML formatContent Hi All, While selecting mhtml as a default template, i am not able to wrap text few columns such as description column. User wan…VAIDIA 12 views 1 comment 1 point Most recent by SantoshKumarB General Transactional Reporting (OTBI)
-
What application do you use to write your SQLContent I'm very curious as to what other people use to write their SQL. Personally I am using NotePad++ (with the SQL language setting to help with syntax). I do feel t…MaartenDIF 66 views 16 comments 11 points Most recent by MaartenDIF General Transactional Reporting (OTBI) -
OBIEE 11.1.1.9 - BI Publisher report with Bar Chart - Hover does not show dataSummary I have created a BI Publisher report with a bar chart however, when I run the report there is no data shown when I hover over the bar graph.Content I have now us…Sarah Munro 12024679 17 views 0 comments 1 point Started by Sarah Munro 12024679 General Transactional Reporting (OTBI)
-
How to copy from results?Summary We cannot copy a person number from the results of an OTBI report - so we have to type it when we want to open it in a screenContent Hello, something that must b…Geraud Andreux 20 views 5 comments 0 points Most recent by Robert Fighiroae-Oracle General Transactional Reporting (OTBI)