Oracle Cloud offers a broad portfolio of software as a service applications, platform as a service, and social capabilities, all on a subscription basis. Oracle Cloud delivers instant value and productivity for end users, administrators, and developers alike through functionally rich, integrated, secure, enterprise cloud services.
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Subscribe to the OracleAppsHub to receive notifications when there are new posts:

 get RSS feed
 Oracle Fusion Applications (OFA) is a portfolio of next generation suite of software applications from Oracle Corporation. It is distributed across various product families; including financial management, human capital management, customer relationship management, supply chain management, procurement, governance, and project portfolio management
 Get a Free Magzine ...Profit:The Executive's Guide to Oracle Applications

Understanding “GL Program Optimizer”

Posted on February 19th, 2011 by Sanjit Anand |Print This Post Print This Post |Email This Post Email This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today

It is one of the performance improvement tools(mimics a cost-based optimizer.) in Oracle EBusiness within GL product ,that is available to the GL super user responsibility. It has two major functions:

  • Collect statistics to aid in the running of FSGs and GL posting
  • Build indexes on gl_code_combinations where they do not exist.

When you run this program, it collects and stores information on the spread of balances in gl.gl_balances which is used by both the GL posting program and FSGs. Given that the number of balances in gl.gl_balances increases each month with the month end roll process, it is important for the overall performance of posting and FSGs to keep the GL program optimizer stats up to date.

dgreybarrow Running the Program
This program is run by logging onto the GL super user responsibility and then running the concurrent program - GL Program Optimizer.

When running the GL Program Optimizer there are two options:

  • Collect Statistics (Default Yes) -Set this value to Yes
  • Rebuild Indexes (Default No) - Set this value to No

The GL Optimizer, when run with Gather statistics checked, will populate the gl table GL_SEGMENT_FREQUENCIES with current data in regard to your GL_CODE_COMBINATIONS and GL_BALANCES tables. This data is used in some gl programs to maximize performance

dgreybarrow How often often GL Program Optimizer be run?

You should run the GL optimizer at least once a period or after creating a large number of segment values, defining a new chart of account.It better set this up as a scheduled job to be run once per month, a couple of days after the month end roll over.

The GL optimizer is designed primarily to make FSGs run faster. Its recommend that for validation of flexfields, you also create a non unique concatenated index on the account segment, followed by all the other defined segments in flexfield order.

Anyone have more experience with this program , share your input:)

Related Posts

Posted in Oracle General Ledger | 1 Comment »Email This Post Email This Post | Print This Post Print This Post

Have you tried OracleappsHub in ipad/iphone/smart Phone? Don't wait. try it today
One Response
  1. Inder Says:

    Can you contact me, would like to discuss further.

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.