You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Performance Issues with ODR

in Financial Consolidation and Close 3 comments

Summary:

Need assistance with optimizing ODR.

Content (please ensure you mask any confidential information):

We have created an On Demand Business Rule in FCCS and it takes too long (5+ hrs) to execute though it generates results as expected. Can someone guide on what might be causing this and how to optimize the ODR. We have tried running the rule with the system recommendations which were to

  1. SET HYBRIDBSOINCALCSCRIPT FULL;
  2. Use @CALCMODE(BOTTOMUP); for each Val_**** in the ODR.

However, even these system recommendations didn't help as we didn't get the output we desired and the rule still takes very long to run. Request someone to kindly help on this matter.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!