Reporting and Analytics
Discussion List
-
Error encountered when running custom BI Report in Reports and AnalyticsError Details: "):access denied ("oracle.security.jps.JpsPermission" "AppSecurityContext.setApplicationID.") Navigation: Tools > Reports and Analytics > Shared Folders >…Ora_MCastillo 32 views 3 comments 0 points Most recent by Ora_MCastillo Fusion Applications Administration -
how to enable add existing option in contact tabHi, How to enable the option for add existing contact in a workspace.? Regards, MeeraMeera Saseendran T 51 views 2 comments 0 points Most recent by Jess Campbell Reporting & Analytics for B2C Service -
Time is being omitted in OOTB ESS Job Employee Vacation and Delegation Rules ReportHello, Does anyone know why the time from XML output of the report gets omitted? When we set a vacation rule in BPM, it includes both date and time. We need the time sin…Peps 51 views 4 comments 0 points Most recent by User_CHLT4 Reporting & Analytics for Fusion Service -
restriction of 'in list' operator in analytics reportContent Hi all, just would like to know, if there is any restriction related to the in list operator in Analytics, e.g. length of the parameter/value, or amount of param…User_2025-02-03-17-17-22-167 25 views 5 comments 0 points Most recent by Jess Campbell Reporting & Analytics for B2C Service -
How to restrict the access folder level in BIP ReportsCould you please advise if there is an option to grant the permission only one folder (Eg: Pyables Custom) . We’re looking to ensure users cannot view or access for any …Linga Murthy 11 views 2 comments 0 points Most recent by Linga Murthy Reporting & Analytics for Fusion Service -
What all roles has BI Consumer Privilege?Summary: We have created a copy of the Employee role and removed the analytics permissions from it. However, we would now like to grant analytics access to only a few se…Anusha716 89 views 2 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
OTBI Analytics >CX sales FusionSummary: In OTBI Analytics > Administation > Manage Priviliges If there is a Change in Sections like Catalog, Access , in the Manage Priviliges set to certain roles whic…Prabha.R Oracle-Oracle 11 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales -
Remove - replace URL in threads.noteHi, I'm working on a custom report that includes the threads.note field. Here’s a sample of how the conversation looks in that field: Agent: Hi how may I help you? Anony…Feyza Yılmaz 21 views 2 comments 0 points Most recent by Feyza Yılmaz Reporting & Analytics for B2C Service -
What is the OTBI item for "Organization" (under PO schedules)?We are trying to create a report that pulls the Ship-to location, PO number, and receiving organization (see above) to see where we have mismatching values (Ex: NATHW sh… -
How to access Data Model via API?Summary: How to access Data Model via API? Content (please ensure you mask any confidential information): Hi, our customer have external dashboards, using PowerBI, and t… -
Get Work Order Details for a Service RequestHi We have a requirement to get the Service Request details along with the associated work order detail in a report. A possible join can be the the SR Number and Work Or… -
What would be the reason of showing the Enterprise Quarter as null in Analytics- Sales CRM PipelineSummary: Eventhough the Accounting calendar is setup with proper periods & quarters; Calendar profile option also set to the configured. The opportunity records are show…Cyriac Mathew-Oracle 21 views 2 comments 0 points Most recent by Cyriac Mathew-Oracle Reporting & Analytics for Sales
-
Filtering NULL values in a dashboard promptSummary: Hi, I need to be able to filter for NULL values in a dashboard. Specifically, I have a filter on Gender, which can be NULL or Male/Female, for example. If I use…Guido Masciello 43 views 2 comments 0 points Most recent by Guido Masciello Reporting & Analytics for Sales -
How to Enable Membe Opportunity Visibility Across Multiple Organizations in Standard Sales Security?Hi, We’re working with standard sales security in Oracle Fusion Sales (not using Advanced Sales Security or Enhanced Territory Management) and facing a visibility issue … -
Open-source fonts to replace licensed Monotype fonts in BIP and OTBI in 24AIn 24A, open-source fonts will replace the Monotype fonts currently available in Oracle Transactional Business Intelligence. You can use the open-source fonts available …Noelle Bartlam-Oracle 22 views 2 comments 1 point Most recent by ravikiran goda-Oracle Reporting and Analytics for SCM -
How to get the assignment number from the time card entry page ?I have a requirement to get Assignment_Number from time card entry page and not on person level. please find screenshot for reference.AbhinavA 22 views 1 comment 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
sales dashboard metric currency is always in USD.Summary: We have enabled the Sales Dashboard Metrics (For eg: Pipeline and Team pipeline). This calculates the Sum of all Revenue Amount of the opportunities. This value…A V K JAYA SURYA 41 views 3 comments 0 points Most recent by Naveen Marujolla Reporting & Analytics for Sales -
We need a dynamic GIF Image send over emailWe need a dynamic GIF Image which is like a video image to be incorporated and send over email to employees on their birthday.Shaarif_Hussain 1 view 2 comments 0 points Most recent by Loo Alex Reporting & Analytics for Fusion Service -
C5ISR Audit (User Access and Behavior)We need to create BI report(s) that include as much of the FUNCTION information below as possible for audits. Already finding some useful data in the ASE_USER_LOGIN_INFO…Rob Turner 11 views 1 comment 0 points Most recent by Wendy Horowitz-Oracle Fusion Applications Administration -
Can Oracle Application Performance Monitoring (APM) track user events similar to Google Analytics?I'm exploring the capabilities of Oracle Application Performance Monitoring (APM) and I'm curious if it can track user events in a manner similar to Google Analytics. Sp… -
Page Break function not working for excel(MHTML) output formatHi Team, The customer wants to redevelop the Excel template report (with multiple tabs) into an RTF template, as the Excel template only displays 65K records per tab. We…Somasekhar Basetty -Oracle 11 views 1 comment 0 points Most recent by Rizwan.Ahmed009 Reporting & Analytics for Fusion Service -
Is there a way to hide the views menu option from the My Approval Search page?We just want the users to see the quotes needing their approvals and limit their access on searching and filtering quotes from other regions and other sales users. -
In Fusion HCM How can we check what security roles are assigned to user and who has assigned them?How can we check what security roles are assigned to user and who has assigned them?vikash4rv 51 views 4 comments 0 points Most recent by veerendranath pulivarthi-Oracle Fusion Applications Administration -
How download a BI report in PDF Output using Smart Action on redwood page?Summary: On a CX Sales Redwood page, we’ve added a “View PDF” smart action button. The requirement is that when the user clicks this button, it should trigger a BIP (BI …Ashu Singh 52 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service -
Query to get Applied prepayment amountSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Ritu123 46 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service -
Update ATTRIBUTE column value(to ASN#) in WSH_DELIVERY_DETAILS table after Ship confirmSummary: Can we update ATTRIBUTE column value(to ASN#) in WSH_DELIVERY_DETAILS table in Fusion after Ship Confirm business event? Content (please ensure you mask any con…Khalida Raffath 11 views 1 comment 0 points Most recent by Khalida Raffath Reporting and Analytics for SCM -
How Can I Show BOM Level Information for Each Item in a Report?I’m encountering an issue and would appreciate some guidance. I need to display the BOM in the report with the level information, and I’ve attached a picture for referen…Dinar 86 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
Querying 'Entered Unit Cost' and 'Material' from the 'Rolled Up Cost' ViewSummary: I need to make a query and retrieve the 'Entered Unit Cost' and 'Material' from the 'Rolled up Cost' view, but I'm not sure which table I should use to obtain t…Dinar 6 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM -
While I am using (AP_INVOICES_PKG.GET_POSTING_STATUS( aia.INVOICE_ID ), the query is processing onlyWhile I am using (AP_INVOICES_PKG.GET_POSTING_STATUS( aia.INVOICE_ID ), the query is processing only and at least I am getting timeout error. Here is my query. Can you p…