OTBI
Discussion List
-
Is it possible in one report Bursting and ad hoc running possibleIs it possible to create one report where Bursting setup will ensure that the report is distributed to the correct recipients as specified, whenever it is run on an ad h…Sangeetarani Padhi 32 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service -
What is the impact of not Assign Financial Categories to the Natural AccountsOne of the prerequisites for implenting a reporting tool such as OTBI and FDI , is to assign financail categories to the natural accounts. What is the impact on not doin…
-
NOT ALL ROLES are covered in Fusion Report "User and Role Access Audit Report"Hi everyone, just a question regarding the Scheduled Process: "User and Role Access Audit Report", do you know why some roles are not included in this report? ie "Applic…Lia Naga 70 views 1 comment 1 point Most recent by Cătălin Hurjui-Support-Oracle Reporting & Analytics for Fusion Service
-
We need to update the #average headcount, #leavers, period start and period end headcount with OTBIWe need to Modify headcount columns in an Annual Turnover dashboard page. We need to update/review the #average headcount, #leavers, period start headcount, and period e…
-
How can I grant "GL users" access to the seeded "Payables Trial Balance Report"?We have a requirement in which "GL users" can generate the seeded "Payables Trial Balance Report" on their own to expedite their tasks. How can we configure this in Orac…Arsen Guevara-CITCO 67 views 4 comments 0 points Most recent by JohnG Reporting and Analytics for ERP -
Creating a Business Unit-Specific Lead and Opportunity Dashboard in Oracle FusionHi Community, I'm working on creating a dashboard in Oracle Fusion CX Sales to provide insights into lead and opportunity performance for specific business units. My goa…Fareeha Altaf 106 views 5 comments 0 points Most recent by Sheela Pai-Oracle Reporting & Analytics for Sales
-
Is it possible to create a security context in oracle cloud?I want to create that combo in oracle cloud: define a role with a security context that I create and security context valueACNROMA2023 41 views 4 comments 0 points Most recent by HimanshuSetia123 Reporting & Analytics for Fusion Service
-
report for tax rates by jurisdictionWe are looking for a report for tax rates by jurisdictionCindy Souvagis 31 views 2 comments 0 points Most recent by Cindy Souvagis Reporting and Analytics for ERP
-
Hello experts, do you have the SQL query to get the list of employees and their HR representativesHello experts, Do you have the SQL query to get the list of employees and their HR representatives? Regards, Hazel
-
What are the tables or SQL query to fetch ESS job name, Report name, Report path detailsHi Team, I have requirement to develop custom SQL query to fetch details like All ESS Job names, Display names, Report names, Report paths etc. I have used tables like E…anusha chunduru 3.7K views 6 comments 1 point Most recent by User_S6U3H Reporting and Analytics for ERP
-
Required SQL query to get Customer Opt in featureSummary: Required SQL query to get Customer Opt in feature Content (please ensure you mask any confidential information): Hi Team, We need the SQL query to get Oracle fu…Opkey PA 257 views 2 comments 1 point Most recent by Biju Radhakrishnan-Oracle Supply Chain Orchestration
-
Export the list of configured time attributes and display value from Time entry layout componentsIs there a way to export the list of configured time attributes and display value from Time entry layout components? We are comparing 2 different layouts and it will be …
-
Fusion OTBI Subject Receiving - Purchase Receipts Real Time No ResultsSummary: Fusion OTBI Subject Receiving - Purchase Receipts Real Time No Results The specified criteria didn't result in any data. Content (please ensure you mask any con…Chanida 20 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
Prebuilt Fusion Service Analytics report list - ClaritySummary: Hoping the community are able to provide some clarity around the prebuilt reporting delivered for NextGen HR Help Desk and Case Management. I've reviewed the Pr…Simon Kaplun 22 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Grand Total FormatingHi. I added a Grand Total row to my report, but the values are not formated. I thought it would make perfect sense for the grand total to follow the format of the column…Vitor Nakamura 54 views 3 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Sales
-
Not able to add Budget Values(amount) column in FRS Report.We have an FRS Report for Profit & Loss Account where the accounted values are reflected. We have a requirement to add Budget Values also in the FRS, but we have tried e…Jagjit Singh Arora 31 views 4 comments 0 points Most recent by Jagjit Singh Arora Reporting and Analytics for ERP
-
Extracting Booking History Details - Demand ManagementSummary: Hi All, I am trying to extract booking history details for a particular org for the last 3 years, along with the customer details. However, along with bookings …Ashish A Jha 112 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
HCM extract flow results in a tableHi, We are currently doing manual monitoring on schedule HCM extract runs and we are looking into creating an OTBI or BIP report in order to somehow automate this monito…
-
Compare 2 Versions of BIP Report between 2 different instances in Oracle FusionHi All, We're exploring options to compare two versions of a BI Publisher (BIP) report, including both the data model and report definition, to identify changes between …Pooja K-Oracle 214 views 4 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting and Analytics for ERP
-
Add otbi report in a DCS appContent Hi, We are trying to add OTBI reports in a DCS application. We tried using iframe using the analysis URL but are only able to view the report data if I am logged…ShreySH-Oracle 35 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
How do we add Tasks, Reports and Analytics Panel to the Order Management PageSummary: How do we add Tasks, Reports and Analytics Panel to the Order Management Page Content (required): Business requirement is to add tasks, reports and analytics pa…kalyan gade 112 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
Does SOC1 report also covers OTBI and BI PublisherDoes SOC1 report also covers Oracle Transaction Business Intelligence (OTBI) and Oracle Business Intelligence Publisher (BI Publisher)?Temi A. 38 views 3 comments 0 points Most recent by Temi A. Reporting & Analytics for Fusion Service
-
Download sample issue for the PVO in BICC consoleSummary: Below are the list of PVO's which are having the download issue for sample file 1.FscmTopModelAM.FosOrchestrationProcessAM.TransactionEventPVO 2.FscmTopModelAM.…Soare Oldrich Alexandru-Oracle 96 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
How to Link a Column in OTBI to a Parameter Based on Conditions?Hello, I am working on a report in Oracle Transactional Business Intelligence (OTBI) and I need some help with linking a column to a parameter based on conditions. Speci…Omran Zeaiter 26 views 6 comments 0 points Most recent by Omran Zeaiter Reporting and Analytics for ERP
-
Fusion Analytics warehouseWe have a requirement to get the count of employees Saudization wise. it means, if the employees Nationality is Saudi Arabia then employee comes under Saudi else other. …Nalsoft Pvt Ltd 12 views 2 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
How to get Risk Code value in BIP Custom ReportSummary: We are developing a customer report and we need a column called Risk Score. The value we may need is similar to this 'Any value between 1 – 69 is high risk and …Dhanusia 1 view 1 comment 0 points Most recent by Augustin Aravind-Oracle Reporting and Analytics for ERP
-
Employee Contract Extended data filter needed in OTBI ReportHi Team, I have a requirement to extract employees whose contracts are going to end in the next 60 days. For this, I have added the filter below, and it is working as ex…
-
Helpdesk Requests that have Journeys assigned to them on an OTBI**This post was created as part of a How to Service Request (SR) Release: [Version] 11.13.24.04.0 Summary of the question: Can we identify Helpdesk Requests that have Jo…Bodhisattwa Mukherjee-Oracle 2 views 2 comments 0 points Most recent by Bodhisattwa Mukherjee-Oracle Reporting & Analytics for Fusion Service
-
Is there a simple way to create a report based on Service request, Work Order and Debrief?we are working to create a report that will include information from the Service request and all the work that was done by the engineer. the entity structure we need (or…Boaz Hayon-Oracle 1 view 3 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
I am facing issue with one of my custom BI report developed to extract COGS Revenue & Margin!Hi Folks, I am facing issues with one of my custom BI report developed to extract COGS Revenue & Margin. While running the report from Data Model Schedule window, I can …Sravan Komminedi 23 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service