Reporting and Analytics
Discussion List
-
Multi Select field in UI returning Lookup Code in OTBISummary: We have this field in Sales UI having an FCL multi select in Division custom field. We have tried to add DESCRIPTOR_IDOF in this field however it is showing bla…Kelvin Jamil Reyes 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
How to get the status and log file for a child ess job using websericves.Summary: Hello, Team. Greetings for the day We have a requirement to send out the log file of a failed ess job, but in our case, the actual error log file is generated a…User_2025-10-24-00-15-43-324 248 views 1 comment 0 points Most recent by veerendranath pulivarthi-Oracle Fusion Service
-
using inc_performance type=7 gives duplicate rowsSummary: When adding the first closed date from the inc_perf table to my report, I get two rows for every solved incident, one with a closed date and one with no closed …
-
BI Publisher template builder for Excel and Word Plugin in Microsoft integrated appsSummary: Hi 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 …Murugaganesh 45 views 4 comments 0 points Most recent by Murugaganesh Reporting & Analytics for Fusion Service -
SCM seeded report including bin location and on order countI'm needing a SCM report that has the bin location, and also the on order count. Does anyone know of a report that includes these two fields or know of what table I can …JWilliamson 11 views 1 comment 0 points Most recent by SRGogula-Oracle Reporting and Analytics for SCM
-
Need OTBI subject area to fetch the Channel Revenue ManagementSummary: Need OTBI subject area to fetch the Channel Revenue Management Content (please ensure you mask any confidential information): I am new to SCM modules. Any input…
-
SQL query or Table for Cost Accounting DistributionsSummary: Hi Team, Need a table which stores the information of Cost Accounting Distributions. Required columns: Run control, preprocessor, Cost prcocessor, Status, Cost …Opkey PA 64 views 2 comments 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Service Infolet doesn't show dataSummary: Hi I am trying to activate the infolets to make use of the analysis of the service team. But I can't find any documentation that allows me to make the settings …Johannys Lozano 53 views 1 comment 0 points Most recent by Daniel Placinta -Support-Oracle Fusion Service
-
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 141 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 42 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 23 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 42 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 3 views 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 65 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 33 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 92 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