Reporting and Analytics
Discussion List
-
Can you add smartsense to an incident report?Summary: We'd like to add smartsense to our queues report so we can see the customer sentiment before we open an incident and then be able to address the angry customers… -
Getting XMLPGEN - 03111 : User requested cancel operation ERROR in BIP ReportI have built a Order Management Pricing Report (BIP Report) Getting "User requested cancel operation" Error in the Report. Attached the screenshot for the reference, if …John Peter Noble-Oracle 192 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting & Analytics for Fusion Service -
How to group the values using different columns in OTBI reportI want to create spearate column in the OTBI to get number of invoice count using supplier name, Invoice number and invoice creation date columns. I could be able to cre…Madushan Fernando 41 views 1 comment 0 points Most recent by Madushan Fernando Reporting & Analytics for Fusion Service -
Cynthia Churchwell 21 views 5 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales -
OTBI Analysis for for Performance DocumentsI need help/guidance in setting up an analysis filter to only pull the last 12 months of Performance Documents from the Workforce Performance - Performance Rating Real T…Colin M 21 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting & Analytics for Fusion Service -
display logo in excel format in Oracle Fusion BI reportI want to diplay the logo in Orcale Fusion RTF template in excel output When fetching output in pdf its showing the logo but not in excel fromat What is the sloution to …Abdur Rehman 61 views 4 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
Not able to view the BI publisher report under supply planning work areaSummary: We created BI report for Supply planning and loaded and created a new folder Supply Chain Planning under /Shared Folders/Custom/ and saved the report there. But…Adhavan 21 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Receiving Pending Benefit Actions Email Alert although there is no pending action item for the user.Receiving Pending Benefit Actions Email Alert although there is no pending action item for the user. This is generated from custom report, and it is showing Pending Bene… -
Is the Workforce Learning - Learning Management Real Time subject area being deprecated, and when?Can you help me understand if this SA is being deprecated in OTBI or if it will remain? This Customer connect article seems to indicate it was announced in 2021 that it …CJALSPAC 12 views 1 comment 0 points Most recent by CJALSPAC Reporting & Analytics for Fusion Service -
What if an instance has been created on analytics cloud instead of FAW ?Hi guys, What's the difference between creating an instance on Analytics Cloud and FAW on OCI ? What if some work has been done on an instance (let's say Instance 1) cre…Lauriane Massin Whitaker 21 views 2 comments 0 points Most recent by Lauriane Massin Whitaker Reporting & Analytics for Fusion Service -
Perform Shipping Transaction Import ESS Job not populating Request Id in WSH_NEW_DEL_INTERFACE tableHi All, We have below requirement, Create and confirm shipment through REST API Call "Perform Shipping Transaction Import" ESS Job through SOAP. Once done respective ord…Nagaraju Vandavasi 131 views 3 comments 0 points Most recent by Satya Ganti-Oracle Reporting and Analytics for SCM -
Hidden reports and how to run themSummary A small how-to on how to run hidden reportsContent Your OSVC instance has (depending on the version) 240+ hidden reports. If you are like me and always wondered …Sebastiaan Draaisma-122509 199 views 7 comments 10 points Most recent by Nika Gerson Lohman Reporting & Analytics for B2C Service -
How to print an embedded dashboard pageSummary: When opening a dashboard through directly in the catalog, there is a gear in the top right that gives the ability to print out a dashboard page. When a dashboar…NicolaosDerr 11 views 2 comments 0 points Most recent by NicolaosDerr Reporting & Analytics for Fusion Service -
PROCUREMENT CONTRACT REPORT CREATIONSummary: Hi, We need to create a custom report in the Oracle procurement contract where can we fetch the front-end data - Monthly wise Please suggest the contract tables…Ranganathan Siva 1 view 1 comment 1 point Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
recruiting events analyticsHello, I would like to have some analytics or dashboards for metrics regarding recruiting events and campaigns in Recruiting. Is there any predefined dashboard, or a way…Carolina Oberti 21 views 2 comments 0 points Most recent by Chaitanya J.J.-Oracle Reporting & Analytics for Fusion Service -
SQL Query to get AP invoices stuck in initiated status in oracle fusion Cloud ERPHi All, I need a sql query to get all invoices in Initiated status that are not assigned to any user or security role for approval. Can anyone please guide me where I ca…Sneha_S 661 views 1 comment 0 points Most recent by Venk Kudire- Support-Oracle Fusion Applications Administration -
Invoice ReportSummary: Is there any report which can drill down PO details (Department, cost Centre, receipt number and shipment number) which have been matched with invoice lines. Co…Najumah Bibi Abdool Rahman 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Optimizing view failed - Error running report - answers.map_prod_lvl1_id breaks itSummary: Hello, We are experiencing issues with all report using answers.map_prod_lvl1_id. Our goal is to simply display the answers created in a specific period of time… -
Is it possible to access ATP DB table in AnalyticsSummary: Could access ATP DB table in Report Analytics catalog to build SQL Query data model Content (please ensure you mask any confidential information): Version (incl… -
In which subject area I can find Site details to create an OTBI report?I need the following fields in my OTBI report related to site to know their subscription status: 1) Oracle Fusion Site Name 2) Oracle Fusion Site Number 3) Oracle Fusion…Vishal Thakur 21 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
Feature Friday: Workspace InfoletsContent Workspace Infolets are new (with 20D), configurable mini-workspaces that provide UX continuity between the Workspace and Infolets on the Task-based Home UX. Thes…Michelle Brusyo-Oracle 49 views 1 comment 0 points Most recent by Ravindra Sirigiri-Support-Oracle Sales -
On Update 23.R4 SQM is noted as future roadmap itemSummary: On Update 23.R4 SQM is noted as future roadmap item. Is timeline available for this functionality? Content (please ensure you mask any confidential information)…AVorster-Oracle 1 view 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
customized configuration for service logistics and subscriptionHi There, we want cutomized Service request page to display the subscription related to the asset we have choose in service request and also shows the history of subscri… -
ParameterNameValues in runReport() Method doesn't workHello everyone. I have a problem with the runReport() method, when I enter values in the section, it correctly returns a base64 but when I decode it, it only shows me…Jonatan Montiel 52 views 2 comments 0 points Most recent by Jonatan Montiel Reporting & Analytics for Sales -
Need Query to get error data which is shown in review cost distribution processSummary: Need a query to get the warning/error for cost distribution process which ever ends in warning or error. As the create cost distributions process is scheduled i…Sukanya Mukherjee 21 views 1 comment 0 points Most recent by Arun Yadav - Support-Oracle Reporting and Analytics for SCM -
Not able to successfully send rest api post request to generate BI publisher report in Fusion CloudSummary: I'm trying to make a post-call to generate a BI publisher report. The fusion cloud rest api is returning RequestId -1 despite the request was fulfilled with 201…mayank_tripathi 21 views 2 comments 0 points Most recent by mayank_tripathi Reporting and Analytics for SCM -
Is there any possibility to include the entire reporting hierarchy as CC in the Email from BI Agent?Summary: Currently when ever the email is being sent from the agent , entire reporting hierarchy is receiving the email separately. Is there any possibility to include t…ArjunReddy88 21 views 1 comment 1 point Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales -
"Processing view failed" error on reportContent I have a report where I have a column which is a concatenation of text and fields and one if statement, so essentially running a bit like a merge. It was all run…Ineke Clewer 48 views 15 comments 1 point Most recent by Ineke Clewer Reporting & Analytics for B2C Service -
How can I create a report BI of notifications sent by service request workflow?Summary: How can I create a report BI of notifications sent by service request workflow? Content (required): Currently we are dispatching a series of notifications throu…Camilo Martinez-114335 32 views 1 comment 0 points Most recent by User_4XX09 Reporting & Analytics for Fusion Service -
Is requisition approval history available in BICCSummary: We are looking for a data store that contains approval history for Purchase Requisitions. Is this available in BICC? Content (please ensure you mask any confide…Holly Wells 1 view 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM