Reporting and Analytics
Discussion List
-
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 73 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 41 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
-
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…
-
Can you programmatically extract an audit log for narrative reporting?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Kunal Prasad 21 views 2 comments 0 points Most recent by Kunal Prasad Reporting & Analytics for Fusion Service
-
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…
-
Extract Oracle Fusion BIP Report's SQL statementsHi, Is there a way to extract the SQL statements out of .Catalog files ? or this information is stored in any of the XDO tables ? ThanksNagarajuKanukanti 124 views 1 comment 0 points Most recent by User759763-Oracle Reporting & Analytics for Fusion Service
-
Identify the Data Table and Column for Rule: Case.Email HeaderSummary/Content I am trying to create a report for cases that are coming from a specific email. Beside using the Rule Name (rule_log.rule_name), is there another table c…
-
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…
-
CRC 32 - Hash in Oracle fusionHello , We have one requirement where it has been asked to convert the 16 digits column value ( The site ID from Account Payable) into a CRC 32 HASH value. I did not fin…VarshaK 41 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
Getting Blank row when we unmerge the rows in FRS reprotWe ran the FRS report and exported the data to Excel. Once we extract we merge the rows and when we unmerge the rows one row is blank and it another we have a data.Surabhi 51 views 5 comments 0 points Most recent by Cătălin Hurjui-Support-Oracle Reporting & Analytics for Fusion Service