EBS Customizations (MOSC)

MOSC Banner

What is the best way to retrieve data from subledger for many years

in EBS Customizations (MOSC) 4 commentsAnswered ✓

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center