EGL: Questions About PS_CLOSE_LEDG_LOG Record Growing Large
Last updated on MARCH 31, 2017
Applies to:
PeopleSoft Enterprise FIN General Ledger - Version 9 to 9.2 [Release 9]Information in this document applies to any platform.
Goal
The PS_CLOSE_LEDG_LOG record is growing by the year, causing significant performance issues with the GLPCLOSE process.
This table seems to hold data for each FISCAL_YEAR
- What is the significance of this table? How is it used?
- What is the need to hold data in this table for previous years?
- Can data be deleted that is over 2 years old?
- What is the significance of the index on this table? What is it specifically used for? Can it be dropped?
Solution
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