Reporting and Analytics
Discussion List
-
Compensation History tables and dataHi All, I am unable to get the Compensation History data using below query. Can you please advise if anyone has the query or table accordingly. SELECT hth.transaction_id…Sai Shyam 41 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Fusion Service -
BIP report parameter is not working as expectedSummary: Hi All, For BIP report parameters, I have used the below part and it is not working as expected. When a period, CO, and Account parameter is given that time it …AKV27 13 views 1 comment 0 points Most recent by Sandeep19rm Reporting & Analytics for Fusion Service
-
Has anyone had success adding 3rd party UI/UX analytics tools to CX Sales?Summary: I'm interested to see if anyone has had luck connecting any 3rd party UI/UX analytics tools into CX Sales, such as Adobe Analytics or Mixpanel. I need to unders…
-
Authentication issueDear All, I am currently utilizing basic authentication (username, password) to invoke a report and retrieve data from Visual Builder through the SOAP API. However, we h…George Mattar 11 views 3 comments 0 points Most recent by Narendra More-Support-Oracle Reporting & Analytics for Fusion Service
-
Dashboard Filter in IST but results in ESTI have a dashboard filter that is run off IST time. Is there a way to modify the time zone in the dashboard filter? For Example: When entering a date range of 5/29/23 to…
-
Export Bulk dataContent Hello, I am trying to export bulk data. I want to build a scheduled process that runs every day and in case of an error, the next run will include all the data s…
-
Last activity date w/ owner of last activity by accounts reportWe have a number of reports on our OTBI Dashboards that looks at last activity by account by a few different categories. Recently we've felt that bringing in the name of…mfribeiro 21 views 5 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Count of Opportunity for a Custom ObjectSummary: We have created a custom object (Sub Account) and it is related to Opportunity. One Sub Account can have many Opportunities. We want to show the count of opport…
-
What are the differences between Redwood UI for B2B KM and Classic UI for B2B KM?Summary: Need to know in order to unferstand in a better way. Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code …
-
Report to find the number of times an opportunity close date is updated.Summary: Is it possible to create reporting in OSC to track Opportunity push counts. (Push count - Number of times an opportunity close date is updated) The two scenario…
-
Incident Attachment Audit Log?Summary: Is it possible to tell if/when an incident attachment was downloaded/accessed? Content (please ensure you mask any confidential information): We have a situatio… -
In OTBI, is it posible to center the bar on the graph if the second bar has no results?Summary: In OTBI, is it possible to center the bar on the graph if the second bar has no results? Content (please ensure you mask any confidential information): In OTBI,…Rubielyn Tomas 31 views 5 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
How to use ojDialog to display a message through a report analytics extension?Hello Community, I need to display an alert or messageBox to inform the attendant if the items they selected in the report are not valid to be processed by the add-in. H…Richard J Algarve 51 views 1 comment 0 points Most recent by Sreedev S-Oracle Reporting & Analytics for B2C Service -
I need to stop sending scheduled report if the report is emptyI have scheduled a report which is a error log. So that some days there might be empty report as there is no error. So that we need to stop sending scheduled report if t…Meera Saseendran T 11 views 4 comments 0 points Most recent by Meera Saseendran T Reporting & Analytics for B2C Service
-
how to track private note send or not in a reportSummary: I need to create a report for tracking the private note. There is an issue of private note is not sending. So I need to create a report for tracking private is …Meera Saseendran T 31 views 1 comment 0 points Most recent by michael garverick Reporting & Analytics for B2C Service
-
Redwood - Can we add OTBI Dashboards or Reports to Foldout Panel viewSummary: Can we add OTBI Dashboard or Reports as Redwood Foldout Panel. ? Content (please ensure you mask any confidential information): Version (include the version you…
-
java.net.SocketTimeoutException: Read time out - runReport ServiceSummary: java.net.SocketTimeoutException: Read time out - runReport Service Content (please ensure you mask any confidential information): We have a report created to ge…Nipuna Thandi Ashok 95 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
'Oracle Analytics Cloud Services' integration with IDCS - protocolsWe are having OACS instance which is integrated with IDCS out of box. We would like to know which protocol and encryption mechanism being used in IDCS(IAM) to establish …Shivaprasad Kamath 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
How to pull the report of the most searched phrases in chatbotHi Team, Can I get a chatbot report on the most searched phrases?& Have we made any changes to the chatbot since go-live? Thanks, AparnaAparna _ Mulluri-Oracle 21 views 1 comment 0 points Most recent by Dave Mor-Dev-Oracle Reporting & Analytics for B2C Service
-
Products/Items are missing from SiteSummary: Periodically our over night processes fail to update records because the item no longer exits in OCC ADMIN. When we send updates we do not send any default pric…
-
Is there a way to report who last updated a price on a sales order?Summary: Is there a way to report who last updated a price on a sales order line? I don't believe this 'price last updated by' field is within the Fulfillment Lines real…Andrew_Schmitz 1 view 2 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for SCM -
Functions/Query in OTBI report to seperate concatenated segmentsHi, I'm trying to separate the concatenated segments into individual segments. I would like to separate 6 segments. I found a few Oracle documents which have solutions f…Varalakshmi 12 views 1 comment 0 points Most recent by Anand DN-Oracle Reporting & Analytics for Fusion Service -
Custom report for agent productivity using Agent Transactions and Incident SourceSummary: Hi, I have been tasked with creating the below report. The theory behind it is as follows: Scope: CS teams Productivity per person is shown based on actual cont…
-
CRM Application Composer not available in Audit Reports Product dropdownSummary: Our Business team needs to be able to view Audit Reports for Custom Object as an alternative to the slow loading of Change History table for each object record.…
-
total column row should have only total amount valueSummary: In Report we are using Pivot table and there is amount column so doing total of the row , but the total row is giving again entire row values. Providing sample …
-
Trying to Find Table With List of JOB_TITLE_CODEs Appearing in Manage Contacts/HZ_ORG_CONTACTSSummary: I'm building a BI Publisher report that is pulling in the Customer Account Contacts, and am trying to find the table that has the list of Job Title Codes that a…
-
HIDear Community, Need some advice regarding the ADFDI software.. My company uses the Oracle ADF Desktop Integration Add-in for Excel , We are currently on version 5.1.5.2… -
Error in casting date in OTBI Reports ConditionSummary: I need to display a different formatting in date time. However, when I try to use the To_DateTime("Goals_c"."FacetoFaceMeeting1_c", 'YYYY-MM-DD') condition, it …zelagozum 33 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
How to create a Last Completed Activity in OTBISummary: I have created a report in OTBI using a custom subject area based on primary object Opportunity however there is one more field i would like to add to this repo…Jay Patel-157091 21 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
CRM Database Tables for via SQL/Analytics Query - Oracle Sales Cloud (FUSION)Hello, Everyone. Is there a documentation for Oracle Sales Cloud (FUSION) CRM Database Tables that can be used for SQL/Analytics Query. I am building a report where User…Christian Gerald Patacsil 93 views 2 comments 0 points Most recent by Christian Gerald Patacsil Sales