Performance when extracting journal entries

Kazuam Yuasa

I am having trouble with poor performance when extracting GL journal entries.
The number of journal entries is about 5 million per month and it takes a long time to output reports from BI Publisher due to the data volume.
If you have any examples of how you solved the problem of poor performance caused by the data volume of journal entries, please share them with us.

Sumanth V -Oracle

@User_EPSPW -

Could you please share the application details you are using? Specifically, is it OTBI or FDI?

Thank you!

Kazuam Yuasa

Hi.

I am using OTBI.

Sumanth V -Oracle

@John Hung-Oracle - Please assist in moving this thread to OTBI community. Thank you!

@User_EPSPW - For any queries related to OTBI in future, please use the dedicated OTBI Community linked below. This community is specifically focused on FDI/FAW products.

Thank you for your understanding!

https://community.oracle.com/products/oracleanalytics/categories/otbi

Kazuam Yuasa

Sorry.

I will be careful in the future.
Thank you.