What is the best way to retrieve data from subledger for many years
We are using EBS 12.2.10 with database 19c (19.10.0.0.0)
We use a custom report which uses following subledger tables for difference modules:
XLA.XLA_TRANSACTION_ENTITIES
XLA_EVENTS
XLA_AE_HEADERS
XLA_AE_LINES
GL_IMPORT_REFERENCES
GL_JE_BATCHES
GL_JE_HEADERS
GL_JE_LINES
Our problem is we cannot run this report for longer period (1 year for example) it may have around 500,000 rows for AR receipts. If we run system gets hanged and DBA has to do some troubleshooting.
I want to know what may be best way to run this sub ledger report for any module (AP, AR, GL, FA, INV etc) for any given period.