Reporting and Analytics
Discussion List
-
How to make a custom report available in supply planning work area?Summary How to make a custom report available in supply planning work area?Content Created a custom report. Users want it to be able to open from the supply planning wor… -
Is there any subject area to get the Module to which each object belongs toSummary: What is the equivalent Subject Area for this table - adf_extensible_table_usage Content (required): 'adf_extensible_table_usage' has a column - 'Application_nam…Venkateswari 34 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
How to Generate a BIP Report in xlsx Format with 90+ Report FieldsSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Malavika Sairaman 78 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Listing Answers via report filterSummary Listing Answers via report filterContent Hello! I am trying to filter Answer IDs in a report, but the filter doesn't not seem to allow this when choosing "in lis…kerry walker 51 views 8 comments 0 points Most recent by User_3HDAP Reporting & Analytics for B2C Service -
How to adjust width of a column to wrap text in the reportSummary: This post is part of Service Request received :: How to adjust width of a column to wrap text in the OTBI report Content (required): In Reports, we are applying…Dimple-Nagesh-Support-Oracle 155 views 4 comments 0 points Most recent by Malavika Sairaman Reporting & Analytics for Sales -
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 34 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 113 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 43 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 43 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 73 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 1K 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 132 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 54 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 43 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~ 763 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 32 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 122 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 41 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 64 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 200 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales