Temporary tables XLA_GLT_%used in the GL Transfer process are no longer cleared down once the transfer is complete.

Need to clear all temporary tables to reclaim space in database.

These tables are named XLA_GLT_% where % is the group_id used in the General Ledger Transfer.

Solution:
Register the new concurrent program as follows:
Login to the application as System Administrator responsibility.
Nav:Security/Responsibility/Request
Open the Request Groups form.
Query for the 'All Reports' Request Group for the respective Application ( like payables, receivables etc ).
Add the program "Purge Temporary Journal Import Interface Tables Created By Subledger Accounting" (Subledger Accounting application) to the above request group.
Save.
Run the new concurrent program XLADRPGLT: Purge Temporary Journal Import Interface Tables Created By Subledger Accounting

Please ensure to purge last year financial year.

Show less

http://allappsdba.blogspot.in/