Skip to Main Content

E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to extract GL data to provide to auditors?

JJ-USJun 6 2019 — edited Feb 9 2021

We're on EBS 12.2.5. Our auditors have requested data extracts of our Journal Entries, Trial Balance, Chart of Accounts, etc. Is there a standard way in Oracle EBS to do this? Any 3rd party tools?

Comments

715399
Hi Brian,

Do you still get the exception if you remove the DISTINCT keyword or add the ORDER BY variable to the select list?

Cheers,
Vladimir
715399
Hi Brian,

I just noticed you were using Jena 2.0. You also might want to try using the latest version of the Jena Adaptor (works with Oracle 11.1.0.7 and 11.2)

Cheers,
Vladimir
1 - 2

Post Details

Added on Jun 6 2019
3 comments
115 views