1 person found this helpful
I'm not aware of a "standard way" to do this. I've always done it as you suggested with Trial Balance and Journal Reports.
You may want to ask your auditors what they are looking for. Your auditor may prefer Oracle standard reports, with proof they are unmodified, so they can make the assumption that if you are doing what all other standard users are doing, it's satisfactory. In that case, the standard reports in GL should give them what they need. Once in a while, auditors want confirmation of unexpected functionality, have reason to suspect the data on the standard reports, or find two standard reports that conflict, and they want basic data to be able to verify what the data really is. In that case, you could offer to write SQL queries and run them while they observe. In my experience, when we use a tool like OBIEE, Cognos, Discoverer, etc, it's actually harder because there are extra steps required by the auditors to prove the content of the reports, and that the reports haven't been modified. (Yeah, auditors are suspicious, but to be fair, it is in their job description)
If this is useful, please take a moment to select this response and mark it Helpful.