My Oracle Support Banner

R12 Performance Issue for 'General Ledger Accounting Setup Program'(GLSTFL) and 'Compile Value Set Hierarchies'(FDFCHY) After 12.2.9 Upgrade (Doc ID 2806350.1)

Last updated on JANUARY 31, 2024

Applies to:

Oracle General Ledger - Version 12.2.9 and later
Information in this document applies to any platform.


Performance issue observed in Concurrent Processes 'Compile Value Set Hierarchies'(FDFCHY) and 'General Ledger Accounting Setup Program'(GLSTFL) after EBS version upgrade from 12.1.3 to 12.2.9 and database upgrade from to

Steps to replicate issue:

1. Go to General Ledger responsibility;
2. Setup - Financial > Flexfields > Key > Values;
3. End-date one of the Segment Values that is linked to other Segment Values;
3. The two concurrent programs run unexpectedly long and take a lot of time (for example: 30 minutes);

This issue can also happen if the end-date from Segment Values is removed.

Gather Schema Stats and Program - Optimizer (with both parameters set to Yes) run weekly for the GL schema with no improvement.


 EBS version upgrade from 12.1.3 to 12.2.9.

 Database upgrade from to


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

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

In this Document

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