Reporting and Analytics
Discussion List
-
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 194 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 33 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 101 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 32 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 701 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
-
How to define a custom field which its LOV is dependent on another field in the formSummary: Custom field added to form should hold LOV based on a query dependent on another field in the form Content (please ensure you mask any confidential information)…Michal Shaked 141 views 3 comments 0 points Most recent by Amr Hassan Reporting & Analytics for Fusion Service -
Archive/Unarchive permission to My folders onlySummary: BI Administrator role generally gives archive/Unarchive access to entire catalog. Here the requirement is for few users, we would need archive/Unarchive permiss…Karthik Soundarapandian1 71 views 3 comments 0 points Most recent by Karthik Soundarapandian1 Reporting & Analytics for Fusion Service -
Knowledge Base Report - answers.updated field no longer workingVersion 23D I have an issue with a KB report where the answers.updated field is not being updated on some KB's and won't show up on the report. Here's the audit log of o…Joe P. 41 views 1 comment 0 points Most recent by Michelle Akin-Support-Oracle Reporting & Analytics for B2C Service -
Define Custom Summary BoxesSummary: Create custom Summary Boxes to be displayed on the Overview page of Accounts and Contacts Content (required): I see a list of OOTB summary boxes we can add but … -
i need to show only the incident' which having incidents.closed==transactions.createdSummary: What is the condition for show only the incident' which having incidents.closed==transactions.created. Content (please ensure you mask any confidential informat…Meera Saseendran T 31 views 3 comments 0 points Most recent by Meera Saseendran T Reporting & Analytics for B2C Service
-
how to capture case closure done through multi editI need to create a report to capture the details of incidents which are closed via multi edit. How to track this transaction?Meera Saseendran T 31 views 2 comments 0 points Most recent by Meera Saseendran T Reporting & Analytics for B2C 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…
-
Table Industries CRM SALESCordial greetings Please help me to identify the table that brings the Industries field data from the account in oracle cloud sales. Thank youJhonattan Diaz 11 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
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 11 views 1 comment 0 points Most recent by Florin Musatoiu - Support-Oracle Sales
-
How WFTASK to FND_BPM_TASK_B and WFTASKHISTORY to FND_BPM_TASK_HISTORY_B tables mapDear All, We are looking proper documentation for mapping WFTASK to FND_BPM_TASK_B and WFTASKHISTORY to FND_BPM_TASK_HISTORY_B because we are facing the issue when we ar…RajuT 1.2K views 4 comments 1 point Most recent by Swapnil Kashid Fusion Applications Administration
-
how to improve the OTBI analysis export record limit?Summary: Hi Guru, we created an OTBI analysis using the standard data model, but looks like it can only support to export 250k records, is there any way to improve that …JasonZzl 42 views 7 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM
-
How to remove the restriction preventing a user from accessing data within an OTBI report.Summary: I have a dashboard containing multiple reports. While the user can access some of these reports, others display errors such as "view error" or "error getting dr…Omran Zeaiter 61 views 4 comments 0 points Most recent by RyanPasca1 Reporting and Analytics for SCM
-
What other default jndi connection is available in Oracle fusion?If you navigate from BIP screens Adminstration page into Data sources, in the JNDI section, we can add the AuditDB connection(jdbc/AuditViewDB). What other DB connection…Earth place 1 view 1 comment 0 points Most recent by veerendranath pulivarthi-Oracle Fusion Applications Administration
-
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…
-
Changes to DM is not reflecting in FTP Schedule ReportSummary Changes to DM query is not reflecting in FTP scheduled reportContent We have scehdule FTP report based on data model. Recently we made changes to that data model…
-
Service Usage Metrics Per User ReportSummary: Service Usage Metrics Per User Report Content (please ensure you mask any confidential information): Hi Could you help me to know if there is any report that pr…Jazmin Saldierna 51 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
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 21 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales