Reporting and Analytics
Discussion List
-
How to show Date Format like 19 July 2023 in SQLSummary: Content (required): Need to display month in date field in SQL . EX: 19 July 2023 Version (include the version you are using, if applicable): Code Snippet (add … -
Is it possible to have the daily login and logout time of users in CXSummary: Is it possible to have the daily login and logout time of users in CX We need a report with below columns Username Date Time of Login Time of Logout User Email …
-
List of Values via SQL/Analytics Query - Oracle Sales Cloud (FUSION)Is there a way to extract/Query all Lists of Values via Analytics SQL Query or from a Task in Setup & Maintenance? We are trying to document this information in Oracle S…Christian Gerald Patacsil 71 views 4 comments 0 points Most recent by Christian Gerald Patacsil Reporting & Analytics for Sales
-
BICC costs to extract PVO from other serviceHi, As I am not sure on how particularly Oracle handles this area, I am trying to figure out the following scenario: we are trying to extract some data from Fusion using…Mihaela Matei 111 views 6 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales -
The selected Report Definition File is not a valid fileContent We're seeing an error "The selected Report Definition File is not a valid file exported by the Report Designer Export function, or the exported file has been mod…User_2025-02-01-08-53-02-236 50 views 9 comments 1 point Most recent by Utkarsh Dangayach-194615 Reporting & Analytics for B2C Service -
Fusion Applicationsは22AでBIツールが変わりますFusion Applicationsに22Aが適用されると、BIツールがリリースアップしてツールの名称が変わります: - BI Answer → Analytics Answer - BI Publisher → Analytics Publisher それに…Yumiko Uotsu-Oracle 301 views 6 comments 0 points Most recent by Yumiko Uotsu-Oracle 日本語Cloud HCMフォーラム -
Unable to see Mobile phone number in BI reportSummary: Unable to see in the report the contact Mobile number in the UI we are able to add mobile number however we can't see this field in any subject area is there an…
-
Need source of PO Charge account for OTBI reportSummary: what is the database source field for the PO charge account - would like to include in an OTBI report Content (required): PO charge account on the page - what d…Bernadette Dorris 41 views 6 comments 0 points Most recent by Bernadette Dorris Reporting and Analytics for SCM
-
How to show infolets on homepage of a mobile app?Summary: Hello, we have infolets on the web interface and we would like to use a few (1X1, 2X2) on the main screen of the mobile app. Content (required): how can this be…
-
Need sql query to get invoice number in fulfillment line detailsSummary: Need query to get invoice number in Fulfillment lines. Screenshot attached. Content (required): As business request we have to add invoice number to order fulfi…kalyan gade 1.1K views 2 comments 0 points Most recent by kalyan gade Reporting and Analytics for SCM
-
User wants to use BI PublisherSummary: Hi, There are 2 users in Oracle Application Cloud- kalam and rtokar. kalam can access and see data in OBIEE my folder where as rtokar can't do the same. The use…
-
Table/Subject Area name which stores data for RoutinesSummary: Table/Subject Area name which stores data for Routines Content (required): Hi All, I need to know the base table/subject area(OTBI) which stores the information… -
Can we get the deep links for import managementSummary: Can we get the deep links for import management in sales cloud. We checked under Tools- deep links but nothing is mentioned for import management deep links. Co…
-
Can we create report in OTBI where we can have the currency changed based on our requirement?Summary: Hi, I want to create a report in OTBI where I want to change the values of the currency field based on the currency I select. Say, the value in the currency fie…Gautam Buragohain 51 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Sales
-
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 31 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 71 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 50 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 141 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 31 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 907 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 131 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