Fusion
Discussion List
-
OTBI Report Performance IssueSummary: Customer facing performance issue with the reports developed using OTBI Content (required): Customer developed some of the reports using OTBI reporting tool whe…Praveen Gollu-Oracle 11 views 1 comment 0 points Most recent by Bhaskar Konar General Transactional Reporting (OTBI)
-
General question have if I move any another orginaizationSummary: Hi Team, If future chance to move other organization from current one, how can i access my current cloud customer connect beacuse i have login through my curren…AjayKumar Maddipati 11 views 2 comments 0 points Most recent by Mandeep Gupta General Transactional Reporting (OTBI)
-
Finding the alphabets from a Alphanumeric in OTBI.Summary: I have a requirement to identify the alphabets (be it upper/lower case) from a string. The format of the sting is as follows: SSN: ****-XX-XXXX (112-10-1234) TI…satya_nvs 21 views 2 comments 0 points Most recent by Venkat Koduvayur-Oracle General Transactional Reporting (OTBI)
-
Count positive values and compare with total count to get the aggregated share of positive valuesSummary: How can I count the number of positive values in a column and compare with the total count to get the share percentage of positive values? Content (required): I…Stefan pettersson 31 views 3 comments 0 points Most recent by Stefan pettersson General Transactional Reporting (OTBI)
-
How to create formula to show PR where all lines have processed requisition line flag as yesSummary: We are trying to create an analysis to display those particular requisitions where all lines are processed successfully into PO Content (required): Need help to…JITHU JOSE 21 views 4 comments 0 points Most recent by JITHU JOSE General Transactional Reporting (OTBI)
-
Facing Issue in calculating percentage for an Analysis in OTBISummary: We are trying to create a custom analysis to calculate the month wise percentage of delivered amount being early received including tolerances. We have calculat…Palak Karma 31 views 7 comments 0 points Most recent by Palak Karma General Transactional Reporting (OTBI)
-
Issue with deep link Functionality in OTBI AnalysesSummary: We need a functionality within OTBI Analyses where we click on a particular graph of the analysis, it redirects to the SaaS Page which has particular set of rec…Palak Karma 31 views 3 comments 0 points Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI)
-
Issue with developing analyses for requisition to purchase order cycle timeSummary: We are trying to create a custom analyses as per requirement of customer to analyze the purchase requisition to purchase order cycle time but not able to identi…JITHU JOSE 11 views 2 comments 0 points Most recent by JITHU JOSE General Transactional Reporting (OTBI)
-
Issue while creating analysis using Max and Avg functions in new calculated measure.Summary: We are trying to create a analysis for sales order processing lead time, but we are facing issue as the new calculated measure using avg function is not giving …JITHU JOSE 11 views 3 comments 0 points Most recent by Jahnavi-Oracle General Transactional Reporting (OTBI)
-
Report Location of following seeded reportsHello - We are having a request to implement/customize the following reports but will have to analyze first the complexity of each report. Unfortunately, we are unable t…ZenG 21 views 2 comments 0 points Most recent by Gaurav Bharadwaj-Oracle 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 14 views 2 comments 0 points Most recent by Abhilash K - Deloitte USI 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 1.2K views 23 comments 19 points Most recent by Fazal Subhan General Transactional Reporting (OTBI)
-
How to add on Home Email address into a OTBI report?Summary: See work email, but home email is updated in myHR however dont see the home email address field to add in report - Please advise. Content (required): Version (i…Abhishek Bagh 31 views 1 comment 0 points Most recent by Mandeep Gupta General Transactional Reporting (OTBI)
-
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 11 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 31 views 8 comments 0 points Most recent by Amrita Gupta-Oracle 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 1 view 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…Rashmi M-Oracle 5.7K views 14 comments 11 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 1 view 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 157 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 87 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 11 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 1 view 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 21 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 21 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 20 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 11 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 11 views 6 comments 0 points Most recent by Abhishek Bagh 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 1 view 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 31 views 3 comments 0 points Most recent by Srinivas Sakinala General Transactional Reporting (OTBI)