Reporting and Analytics
Discussion List
-
Video: Create a Report in Express ReportsCreating new reports in Express Reports From the Express Reporting series https://videohub.oracle.com/embed/secure/iframe/entryId/1_pnmcsh8y/uiConfId/35965902 -
REST API for FDI Fusion Data IntelligenceIs there a REST API available for FDI (aka FAW)? We have a requirement to initiate an incremental refresh of the FDI data after a specific event in an OIC orchestration.…TimMcK 464 views 2 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
Fetch all report catalog objects - GL_FRC_REPORTS_BSummary: Fetch all report catalog objects - GL_FRC_REPORTS_B Content (please ensure you mask any confidential information): We are looking for a way to query all the cus…KDR 290 views 6 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Audit log for custom ObjectsHi, We have created custom objects and using Redwood UI to manage the records. We have enabled all the objects and its attributes for audit log under manage audit polici…Jaymin Kansara_31 57 views 2 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Fusion Service
-
About displaying reports from Inforet in Sales CloudI have created a link to a report by setting the path to an existing report in the inforette on the Sales Cloud home page. When viewing the report, is it possible to hav… -
Report to count responses but include incidents with no responsesSummary: I need a report that shows all the incidents with a count of responses for the ones that have responses, but includes those incidents that don't have responses …
-
Default report in navigation setHi, I need to findout which is the default report in a navigation set. Is there any way to find out using a report? Regards, MeeraMeera Saseendran T 21 views 1 comment 0 points Most recent by Gabriela Musat-Support-Oracle Reporting & Analytics for B2C Service
-
customscript in reportsSummary:Hi, How to know which all reports are using custom script?any way to find via report? Thanks Content (please ensure you mask any confidential information): Versi…Meera Saseendran T 31 views 1 comment 0 points Most recent by Tushar G Reporting & Analytics for B2C Service
-
Avg Time to Resolve (In Hrs)Summary: We are using the "CRM - CRM Service Request Summary" table to prepare service request data using reports. As part of that, there is a report that provides week-…Anusha716 11 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Add the users based on roles in Agent in analyticsHi Team, we are currently adding or removing the users in the agent in analytics individually. Is there a way to add or remove the users based on their resource role in …Haider Saifee 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Filter by age of Lead record in RedwoodSummary: We're trying to add a visualization on our landing page dashboard in Redwood (My Open Leads) that is based on how old the lead is. We tried to use a Group by fi…
-
Is there a way to compare data models?Summary: We have two custom data models that I suspect may not actually have been customized (but they are in the Custom folder). Is there any way to compare a Custom to…Jessamyn Donovan 21 views 3 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Role required to Search for Report JobsSummary: User X (with BI Admin role) is unable to search and view BI report submitted by user Y. Content (please ensure you mask any confidential information): User leil…Shubhojit 52 views 3 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Cloned ESS Job not populating job parametersSummary: Cloned ESS Job not populating job parameters Content (please ensure you mask any confidential information): we cloned a seeded ESS job 'Journal Entry Reserve Le…KDR 117 views 9 comments 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
fetch product image in RTF Template BIP ReportSummary: How to fetch and show the product image in RTF template Content (please ensure you mask any confidential information): We are trying to fetch the product image …
-
Sql to get the item structure for a particular revision in Oracle fusion cloudHi All, Item structure and component details can be extracted from the following tables - egp_components_b , egp_structures_b. Each item has multiple revisions like A,B,…Gurujothi D 573 views 4 comments 3 points Most recent by Hugo Martínez Reporting and Analytics for SCM -
How to find a contact if logged in through sso or email?Hi, I need to know a contact is logged in using sso or email id. How to find that? Regards, MeeraMeera Saseendran T 31 views 3 comments 0 points Most recent by Nika Gerson Lohman Reporting & Analytics for B2C Service
-
Is it possible to report on the value in the Staff Account Profile Session Timeout field?Summary: Is it possible to report on the value in the Staff Account Profile Session Timeout field? Content (please ensure you mask any confidential information): I need … -
How to create BI report/analysis based on external data?Summary: Is it possible to create report/analysis based on external data, such as an external ERP system? What options does Fusion have for this kind of connection? Is i…Max Prestes 41 views 1 comment 0 points Most recent by Jain Piyush-Oracle Reporting & Analytics for Sales -
How to cancel or terminate all scheduled ESS jobs or BIP reports in bulkSummary:How to cancel or terminate all scheduled ESS jobs or BIP reports in bulk Content : We are reimplementing the Oracle SAS Fusion Financials & Procurements Common M…Singh Rupak 180 views 1 comment 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
When does data move from WFTASKHISTORY to FND_BPM_TASK_HISTORY_B table?Summary: We are no longer able to fetch approvers name in report using FA_FUSION_SOAINFRA.WFTASKHISTORY table. It looks like Approvers information get archived to FND_BP…Chandrashekhar_Cholli 135 views 2 comments 0 points Most recent by Chandrashekhar_Cholli Fusion Applications Administration
-
ESS API to submit job or retrieve job output in non-default formatI am looking for a way to retreive a non-default formatted output for an ESS job through an API. I need to submit the actual parent ESS job that runs the BI report for t…Grant Abbondanza 43 views 5 comments 0 points Most recent by Grant Abbondanza Reporting & Analytics for Fusion Service
-
How to get primary contact details of Partner in SQLSummary: Hi, I am working on partner object to get primary contact details of partner. not possible to get in SQL. Need to get 1.primary Contact Name 2. primary contact …
-
OTBI Succession plan - can't find fieldHello, I am working on an OTBI analysis and I'm having struggle finding some date fields. The subject area I have chosen is Workforce Succession Management - Plan Candid…Sara Suleiman 11 views 2 comments 0 points Most recent by veerendranath pulivarthi-Oracle Fusion Applications Administration
-
Dynamic LOGO in BIP report Oracle fusion is not workingWe are trying to achieve dynamic logo in BIP report according to BU. We have around 25 BU and each of them has its own logo. Approaches tried:- 1) Using subtemplate Whil…Sateesh Kumar 51 views 3 comments 0 points Most recent by Praveen Kumar Ponnusamy Reporting & Analytics for Fusion Service
-
How frequent views are refreshed from actual table, whether generic views rule applicable for fusionSummary: How frequent views are refreshed from actual table. Whether generic views rule applicable for fusion. We should use views or tables for frequent data retrieval …
-
Sales - CRM Resource is showing value of 'not found' in the Hierarchy Level.Summary I had some changes to use the new role as the resource role and with that there is a change in the Organization field. After that, the Sales - CRM Resource which…Cristelle Rose Sampang 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Prompt variable in SOAP executeXMLQuery requestWe have a report on which i have added a prompt variable to filter based on the email address. This works in the report itself: But when i try to get the report data usi…