EGL: Questions About PS_CLOSE_LEDG_LOG Record Growing Large (Doc ID 2250473.1)

Last updated on FEBRUARY 04, 2019

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

	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

Goal

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.

EGL: Questions About PS_CLOSE_LEDG_LOG Record Growing Large (Doc ID 2250473.1)

Applies to:

Goal

Solution

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

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