Reporting and Analytics
Discussion List
-
which tables to refer to get Partner addressSummary: What is tables to get partner address?? partner +partner address Content (please ensure you mask any confidential information): Version (include the version you… -
How to send only one email notification to manager for leads unqualified for 30 daysSummary: We have a requirement to send email notification to manager if lead remains in unqualified status for 30 days after creation. We have tried using Routines and o…
-
Corporate currency conversion in OTBI reportSummary: We have multi currency enabled in application. In the Opportunity UI user's select the currency as required and go through the pipeline process to book/close op…
-
Get the source system of a merged contact recordSummary: Is it possible to get the source system of a merged contact record? We're aiming to use it for reporting. If feasible, which table should be used? There is colu…
-
Is there a table where we could query/retrieve the match configuration rule attributes for CDM?Summary: We've a requirement to create a report showing the match rule and the rule attributes. We can use ZCH_MERGE_DETAILS_B to get the match rule name for merged reco…
-
Most searched article OTBI ReportSummary: Hello , I am trying to create a OTBI report that lists Most searched KM articles. Tried using KM - Article search questions historical subject area , but doesn'…Lakshmi_Sasidharan 67 views 5 comments 0 points Most recent by Lakshmi_Sasidharan Reporting & Analytics for Fusion Service
-
We could not find the table for Log a Call functionalitySummary: We could not find the table for Log a Call on Activity and Notes Table where the details are available on NGS Smart Action. Can you please help us to identify t…
-
Eloqua Closed loop reportingSummary: Is it possible to use the standard report of Closed loop Reporting with CX Sales data but using OIC instead of CX sales integration app?CristinaMusso-Oracle 20 views 1 comment 0 points Most recent by Florin Musatoiu - Support-Oracle Sales
-
Is there a way to make the CSV Column stagnant and not change order of sequence?Summary: Is there a way to make the CSV Column stagnant and not change the order of sequence? We are extracting data from BIP Report and it seems that CSV Output have th…
-
Configuring a connection between LRU and Employee to get Tax Number of a Legal Entity.Summary: Content (please ensure you mask any confidential information): User would like to include in the report Unemployment Tax Number of an Employee. The Tax Number a…ChristianC 39 views 2 comments 0 points Most recent by Parag Hiremath Payroll and Global Payroll Interface (GPI)
-
OTBI analysis for count of lead createdSummary: Hi, I want to create an analysis to show all the names of users in a branch and count of leads created by them. Could you please help me to create this analysis…Anjanah Ganapathy G S S 24 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
How to migrate Redwood Sales Dashboard across instances ?Summary: We've built some custom Redwood Sales Dashboard Pages. (Metric, Contents Container) using Express Reports as well as Visualization Configuration. As Visualizati…
-
How can I access fusion OTBI report via restSummary: I am looking to be able to access an OTBI report from Fusion Sales via REST. Where is there documentation on how to do that? Content (please ensure you mask any…
-
Inquiry about "Item Change History" in Oracle CX SalesSummary: I am looking for information on which "subject area" I can find the "Item Change History" within Oracle CX Sales. I would appreciate any guidance on specific ar…
-
How do I change the resource organization hierarchy name?Summary: I am trying to rename some of my organization but unable to find where to do so. Content (please ensure you mask any confidential information): Version (include…
-
How to link dashboard prompts for custom AnalysisSummary: Hi Team, We have created two analysis. 1.To fetch the headcount of promotions w.r.t. their department 2.To fetch the data of drilldown includes 'Current Assignm…
-
How to enable group by for Visualization Configuration ?Hi team, We want to create a table using Visualization Configuration from OTBI analysis, where we need column 1 as Estimator(Owner) Name and column 2 as Number of Submit…
-
Ability to add BI report from custom object either using smart action or any related optionsSummary:Ability to add BI report from custom object either using smart action or any related options Content (please ensure you mask any confidential information): Hi Te…
-
Fetch all OTBI Reports custom adhoc & scheduledSummary: Would it be possible to generate a OTBI report that includes all system-generated of adhoc and recurring reports/views ? I have tried to use OTBI Usage Real Tim…
-
Opportunity Line Revenue exchange rateSummary: Hi, Does "Pipeline Detail Facts"."Opportunity Line Revenue" column uses exchange rates for non USD opportunities? Content (please ensure you mask any confidenti…
-
How can I create a report BI of notifications sent by service request workflow?Summary: How can I create a report of notifications sent by service request workflow? Content (required): Currently we are dispatching a series of notifications through …Camilo Martinez-114335 39 views 1 comment 1 point Most recent by Radhika Abhyankar-Support-Oracle Fusion Service
-
How to restrict data visibility across different Business Units in Oracle Sales ?Summary: Need to restrict data visibility (read/write both) for all the objects in Oracle Sales Cloud. (Leads, Opportunities, Service Requests etc.) Content (please ensu…
-
QyeryHI, I Need query for the shipment Planned vs Shipped in OTM. Please share if any one can. Thanks Sushil PandeySushil Pandey-277265 35 views 2 comments 0 points Most recent by AkshayThakur Transportation Management
-
How to import latest file from BI report to WCC to import management?Summary: we have BI Report, and we are exporting it to WCC everyday, and we notice that its Content ID is different every time, we are planning to create an automation t…
-
What is the best Subject Area to report on Eloqua Marketing and Outlook Activities in SalesSummary: We are looking to report on; Marketing events we send from Eloqua to CX Sales - like website visits, page opens, etc. Emails tracked in the Outlook for CX Sales…
-
Application Usage Insights Dashboard Not Showing Data - Missing ProcessesSummary: Prerequisites to setup AUI dashboard: Content (please ensure you mask any confidential information): I'm trying to set up and configure the Application Usage In…
-
What is the proper alternative to Adaptive Search aggregates Roll-ups is NOT itSummary: Roll-ups and Adaptive search aggregates (from what I understand) are not the same thing functionally. So if Adaptive Search is being deprecated, what do we use … -
BICC View Object encountering errors on extract.Summary: We would like to seek assistance on this Issue. BICC Extract is failing and upon investigation, removing the Role Code column in View Object ResourcePartnerPVO …Carlo Orolfo 36 views 3 comments 0 points Most recent by Carlo Orolfo Reporting & Analytics for Sales
-
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 142 views 1 comment 1 point Most recent by Iulian Hanza-Support-Oracle Reporting & Analytics for Sales
-
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…