My Oracle Support Banner

GL: Is There Any Program to Drop Temporary Tables Which Are No Longer Required? (Doc ID 416542.1)

Last updated on FEBRUARY 09, 2023

Applies to:

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


You have some interim tables in the system which are not dropped by the processes in Oracle General Ledger which created and used them.

Some of these tables can be identified using the following scripts:

Is there any Concurrent Request or Program which can help in dropping these tables which are no longer necessary.


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

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