|
Administrator
|
Currently there are no methods for purging or archiving XLA it seems..
Any Available Method of Purging XLA Tables? (Doc ID 1111390.1)
R12: How to Archive / Purge Data From XLA / SLA Tables ? (Doc ID 452896.1)
There is an Enhancement Request though.. "6316302 - REQUIREMENT TO ARCHIVE AND PURGE THE XLA/SLA TABLES..
For EBS in general you have;
Reducing the Oracle E-Business Suite Data Footprint(Doc ID 752322.1)
Purging Strategy for E-Business Suite(Doc ID 732713.1)
If you have other purging or archiving needs, you may need to check the exact methods according to the module/product that you are looking for.. For instance, to archive GL Balances and Journals -> How to Archive And Purge General Ledger Balances and Journals (Doc ID 145707.1)
So these methods are specific...
As for the XLA; there are some bugs (fixed by patches) that cause high number of rows recoded in XLA tables .. Ref: R12 AP: Invoice Validation Performance And Excessive Huge Archive Log Generation (Doc ID 1339345.1)
So being in the latest patch level is always an advantage.
|
Locked
