Reporting and Analytics
Discussion List
-
How to compare current and previous data in OTBI?Hi All, We have a requirement where we need to fetch and compare the data (an attribute on employee assignment page, say Job or Position) on 2 different dates in OTBI an…Suyog 73 views 1 comment 0 points Most recent by Augustin Aravind-Oracle Reporting & Analytics for Fusion Service -
Cx - Dashboards are unable to be linked with or bring in.Summary: When a dashboard is filtered using Opportunity Number, automatically all the dashboards should get generated individually but not as a list form as shown in the…Nalsoft Pvt Ltd 31 views 4 comments 0 points Most recent by Nalsoft Pvt Ltd Reporting & Analytics for Sales -
Which table contains Credit Management, Credit scoring model detailsCould you please provide the name of the backend table where the details of credit collection data points, such as category, data point name, DataPointId, data type, and…Jeetesh Singh 1 view 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
Task number table to create value set for dffTask number table to create value set for dff in PO line level. I have tried: PJO_XCC_CTRL_BDGT_LOW_RES_V PJO_XCC_CTRL_BDGT_SEGMENTS_V PJO_XCC_CTRL_BDGT_LOW_TASK_V PO_DI…Rajat Pandey 21 views 6 comments 0 points Most recent by Rajat Pandey Reporting and Analytics for SCM -
Cx - Are predefined templates available for Sales in OTBI?Can we have predefined templates available for Sales in OTBI.Nalsoft Pvt Ltd 31 views 5 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales -
Is it feasible to customize print pick slip Report by adding new parameter?Summary: We have a requirement to add new parameter in the print pick slip Report. Is it possible to customize the data model and add the below parameter in the Report? …Abhiengine 63 views 1 comment 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM -
Assistance Required for Locating Tables and Differentiating Login MethodsWe are currently facing an issue where we are unable to locate the tables containing the following user details within our Oracle database: We could Identify some tables…Akhilesh_07 1 view 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
Assistance Required for Locating Tables and Differentiating Login MethodsI am currently facing an issue where I am unable to locate the tables containing the following user details within our Oracle database: I could Identify some tables that…Manan Khare 1 view 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
Cx - Can we develop blocks using OTBISummary: Can we develop the report by the following design using OTBI. Content (please ensure you mask any confidential information): Version (include the version you ar…Nalsoft Pvt Ltd 21 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
I am facing issue with one of my custom BI report developed to extract COGS Revenue & Margin!Hi Folks, I am facing issues with one of my custom BI report developed to extract COGS Revenue & Margin. While running the report from Data Model Schedule window, I can …Sravan Komminedi 31 views 3 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for SCM -
Can i link 2 report in a dashboard that has 2 different subject area?In an OTBI dashboard containing reports from two different subject areas, can I configure a drill-down functionality where clicking on an element in the first report fil…Omran Zeaiter 33 views 3 comments 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for SCM -
Requirement send standard GL Trial Balance Report output to Sftp server directorySummary: We have a requirement that the standard GL Trial Balance report output will be uploaded directly to more secure sftp server directory. There will be separate fi…Naga Peddiraju Chennu 11 views 7 comments 0 points Most recent by Prassanna_Srinivasan Reporting and Analytics for SCM -
Inquiring about business object in audit reportSummary: Hi team, Please help us with the following questions: 1. What kind of log will appear when Business object type is not selected and is blank? 2. Are there any b…Zafar Ara Nawreen 21 views 6 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for SCM -
how can i report on all the web pages including answershow can i report on all the web pages including answers possible on a site, along with the URL to reach it?spence_abcd0109uk 1 view 1 comment 0 points Most recent by Steve Garvert-Support-Oracle Reporting & Analytics for B2C Service -
Query to get Change Orders details like changed/updated data like PO amount, Invoice Number and InvContent Hello all, Can someone tell from where I could pick the details for Change Orders details for a Purchase Order which is in "Open" status and if changes are made … -
How to fetch audit logs for custom reports in analyticsHi All, Can we generate audit logs for the custom reports which are created in reports and analytics. Like, can we get the data of a custom report which we have created,…Nalsoft Pvt Ltd 31 views 1 comment 0 points Most recent by Prasanth Senthivel-Oracle Reporting & Analytics for Fusion Service -
My Team's Leads Tile - OOTB report is not showing proper data to the managers.Summary: My Team's Leads Tile - OOTB report is not showing proper data to the managers. Do we need to run any job? Path Sales/Embedded Content/ Sales Manager . Could you…NikhilSamudrala-Oracle 21 views 7 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Custom ESS job reflects in Scheduled Processes only to some users, and not other usersWe have developed a custom ESS job to Delete Draft Invoices and observed that this job reflects in Scheduled Processes only to some users, while few users are not able t… -
How to Customize the Asset Register Report to remove special characters from asset descriptionI have to update the Data model query for Asset Register Report as the report is reading the special characters in asset description and resulting in distorted format of…Shikha_Singh12 31 views 5 comments 0 points Most recent by Shikha_Singh12 Reporting & Analytics for Fusion Service -
I need Time Elapsed from Report run History in Fusion HCMI ran the report in Fusion HCM I need to know how much time taken to complete the report Is there any way to know how any records in report out put https://us.v-cdn.net/…Rama Krishna Annam 11 views 2 comments 0 points Most recent by Rama Krishna Annam Reporting & Analytics for Fusion Service -
how to restrict PII data in OTBI reportsHello, I am creating a report in OTBI and I am using these subject areas "Workforce Management - Person Real Time" and "Workforce Learning - Learning Records Real Time",…Joliver Caangay 11 views 1 comment 0 points Most recent by RajuT Reporting & Analytics for Fusion Service -
Chart not showing in bursting email in fusionDear Team, I have developed one report where we are showing chart in the output. Same output we are sending over the email through bursting query and the output is comin… -
Print to IPP printer using ExternalReportWSSServiceI am trying to print a pdf report using ExternalReportWSSService web service. The printer is configured correctly and I am able to print from BIP console, when using web… -
Table to check charges on field service work orcderHi Team, We need table to check the charges details on the field service work order. Please find the below scrrenshot. -
Is there any way to convert PDF file to PDF A3 format in Oracle Fusion CloudSummary: Is there any way to convert PDF file to PDF A3 format in Oracle Fusion Cloud or Using OIC Content (please ensure you mask any confidential information): Version…Raoof Ahmed 2 views 2 comments 0 points Most recent by Kishore Padala-Support-Oracle Fusion Applications Administration -
A seeded report has changed after Fusion update - Can we access it again?We had a recent update 23C and the report 'Inventory Valuation Report' has now disappeared and a new report 'Depreciated Inventory Valuation Report' has appeared. Howeve…Jim Jam101 11 views 2 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service -
Using SOAP Web Services to Automate the Promotion of BIP and OTBI ReportsSummary: We are in the process of migrating to Oracle ERP cloud and need to determine a process/tool to automate and provide version control around BIP and OTBI report m…MD-JMS 82 views 2 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service -
Can I dynamically mention the columns in PIVOT clause in a SQL query?This query is to be used in a BIP report. For Example: SELECT MONTH, AMOUNT, COLUMN_NAME FROM TABLE PIVOT(SUM(AMOUNT) FORM COLUMN_NAME IN ('COL_NAME1','COL_NAME2','COL_N…Aaron Paul 11 views 2 comments 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Fusion Service -
How to get a count of the knowledge articles currently available in Knowledge AdvancedSummary: I need to get a count of the knowledge articles currently available in Knowledge Advanced Content (please ensure you mask any confidential information): Version…Meera Saseendran T 1 view 1 comment 0 points Most recent by Steve Garvert-Support-Oracle Reporting & Analytics for B2C Service