Incentive Compensation - EBS (MOSC)

MOSC Banner

Embedded Formula generates performance issues

edited Apr 24, 2013 8:00PM in Incentive Compensation - EBS (MOSC) 1 commentAnswered
 Hi everyone,
I have very complex scenario and the best way I found to represent it is by using formulas embedded within formulas. The problem with that is performance. Calculation process takes too much time because of this formula, as the same use other formulas within. Look into de Package created by the system, and have found that the formula uses a select to retrive a vuale, then when invoking the enbeded formula again uses a select to retrive the other value needed and so on with each formula embedded (have six).

So, in order to not open a lot of selects, is there anyway to save the result of that embedded formulas in other variable and not have to embeded formulas within  the parent formula?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Incentive Comp Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center