Reporting and Analytics
Discussion List
-
How to use date_add(date, units, interval, round)?Summary How to use date_add(date, units, interval, round)?Content In Incident table for column "incidents.updated" output is "2020-08-20T 08:33:23Z" but expected Output …ShivajiLohar 70 views 1 comment 0 points Most recent by Yashwanth Siddaraju Reporting & Analytics for B2C Service -
Show null value as blank is not working for report columnSummary Show null value as blank is not working for report columnContent I have built the report for incident table and I need blank value for null column. Here null val…ShivajiLohar 38 views 2 comments 0 points Most recent by User_2025-02-03-22-07-33-802 Reporting & Analytics for B2C Service -
Outbound interface to fetch records from FBDI Template which are ProcessedSummary Outbound interface to fetch records from FBDI Template which are ProcessedContent Hello Tech Gurus, I am new to Oracle Cloud.I have a requirement for outbount in…User_2025-02-05-23-01-57-438 44 views 1 comment 0 points Most recent by RaviThejaDarbha Reporting and Analytics for SCM -
Using Report Management Module (RMM) To Find Reports - Analytics Cookbook RecipeContent Using Report Management Module (RMM) To Find Reports: Finding reports in Oracle Service Cloud is possible in the Reports Explorer, but it can difficult if report…Kenny Tietz-23935 256 views 6 comments 13 points Most recent by User_2025-02-03-17-31-49-785 Reporting & Analytics for B2C Service -
Incident product number reportSummary We tried checking product/incident tables there it shows product_level as product description whereas we are expecting as product number. –Kindly let us know if …ShivajiLohar 39 views 7 comments 0 points Most recent by Robert Surujbhan-Oracle Reporting & Analytics for B2C Service -
Bursting sending duplicated reports.Summary Some outputs are being sent duplicted (or more!) by mailContent I have a report to get the hand quantity for each subinventory. The output is like: SUB ITEM QTY.…User_2025-02-07-06-48-26-537 28 views 2 comments 0 points Most recent by User_2025-02-07-06-48-26-537 Reporting and Analytics for SCM -
Lead Owner in Sales subject areaSummary Lead Owner in Sales subject areaContent Hi all, I need to add the Lead Owner in an analysis. Name or First Name/Last Name (not your Resource Id or Party Id). I h…
-
OTBI - Table or view does not exist at OCI CallSummary Unable to generate risk management report from standard subject areaContent We are trying to generate an analysis report for "Risk Management Cloud - Compliance …Yasir Humayun 37 views 3 comments 1 point Most recent by Yasir Humayun Reporting & Analytics for Sales -
Agent Overview InfoletsSummary Agent Overview Infolets - showing "1 Record"Content I am fairly certain I know this "1 Record" means the report is bulling back 1 record with the intended total …Jeff Scrobel 26 views 1 comment 1 point Most recent by User_2025-02-01-08-46-19-550 Reporting & Analytics for B2C Service -
Join Incidents table with answer details tableSummary Join incident table with answer details tableContent We have saved docId in custom object and mapped it to incident. We want to build a report to join incident t…Utkarsh Dangayach-194615 48 views 2 comments 0 points Most recent by Utkarsh Dangayach-194615 Reporting & Analytics for B2C Service -
Report To Display Parent Incident RecordsSummary Child Incident need to show all other incidents related to one parent incidentContent Hi, I have custom incident report which display all related incidents belon…Baljeet Singh-231094 48 views 3 comments 0 points Most recent by Jayant Singh-120650 Reporting & Analytics for B2C Service -
Working with Third-Party Files in your CX Commerce StorefrontSummary How to upload and manage third-party files such as Google Search and Apple Pay certificates used in your CX Commerce StorefrontContent The Oracle CX Commerce ser… -
Is it possible to show partner deatils in accountSummary We need to show related partners of account from PRM in account 360 in subtabContent Hi, We have an requirement to show the list parters who worked on the leads … -
Aging Report frp the Service Request using OTBISummary I want to Create one Time Trend Analysis, which have weekly, Monthly , quarterly and annually based values of SR Created and Closed.Content I want to Create one …Preethi nair 14 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting & Analytics for B2C Service -
Agent Workspace Report - display user running reportContent Hi all, I have a requirement to run a report based on the Contacts table, and at the end of the report I should output who ran the report. So it needs to look so… -
Data Dictionary ReportContent Hi, is there any way to create a Data Dictionary report with detail and hierarchy to export?User_2025-02-03-18-56-40-556 54 views 3 comments 0 points Most recent by JBaxter Reporting & Analytics for B2C Service -
Time with Customer vs. Time with AnalystSummary Time with Customer vs. Time with AnalystContent We would like to have two columns on a report to indicate how long a case was with a customer vs. time with an an…JLFolkman 36 views 3 comments 2 points Most recent by JLFolkman Reporting & Analytics for B2C Service -
Rolling Last Day of each Month ReportingSummary End of Month ReporitngContent We have a requirement for an end of the month report. It should show all closed Opportunities and Revenue on a rolling month to mon…Tod 32 views 2 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales -
How to Print the attachment in PO ReportSummary We have a requirement to get the attachment from a PO should get displayed on the View PDF document. Kindly SuggestVersion 11.13.20.04.0Yogesh Kumar-234569 132 views 3 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for SCM -
Report on Unresponded TicketsSummary Editing a ticket without responseContent There is a situation where the customer updates the ticket multiple times before getting a response. Can we develop a re…Boby B Jacob 24 views 2 comments 0 points Most recent by Justin_D Reporting & Analytics for B2C Service -
Hide row if column contains a duplicate valueSummary Hide row if column contains a duplicate value in incident ref # columnContent Hi all. We have a report used by numerous agents. The report has a drill down based…User_2025-02-01-08-17-38-818 55 views 8 comments 1 point Most recent by User_2025-02-01-08-17-38-818 Reporting & Analytics for B2C Service -
Generating a indented BOM list report.Content Hey there, I'm trying to generate a report with the indented list of a BOM. In Oracle 10 we had fields to build the structure based on a starting node and then j…User_2025-02-07-06-48-26-537 155 views 4 comments 0 points Most recent by Ahmed Mousa Reporting and Analytics for SCM -
Business Unit field in Opportunities and Leads - BI (Oracle Business Intelligence)Summary Business Unit field in Opportunities and Leads - BI (Oracle Business Intelligence)Content Hi all, I have an analysis for Leads and another for Opportunity create…
-
How to get Notes data for Business Plan and Objectives using ReportsContent Hi, How to fetch Notes data for Business plan and objectives using reports. We have created custom subject area for Notes objects and can see business plan and o… -
Need OTBI RpdSummary Need OTBI RpdContent Hi , I believe if we install BI Apps (OBIA) we can get RPD which has OTBI subject areas. Can some share OBIA/OTBI Rpd. I am mainly looking f…User_2025-01-29-21-55-25-526 59 views 3 comments 0 points Most recent by Karina Ogata Reporting & Analytics for Sales -
Access PermissionSummary i need to give one user read only for Purshase and Sales OTBI reportContent Hello i have one use , this user is not have license to Order management module and p…Mahgoub S.Mohamed 34 views 3 comments 0 points Most recent by Karina Ogata Reporting and Analytics for SCM
-
Logical SQL > WITH clause (Subquery Factoring)Summary how to use the WITH..AS clause (subquery factoring) in OBIEE logical sqlContent Hi community, I like to implement subqueries (WITH..AS) using logical sql in OBI … -
Sales – CX Sales Innovation Roadmap, 28 August 2020, 8 a.m PT - Submit QuestionsContent Submit your questions for the Sales – CX Sales Innovation Roadmap session to have them answered during the live event. Post your questions by posting a new comme…