Reporting and Analytics
Discussion List
-
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 33 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 75 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 52 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 151 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 33 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 44 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 961 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 134 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 2 views 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~ 761 views 5 comments 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales