What's new in Customer Journeys?

Connect and learn more!
GL reports on multiple ledgers — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

GL reports on multiple ledgers

Received Response
edited Sep 25, 2020 6:04PM in Reporting and Analytics for ERP 2 comments


Our client has close to 40 million journal lines across ledgers for a single period.

They want a BIP report where they will only pass the ledger set and choose all ledgers within it (approx 10-15 based on the ledger set). Few other parameters are on the line level DFF which stores a description.

Though the report fetches only 100 lines due to the dff filter it runs for 15-20 mins to complete.

Question 1: Is it advisable to run custom BIP reports on either Journal or balances on multiple ledgers? (On all the seeded reports ledger set and ledger are mandatory paramaters). is there any oracle doc id which suggests not to run on multiple ledgers at a time?

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!