My Oracle Support Banner

Users Have Slow Performance When Attempting To Use Prompts That Use Custom Formulas (Doc ID 2594542.1)

Last updated on SEPTEMBER 30, 2019

Applies to:

Oracle Fusion Sales Cloud Service - Version and later
Information in this document applies to any platform.


A custom analysis has been built that uses a timestampdiff formula to calculate how many days past due an Opportunity is. the formula was then put in a prompt for users to use to filter the data in their dashboard. when using an admin user to view the LOV in the prompt, there are no performance issues and the dropdown shows values in a matter of seconds. when using a sales Rep, Manager, or VP user to look at the same prompt, the performance is very slow and takes about 2-3 minutes for the drop down to show values.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.