EGL: Combo Build (FSPECBLD) Performance issues on Oracle 9.2.04
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***
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 220.127.116.11.0 to current version 18.104.22.168.0.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms