My Oracle Support Banner

How To Improve Fast Formula Performance (Doc ID 458448.1)

Last updated on JUNE 12, 2018

Applies to:

Oracle Payroll - Version 11.5.10.2 and later
Information in this document applies to any platform.
***Checked for relevance on 03-Jun-2016***
***Checked for relevance on 26-May-2011***



Goal

User experiences serious performance issue with Payroll Run. Found that

[1] Everything is defined as element, including those what is usually defined as an input value of
an element.
[2] 80-90% of the elements are defined as Information element.
[3] Have only one huge Fast Formula per Payroll.

The huge formula has 200+ lines for defaulting, and 200+ lines for Alias. Every time the formula is called by an element, will all the lines in the formula be processed? The performance trace of Payroll Run shows 99% of elapsed time used in the Formula call.

Solution

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

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


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