Reporting and Analytics
Discussion List
-
How to get latest updated records from ess_request_history ?Summary: Hi team, We are building a report using the ess_request_history table, where I need to fetch incremental records based on a timestamp filter. However, I couldn’… -
How to get all the Queues & Resources assigned dates for a Service request in OTBI Analytics reportSummary: Hi Team, As per the requirement, we need to create reports with the list of resources assigned to the SR with the assigned dates and the same for Queues. Could …Nikhil_Samudrala 61 views 4 comments 0 points Most recent by Nikhil_Samudrala Reporting & Analytics for Fusion Service -
Internal Server Error while calling /biacm/rest/meta/export APISummary: We are encountering an Internal Server Error (500) while trying to get a response from the API endpoint /biacm/rest/meta/export. Has anyone faced a similar issu…PremC 12 views 1 comment 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration -
Looking for file path of Audit Report in Oracle FusionSummary: Hi All, We would like to customize "Generate Audit Report" the seeded report provided by Oracle, kindly help us with the report files path so that we can custom… -
CX Sales Dashboard control by which role and privilegeSummary: There is no CX Sales role assigned to user but still they can see the dashboard in landing page, want to know which role or privilege provide this access. Also … -
Finish tab in custom script reportSummary: Can any one help us how we can use custom script in service cloud report Content (please ensure you mask any confidential information): We have successfully abl…Santosh kumar purusottam 21 views 1 comment 0 points Most recent by Nika Gerson Lohman Reporting & Analytics for B2C Service -
Extract Transfer Order Line DFF using BICCHi, We have a reqiurement to extract the DFF information for Transfer Order lines using BICC. We could able to find the below PVO for extracting the transfer order line … -
Create sequential number for each row in OTBIneed help generate a sequential number for each row when we run or open Result in OTBI.Peter Obong 11 views 3 comments 0 points Most recent by Massimo D.-Oracle Reporting and Analytics for SCM -
Inquiry on Standard Report for Tracking Manually Released Invoices by UsersSummary: Is there a standard report available in Oracle Cloud OTBI/Scheduled Processes that tracks and reports invoices manually released by users within a specific peri…Temi A. 1 view 1 comment 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration -
How to hide "Reports and Analytics" for a user.We have a requirement to create a custom role a specific user to run only programs using Scheduled Processes. But we are also seeing "Reports and Analytics" even without…Sadanand Gunda 62 views 5 comments 0 points Most recent by James McBride Fusion Applications Administration -
How to retrieve full update history for a specific Opportunity via OTBIThe business requirement is to retrieve all records/updates (audit history) related to a specific Opportunity in Oracle Sales Cloud, using OTBI. Required fields to be re…Paraskevi Thanasi 82 views 6 comments 0 points Most recent by Paraskevi Thanasi Reporting & Analytics for Sales -
Documents required for integration of fusion Audit log with SPLUNK.Summary: We are trying to integrate Audit and Admin user activity logs to a log monitoring tool call as SPLUNK. Help us with some documents around the integration is the…Poonam Yadav 37 views 1 comment 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration -
Fusion Application Performance MonitoringSummary: We have an initiative and plan to run approximately 40 BIP scheduled reports concurrently, and we wanted to assess any potential impact this could have on the u…JEngalan 27 views 2 comments 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration -
BI publisher: EText Condition Fails with Slanted Apostrophe in XML TagsSummary: I'm encountering an issue where my EText template condition does not work as expected due to a mismatch between straight single quote and slanted apostrophe in …Sudeepto 21 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for SCM -
Exporting Report to Data CSV that will used Business View Display Name for Column HeaderSummary: I created a Data Model, in which i update the Business View Display Name as show below However when extracting a report based on this data model in CSV it alway…Dennis AM 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Direct page link/navigation to the Custom object subtabHi All, I have custom object Name: "ParentObject" and this object having child object "ChildObject". I want direct url to open the childObject record… -
How to run territory assignment job with multiple view criteria parametersSummary Multiple view criteria in opportunity territory assignmentContent Hello Experts, While scheduling the territory assignment ESS job, we have requirement to schedu… -
Reporting comments made by candidatesI need to report comments left by the candidates (via Oracle Analytics) who withdrew their application. So far I have tried to filter for the 'Candidate withdrew' Curren…Anna Somogyfoki 12 views 1 comment 0 points Most recent by Dawn C-Support-Oracle Reporting and Analytics Taleo Enterprise -
[EPBCS][Metadata]-Identify Parent become Lev0 member post hierarchy changesSummary: “Is there a way to identify metadata, such as a project’s parent member, where a stored property became a Level 0 member after all its children were moved to an…Muni Kumar Vellure-Oracle 11 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
What is the right query using sql to get the right status of an account (Customer)i need to create a report using data model, in my requirement i need to select only active accounts in analysis it only shows active account but in sql it show all, even… -
Time Gap Between ESS Jobs in Job SetHi Team, I have a Job Set with two ESS Jobs, and I need the second job to start 1 hour after the first one finishes. And also wanted to know what the maximum amount of t… -
BICCSummary: Initial synchronization for large tables using BICC Content (please ensure you mask any confidential information): Our implementation involves several large tab…SunilRamankutty 42 views 2 comments 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration -
How to build a report to show as when a specific report has been run and at which time?**This post was created as part of a How-To Service Request (SR) Summary: I need to report to show as when a specific report has been run and at which time. Version (inc…Priscila Terazawa - Support-Oracle 61 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
How to add total in custom reportHi, Like above report, I need to show total in a report. How to do that? Regards, MeeraMeera Saseendran T 21 views 1 comment 0 points Most recent by Anuj Behl Reporting & Analytics for B2C Service -
Can we change the PO PDF Report Output name?Summary: Hi All, The requirement is to change the PO PDF report output name. Content (please ensure you mask any confidential information): Version (include the version …Dhilip Kumar P. 53 views 2 comments 0 points Most recent by Tapas_Sathua Reporting and Analytics for SCM -
Reset POV in EPM Narrative ReportingIs it possible to custom code a button into EPM Narrative Reporting that will enable a report user with View access to reset their POV to default on any given report? -
How to optimise a report to improve performance?Summary: We have a report related to Sales order & shipping details, which takes a lot more time than usual to load the parameters & also to fetch the required info even…Rudra_2024 11 views 3 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for SCM -
NRCS Roleaudit Report Download using Batch scriptHi All, I have created a batch script to download the RoleAudit report for NRCS. The report downloads successfully when I run the individual commands one by one. However…