Reporting and Analytics
Discussion List
-
how can we get the user activity log in sales cloud ApplicationSummary: how can we get the user activity log in sales cloud Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code s… -
Distinct Records in Consolidated DashboardHi, I have 2 reports with same columns & filters from different tables. I want to combine into one report. I am using Consolidated Dashboard option with distinct values …Mohana Gopal S-Oracle 32 views 1 comment 0 points Most recent by Junie Rose Bodoso-Support-Oracle Reporting & Analytics for B2C Service -
convert date formatSummary: Need help with date formatting Content (required): substr(fleff.attribute_char5, 1, 10) to only display as MM-DD-YYYY Below is the query: SELECT substr(fleff.at…kalyan gade 111 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
We would like to be able produce reports in the past.Summary: We would like to be able to produce reports in the past. For example, the report gives the latest data, but if we wanted to export that same report with past da…Siddharth Bhamare 41 views 2 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Sales
-
Looking for a way to run an article history from AnalyticsSummary: I am trying to create an article-history in Analytics, much like the history shown in the knowledge advanced editing-tool. Started out with creating a report ba…Marco Klomp-223061 41 views 2 comments 0 points Most recent by Marco Klomp-223061 Reporting & Analytics for B2C Service -
How to invoke a BIP report with parameters from Oracle cloud ERPSummary: Can we invoke a custom BIP report with parameters from the items application page. Content (required): We want to call the report in the same way as how the Gen…Neela.Voduguru 71 views 1 comment 2 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM
-
Turn Around Time calculation with 60/60/10.5 Extending Response TimeSummary: I'm trying to extend the response times to incidents. Not able to find anything in any forum that can assist. As example what I'm trying to accomplish here is w…
-
Incident's assigned account email addressHi, I'm using Accounts table to get the email address of the agents assigned to incidents. However, the email address being pulled per case/incident don't show the email…
-
How do you export a list of custom reports from OTBI?Summary: I need to export the list of custom reports created in OTBI, to manage the content and clean up the list of reports available. Content (required): Is it possibl…Jim Forsythe 883 views 6 comments 1 point Most recent by Jim Forsythe Reporting and Analytics for SCM
-
Is it possible to view change history of objects in OTBI and via REST?Summary: Is it possible to view change history of objects in OTBI and via REST? Content (required): We would like to see what details were changed on some objects we hav…User_2025-03-07-05-55-29-886 135 views 7 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Sales
-
Mask/Hide OTBI File Path Location on Browser Address BarSummary: Trying to find a way to hide/mask the OTBI file path location shown on browser address bar to minimize unexpected attack from anyone. Content (required): We jus…Karen Benita 51 views 3 comments 0 points Most recent by Swapnil Kashid Reporting & Analytics for Sales
-
Report which would give us info that fields on object (say contact) are filled or NotSummary: We need to come up with report which would give us information that fields present on object (say contact) are filled in or not considering all records. For exa…
-
Different filename based on a parameter value of report using ESS jobHi All, How to achieve custom filename using report parameter value as part of filename Example: ABC_XYZ_Timestamp.xml or ABC_XYZ_Timestamp.csv ABC is part of the file, …Swapnil Kashid 1 view 1 comment 0 points Most recent by Swapnil Kashid Reporting and Analytics for SCM -
Help with report creation to trace the queue from client on Right NowSummary: Hi! Well, I'm are trying to assemble a report in Right Now that followed the history of queues that a chat went through, containing the source and destination q…Evandro_MN 41 views 2 comments 0 points Most recent by Evandro_MN Reporting & Analytics for B2C Service -
Calendar Start Date use as Server Variable for Dashboard PromptSummary: Our Calendar Year starts from every 1st of Oct month as example currently it is 1-Oct-2022. I am creating a dashboard prompt and want to populate Start Date of …
-
Unable to Export Assets using Export ManagementSummary: Whenever we are trying to export Assets using "Export Management" functionality, the Exported data file does not get generated even though the export is success…
-
Need Query to pull the item costs for the refurbished SKUsSummary: Have a requirement to find the item costs for refubrished SKUs Content (required): Query to pull the item costs for the refurbished SKUs Version (include the ve…
-
After 23B release upgrade, why BIP report is not throwing any error for Mandatory Parameter?Summary: After 23B release upgrade, why BIP report is not throwing any error for Mandatory Parameter- with "can select All" option? Oracle Fusion Application- BI Publish…UM~ 743 views 5 comments 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales
-
How to apply data security for sql Queries in Data sets to be like custom subject areas?Summary: I need to apply security part for the SQL Queries Content (required): We have reports for custom objects, these reports Data models created by SQL Queries, We a…Mohamed Shaaban-Oracle 31 views 4 comments 0 points Most recent by Mohamed Shaaban-Oracle Reporting & Analytics for Sales
-
Application usage reportHow long the audit data has been captured without doing any configuration related to the application usage insights? What is the minimum time period (days/months/years) …Sangeetha Kumar 121 views 8 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Application Performance Monitoring for Commerce CloudOracle's Application Performance Monitoring tool is now configurable with Commerce Cloud via the Admin console! Attached is high level summary APM guide for commerce whi… -
Its important to know How to solve invalid path when unarchiving reportSummary: We need to move report from one instance to another but the system showing invalid path Content (required): Version (include the version you are using, if appli…K.Sh 47 views 5 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Archived Incidents transaction reportingSummary: Reporting on Archived Incidents access usage stats using transactions table Content (required): Has anyone had success reporting on Archived Incidents access us…HelenH 61 views 3 comments 0 points Most recent by Steve Garvert-Support-Oracle Reporting & Analytics for B2C Service
-
Restricted Access to Reports and AnalyticsSummary: Hello All, I have a requirement where users should be able to access all reports and analytics in OTBI but should not be able to access any objects in Fusion Ho…Manju_Bujendra 172 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales
-
Is there any way that we get Inventory transaction details with Serial numbers using Inventory SubjeSummary Is there any way that we get Inventory transaction details with Serial numbers using Inventory Subject AreaContent Is there any way that we get Inventory transac…User_2025-02-04-07-31-55-085 86 views 3 comments 2 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
Help with If statementSummary: Help with If statement Content (required): Hello, I'm trying to update the column of a report with this logic - If the count of the answer views is great than 1…kerry walker 91 views 10 comments 0 points Most recent by kerry walker Reporting & Analytics for B2C Service -
Dashboard Report to pull today only closed incidentsSummary: Daily Closed with Drill Down Level Report. Trying to make it to pull only current date closed with relative since is Dashboard Report and no filter should show …
-
Data Security Policy Mapping for Leads in the UI and OTBISummary Using different security in OTBI to HCM Cloud Content Would it be possible for you to give me an example of this solution: https://community.oracle.com/customerc…
-
System Report OptimizationSummary: I have report that is prebuild (before my time). Is working in the console but not in the BUI and currently trying to find ways to rebuild or filter it to show …