Reporting and Analytics
Discussion List
-
How to make a custom notification?Summary: I want to create custom notification from scratch not a standard and to customize no but one that doesn't exist and from scratch so how to do that -
Render OTBI dashboard using external APISummary: Hi , Would it be possible to build OTBI dashboard fetching data from external (Third-party) APIs ? I have evaluated the possibility of data sources in Data mode…Lakshmi_Sasidharan 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Display Item number with and without Part numbers and Manufacturer in Custom Onhand Inventory ReportSummary: The query below displays all inventory item numbers with part numbers and manufacturer information. However, the report does not show items without part numbers…
-
How do people manage REACH reporting outside Oracle Cloud Fusion ERP?Summary: We are required to provide Regulatory reporting requirements such as REACH and Plastic Tax as a company. Oracle Cloud Fusion ERP has no standard solution, so we…
-
Unable to get WCC server[servername] SecurityGroups DetailsThere is an existing scheduled report job that uploads the csv report to CS. When I check it gets the error "Unable to get WCC server[servername] SecurityGroups Details"…ChrisSSS 51 views 1 comment 0 points Most recent by ChrisSSS Reporting & Analytics for Fusion Service
-
what Database table stores the Role Category informationSummary: need to fetch data describing that which user has what roles and its categories. we have used below tables for our custom query per_user_roles per_users , per_r…Mateen Khan 891 views 4 comments 0 points Most recent by UdayrajSingh Reporting & Analytics for Fusion Service
-
How to Migrate the Translated Lookup values from one instance to other?Hi Team, We have created the customer lookup which has 2500 records, we translated those values using the translate icon, and after translating the values we can see in … -
Report Approval Path PRWe have requirement to make report about all approval path (person) from requester until approver for transaction PR or PO. Is there any table or data set that used to c…fani2904 31 views 3 comments 0 points Most recent by Venk Kudire- Support-Oracle Fusion Applications Administration
-
Do analyses run with Agents log to "OTBI Usage Real Time" subject area?Summary: Do analyses run with Agents log to "OTBI Usage Real Time" subject area? Content (required): Version (include the version you are using, if applicable): Code Sni…Andrew_Schmitz 43 views 3 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales -
Creating a DIFF Attribute in BI Publisher Analysis ReportSummary: Creating a DIFF attribute in BI Publisher analysis that provides an "aging count" of two date attributes from two separate subject areas. The aging count is bla…Cynthia Churchwell 21 views 3 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
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 194 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 43 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 62 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 11 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 132 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 23 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service