How To Improve Fast Formula Performance (Doc ID 458448.1)

Last updated on JANUARY 05, 2017

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

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 hundreds of Community platforms