EGL: Combo Build (FSPECBLD) Performance issues on Oracle 9.2.04

(Doc ID 635603.1)

Last updated on APRIL 29, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 8.4 to 8.4 SP2 [Release 8.4]
Information in this document applies to any platform.
SPECIFIC TO:´┐Ż´┐ŻEnterprise, Financials, General Ledger , Oracle

This document was previously published as Customer Connection Solution 200949887


***Checked for relevance on 04-FEB-2011***

***Checked for relevance on 08-OCT-2012***

Symptoms


The Combination Edit Build process is taking an excessive amount of time to run - when there is data already in the Combo Data Table and the Combo Build process is run.  

If the Combination Data Delete process is run for all Process Groups and the Combo Data Table is empty - the process runs quickly.  Once the Combo Data Table contains data, and users have added chartfields they need added to the table, if the process is run it generally times out and is unsuccessful.  

The performance issues appear to be related to a recent Oracle 9i Enterprise Edition upgrade from version 9.2.0.2.0 to current version 9.2.0.5.0.  

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms