Reporting and Analytics
Discussion List
-
RTF Template output alignment issue with Outlook appHi Team, We have recently created a welcome letter using an RTF template, which includes a logo at the top followed by the details in the email body. When we check the o…Rakesh Bahadur Thapa 71 views 2 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
How do I Report on contact activity including appointments and emailsSummary: I am trying to get 2 reports: A report that shows all of the activities a Sales Rep did on a particular day - including: Appointments and emails sent - from bot…Tim Gruidl 81 views 8 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales -
How can we report on Users Last Login Date and Time?Summary: We often has scenarios where workers are terminated in the system after their actual finish date. This means that there is a window where users can access our s…Rebecca Hawker 181 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting and Analytics for HCM -
How to create a custom Smart List Analysis/visualization to use in Redwood DashboardSummary: Hi, we need to create a custom Smart List analysis/visualization to use in the Redwood Dashboard. Content (please ensure you mask any confidential information):…Max Prestes 31 views 5 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales -
Analytics Oracle Cloud error HRESULT: 0x800AC472Summary: HRESULT: 0x800AC472 At analytics report export into excel Content (please ensure you mask any confidential information): Has anyone ecountered this error? I tri… -
Need to schedule the ESS Job set in fusion to run on 1st business day of the month.We have a scenario where we need to run the ess job set on 1st business day of each month . is there any way apart from user schedule where we need to manually update th… -
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… -
NOT ALL ROLES are covered in Fusion Report "User and Role Access Audit Report"Hi everyone, just a question regarding the Scheduled Process: "User and Role Access Audit Report", do you know why some roles are not included in this report? ie "Applic…Lia Naga 93 views 1 comment 1 point Most recent by Cătălin Hurjui-Support-Oracle Reporting & Analytics for Fusion Service -
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… -
Pivot TableSummary: Hi, I need help with a report format. Object 1: Contains Question IDs Object 2: Contains Question IDs and Response fields We have a table that includes Question…Anusha716 41 views 5 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
How to create custom PVO and add it in BICCSummary: How to create custom PVO and add it in BICC Content (required): How to create custom PVO and add it in BICC Version (include the version you are using, if appli…Vivek Gautam 3.5K views 7 comments 1 point Most recent by Surendra Majeti Reporting & Analytics for Fusion Service -
I need to Create a report on a Contact where I have created a custom field for their managerSummary: I am trying to generate a hierarchal report on contacts within an organization. I have created a "Manager" field that links to another contact in Sales. I want … -
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… -
Customer Contact- Person Audit TableSummary: Dear Experts, We are seeking your valuable inputs to identify the Audit Tables that store information related to updates made to Customer -> Account -> Contacts… -
How to enable the BI label drop down on a descriptive flexfieldContent Trying to figure out how I can use the BI label field drop down box on the description flexfield segment area when creating a new attribute. Reading the configur…Chris C 638 views 2 comments 1 point Most recent by Sailaja Chillara Reporting & Analytics for Sales -
How can we migrate BIP scheduled jobs (Definitions) from one env to another env?Hi, We are refreshing multiple lower instances for go-live, and during this process, the BIP schedule jobs are not being migrated from the source to the target instance.…Praveen_Paul_raj 71 views 4 comments 0 points Most recent by Swapnil Kashid Reporting & Analytics for Fusion Service -
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… -
Query to get payment method field in Order Management in Oracle FusionContent Hi all, Can someone tell me from where I could pick the payment method field mentioned at the front end of the Order management page? I have checked for the tabl…Sushan Peiris 1.2K views 2 comments 4 points Most recent by Shishir Dhone Reporting and Analytics for SCM -
Digital Signature in RTF templatesSummary: Hi Team, Could you please advise on how to enable digital signatures in RTF templates that span multiple pages? According to the documentation, it seems we need… -
How can I add the current date to the file name on a scheduled reportSummary: I have a user who has a scheduled report which he receives as an excel file that gets forwarded to a Sharepoint directory automatically every day. The issue he …VivTed 199 views 3 comments 0 points Most recent by Shashidhar AM Reporting & Analytics for B2C Service -
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 61 views 5 comments 0 points Most recent by Lakshmi_Sasidharan Reporting & Analytics for Fusion Service -
Addins and WorkspacesI need to run a report which shows what all workspaces are having a particular addin.How to find out what all addins are used in a workspace? Regards, MeeraMeera Saseendran T 71 views 1 comment 0 points Most recent by Michelle Akin-Support-Oracle Reporting & Analytics for B2C Service -
I need to write a custom script in a reportI have a column which will shows some numbers. For example column A 45643746 464734329 Column will be like this. I need to show another column which will be result of co…Meera Saseendran T 31 views 1 comment 0 points Most recent by Anuj Behl Reporting & Analytics for B2C Service -
Log for user's navigation in Oracle FusionSummary: Hi all, please, I would thank any help with the following: Is there any log/table/trace, anything, that is able to reflect when user presses any of this buttons… -
Creating a Business Unit-Specific Lead and Opportunity Dashboard in Oracle FusionHi Community, I'm working on creating a dashboard in Oracle Fusion CX Sales to provide insights into lead and opportunity performance for specific business units. My goa…Fareeha Altaf 104 views 5 comments 0 points Most recent by Sheela Pai-Oracle Reporting & Analytics for Sales -
Need Table name where approver comments are stored.Summary: Im working on Employee Request Type Report where i need Comments column. Here comments column need to be the comment left by the approver while approving the re…Supraja Sunnapu 31 views 1 comment 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration -
How to get the SQL of a report made through Subject AreasSummary: We need to extract the source SQL code of a report made through subject areas Content (required): How can we get the source SQL code of a report made by subject…SERGIO BARRETO 708 views 9 comments 0 points Most recent by MFlannery Reporting & Analytics for Sales
-
Is it possible to create a security context in oracle cloud?I want to create that combo in oracle cloud: define a role with a security context that I create and security context valueACNROMA2023 41 views 4 comments 0 points Most recent by HimanshuSetia123 Reporting & Analytics for Fusion Service -
How to enable audit log in report and analytics.Summary: Is there any possibility to add audit log in report and analytics? For example: In objects(like Lead ,Opportunity ) there is a field which shows the value of la…ArjunReddy88 111 views 4 comments 1 point Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales