My Oracle Support Banner

R12 Performance Issue in FDFCHY and GLSTFL Concurrent Processes After 12.2.9 Upgrade. (Doc ID 2806350.1)

Last updated on SEPTEMBER 12, 2021

Applies to:

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

Symptoms

Performance Issue in  FDFCHY and GLSTFL Concurrent Processes After 12.2.9 Upgrade
Recent upgrade from 12.1.3 to 12.2.9, and database upgrade from 12.1.0.1 to 19.0.0.0.0

Steps to replicate issue:

1. End-date one of the segment values that is linked to other segment values;
2. Save changes;
3. FDFCHY "Compile value set hierarchies" runs in 14 minutes;
4. GLSTFL "General Ledger Accounting Setup Program" runs in 8 minutes.

The same type of timings also happen if we remove the end-date from the segment values.

Every time changes are made to Segment Values linked to Chart of Account Segments, and the 2 jobs run, they take about 22 minutes to run from start to finish.

Tested running "Run Gather Schema Statistics" for the GL schema with these parameters:

Schema Name: GL
Estimate Percent: NULL
Degree: NULL
Backup Flag: NOBACKUP
Restart Request ID: NULL
History Mode: LASTRUN
Gather Options: GATHER
Modifications Threshold: NULL
Invalidate Dependent Cursors: Y

Running the job made no difference to how quickly the jobs ran.

Gather Schema Statistics runs on a weekly basis:

Schema Name: ALL
Estimate Percent: NULL
Degree: NULL
Backup Flag: NOBACKUP
Restart Request ID: NULL
History Mode: LASTRUN
Gather Options: GATHER AUTO
Modifications Threshold: 0
Invalidate Dependent Cursors: Y

Before upgrading to 12.2.9 this was not an issue and the requests ran under 1 minute.

Running the "Program - Optimizer" on a weekly basis with both parameters set to Yes.

Version 120.14.12020000.3 for file gluflshb.pls.

 
 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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