Reporting and Analytics
Discussion List
-
Custom View ESS Role is behaving unexpectedlySummary: There is a custom role created for business to provide access ESS history to certain users. The role was created under Role Category 'Common - Abstract Roles' w…Rahul_M8SG8 21 views 1 comment 0 points Most recent by Andrada-Oracle Fusion Applications Administration -
Send custom report to Microsoft SharepointSummary: A custom report needs to be scheduled and sent to MS share-point. Content (please ensure you mask any confidential information): We have a custom BIP report tha…A V K JAYA SURYA 147 views 1 comment 1 point Most recent by Iulian Hanza-Support-Oracle Reporting & Analytics for Sales
-
How to schedule a BI Weekly run of scheduled reportsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Is there a way we can add the link of Attachment in a report?Summary: is it possible to create a report that will include the link of attachment? Example an opportunity record have a document attached. we would like to create a re…
-
Facing an Issue to ge the PIM Default Buyer DetailsSummary: HI Team, We need to get the PIM Default buyer details to an Item. We have used the below query to get the buyer details. ( select max(ppn.display_name) from po_…Venkateswari 41 views 3 comments 0 points Most recent by Manali Biswas-Oracle Reporting and Analytics for SCM
-
Data type - HTMLSummary: We have a field with long description and the data type set as 'html' in the column properties , so now in the dashboard that field is displaying the data corre…
-
How to restrict Inventory Items or On hand data based on User data access role in BIP Reports?Hi All, We have a requirement to restrict the Inventory Items or On-hand data based on User data access role Org assignments through BIP Reports. Currently, we have buil…Nagaraju Vandavasi 21 views 5 comments 0 points Most recent by Nagaraju Vandavasi Reporting and Analytics for SCM
-
BI Publisher - Roles to Cancel Scheduled Job ReportWe are trying to cancel/delete an active scheduled job report. What are the roles we need to have the privilege to cancel the report job?
-
How can we enable audit in Fusion BIP layer to track who executed what query and when?As we do not have any way to restrict a user with Reporting and analytics access in Oracle Fusion to view data of certain tables. Hence, we're looking to explore the aud…PranjulG 41 views 1 comment 0 points Most recent by Swapnil Kashid Reporting & Analytics for Fusion Service
-
How can we export attachments from opportunity objectSummary: We want to know the process to export all the attachments from opportunity object. Content (please ensure you mask any confidential information): We want to exp… -
How to get details of ESS jobs and the associated logs into an onprem monitoring tool like SplunkSummary: I am trying to get details of the scheduled processes and its logs from fusion cloud application (specifically Subscription management cloud) into internal Splu…Kumar Masand 71 views 2 comments 0 points Most recent by Vijaya Sekhar A-Oracle Fusion Applications Administration
-
SCM reportingSummary Custom reports builtContent Our customer is using SCM and is not very pleased with the seeded reports in Oracle. Reports they are looking for are for example the…User_2025-01-28-02-43-26-951 157 views 6 comments 5 points Most recent by Mirza Muhammad Mohsin Baig Reporting and Analytics for SCM -
Access Custom Reports using REST/SOAP APIContent Can we access custom reports using REST/SOAP API? If so, please provide us some documentation on the same. Version Service CloudUser_2025-02-03-17-12-58-131 50 views 3 comments 1 point Most recent by Dave Mor-Dev-Oracle Reporting & Analytics for B2C Service
-
BI Publisher template builder for Excel and Word Plugin in Microsoft integrated appsHi Everyone, Our customer is moving to Microsoft integrated apps where all manual plugins will go away. Which means any plugin will be handled in MS Office 365 Integrate…Murugaganesh 1 view 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
Not able to print parameter values in BIP report, using if condition in Excel rtf templateUsing if condition in excel template had validated values if parameter is null , should return all as values selected is ALL, see below All But when i am populating spec…Shahid Qureshi 71 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Need PVO's for below Tables for BICC ExtractSummary: Need PVO's for below mentioned tables for BICC Extract: 1) gl_coa_tree_versions_aggr_dtls 2) hr_operating_units 3) gl_seg_val_hier_rfNiharika Paramkusam-Oracle 34 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
How can I dynamically count a column in OTBI?Summary: Hi, In OTBI, how will I be able to get the count dynamically per year when the data type is string, and the sample value is "ABC 2024". Here is my theory but it…Ivony Ann Paula Salango 91 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
DCL on OOTB Object doesn't show in OOTB subject areaSummary: Hi, I create a custom DCL on Activity Object. When I check the standard subject area (CRM - CRM Activity Real Time), I don't see this DCL in Activity Extension … -
Analysis Close Ratio by Trailing 12 MonthsHello, We are trying to create a dashboard that will show the close ratio - win vs loss - of each month as a trailing 12 total. We are looking to have the months as the …NAndrusick 21 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Way to export the OOTB attributes and descriptionHello, We have a requirement here to export the OOTB attributes and description. Need to know in which way we can achieve this. Any help relevant to above is appreciated…
-
Portuguese language conversionHi, We have a requirement to convert Receipt amount in words to PORTUGUESE language. How can we achieve this? Is there any possible way in BIP or rtf template? Regards, …Anusha DP 21 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
how to resolve usage of function count() does not include requested usage - filterSummary: how to resolve usage of function count() does not include requested usage - filter Content (please ensure you mask any confidential information): I am receiving…bosun 11 views 1 comment 0 points Most recent by Nika Gerson Lohman Reporting & Analytics for B2C Service
-
CDM: Unable to find hierarchy fields in Fusion back end tablesHello, In a requirement we are creating hierarchy in CDM through the import management. We are required to create a report based on the fields in the import Hierarchy an…
-
Can we build a BIP report for the child processesCan we build a BIP report for the child processes that are run after after load interface file for import.Shalini S 1 view 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Getting error when trying to fetch profile values in field trigger before insertHi Everyone, we are getting error when creating error after adding the below condition in if (oracle.apps.fnd.applcore.Profile.get("SERVICE_2_0_SR_LIST").contains(Catego… -
Reporting Time Between Chat EventsContent I've been tasked with creating a report to isolate the number of chats where there is no post by the end user within a minute of the agent interaction beginning.…User_2025-02-01-08-26-22-513 26 views 2 comments 0 points Most recent by OBerg Reporting & Analytics for B2C Service
-
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 11 views 2 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Not have Subject Area Receiving - Purchase Receipts Real TimeSummary: Not have Subject Area Receiving - Purchase Receipts Real Time Content (please ensure you mask any confidential information): Version (include the version you ar…
-
The File Was Not Downloaded or Was Not Downloaded Correctly - PO PDFSummary: I recently updated my PO PDF report template and uploaded it. When I try to view that in View PDF in front-end, it throws the error "The File Was Not Downloaded…Vigneshvaran KJ 1.6K views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM