Fusion
Discussion List
-
How to get notified when a scheduler does not deliver a report (due to any reason)Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Abhishek Bagh 19 views 4 comments 0 points Most recent by Abhishek Bagh General Transactional Reporting (OTBI) -
how to put a Countif in a unique field in an OTBI reportSummary: In my report, I have Person Number field which is unique, however the report has some duplicate entries. I only need to understand how do I get a count to see h…Abhishek Bagh 26 views 8 comments 0 points Most recent by Amrita Gupta-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 991 views 22 comments 19 points Most recent by User_XPQO3 General Transactional Reporting (OTBI)
-
List of BPM PVOs available in Fusion or accessible through OTBISummary: Would like to know the list of available OTBI PVOs which hold BPM related information to be able to cater to some reporting scenarios - for e.g. - how long does…Amit Garg-Oracle 2 views 1 comment 0 points Most recent by ravikiran goda-Oracle 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 3.9K views 14 comments 8 points Most recent by LCann-Oracle General Transactional Reporting (OTBI)
-
how to calculate Tenure dynamically (including for a historical date)Summary: I have an active HC report where I included a Tenure field using below formula however it is not good when we try to pull the report for a historical date. I am…Abhishek Bagh 2 views 0 comments 0 points Started by Abhishek Bagh General Transactional Reporting (OTBI)
-
OTBI: Find the number of Working/Business Days between two dates and exclude Public HolidaysSummary OTBI: Requirement to find the number of Working/Business Days between two dates, therefore the calculation must exclude days that fall on Weekends or Public Holi…Richard Beet 104 views 5 comments 0 points Most recent by Venu Kumar General Transactional Reporting (OTBI)
-
OTBI Analysis - Getting DFF meaning instead of the valueContent Hi, I am developing an OTBI analysis that deals with several DFF from Oracle HCM Cloud. These DFF have value sets that get values from lookups loaded into the sy…Tmolina-Oracle 93 views 5 comments 0 points Most recent by Yves Chassein General Transactional Reporting (OTBI)
-
is it possible to compare Person Number (Colleague) with Manager Person Number (Supervisor)?Summary: Can we compare Person Number with Manager Person Number dynamically (for all records in a report) to analyze if listed Supervisor is actively present in Person …Abhishek Bagh 12 views 4 comments 0 points Most recent by Abhishek Bagh General Transactional Reporting (OTBI)
-
how to remove HTML markup from columns of an OTBI reportSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Abhishek Bagh 22 views 3 comments 0 points Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI)
-
Not able to see budget amounts in Fusion OTBI AnalysisSummary: Content (required): I had uploaded Budget amounts using FBDI and it is appearing in Account Monitor also in General accounting dashboard. But while creating ana…Akash Nandwal-Oracle 2 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle General Transactional Reporting (OTBI)
-
Tenure calculation in OTBISummary: Used Current_Date function & Enterprise Seniority Date field to calculate Tenure (in a separate field) however the result is not accurate (its showing value zer…Abhishek Bagh 24 views 6 comments 0 points Most recent by Abhishek Bagh General Transactional Reporting (OTBI)
-
how to compare Person Number with Manager Number fieldSummary: I would want to apply a condition to know if Colleague is present in Manager Name field or not. How do we compare the Person Number field with Manager Person Nu…Abhishek Bagh 22 views 3 comments 0 points Most recent by Amrita Gupta-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 25 views 8 comments 0 points Most recent by amy hardtke General Transactional Reporting (OTBI) -
oracle cloud HCM OTBI Dynamic File Name and TitleSummary: Output File naming :-YYYY-MM-DD – [Business Unit] – [Last Name], [First Name} [Incident Event Type] Title: Safety Incident Report for [Incident Number] [Inciden…Surya -Oracle 12 views 1 comment 0 points Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI)
-
How to create a flag field to know if a colleague is a Manager or not in OTBI report directly?Summary: In addition, wanted to understand if there's any in-built field present which can let us know whether listed Supervisor is in Active or Inactive status. If ther…Abhishek Bagh 13 views 6 comments 0 points Most recent by Abhishek Bagh General Transactional Reporting (OTBI)
-
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 K - Deloitte USI 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 K - Deloitte USI 2 views 4 comments 0 points Most recent by Abhilash K - Deloitte USI 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 3 views 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 12 views 6 comments 0 points Most recent by Rajasekhar Bandaru-Oracle 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 14 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 27 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 18 views 2 comments 4 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 16 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 25 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 18 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 79 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 14 views 1 comment 2 points Most recent by shun nakamura General Transactional Reporting (OTBI)