Tag Archive: General Ledger

XLA_GLT Tables Not Being Dropped in EBS 12.1.3

The Problem Recently I was going through a list of our top largest tables in our E-Business Suite (12.1.3) database ( and found many tables in the GL schema that began with XLA_GLT_*.  Looking into this further I found over 300 of these tables (which also had indexes and synonyms) consuming over 30 Gigs of space.     Research After doing some research on My Oracle Support I found several articles that helped explain what we are seeing.  One of them in particular was a direct match to our problem, “SLA: Temporary Tables XLA_GLT_ % Are no Longer Dropped (Doc…
Read more