For partners that build or integrate commercially available applications and service solutions with the Oracle Cloud Platform
For partners that provide implementation or managed services around Oracle Cloud Applications
Hi Community,
We require a report which shows who has approved a Journal, please advise if this is available through audit trail or BI reports.
Kind Regards,
Comment
Hi Kunal,
You can create easily an OTBI report using General Ledger - Journals Real Time. It's under the Batch details and the column is "Final Approver".
Thanks
Average Rating:



2 ratings
|
Sign in to rate this
Of course you can also see it from the journal in itself under Show More > Action Log at Batch level
Average Rating:



3 ratings
|
Sign in to rate this
Transactional level audit not been enabled so you need to build you own custom BI Report else go with OTBI as per above comment by Julien.
Be the first to rate this
|
Sign in to rate this
Thanks guys... OTBI only seems to have the Final Approver ideally, it would be good if we could view every approver of the Journal for more complex rules or who it is pending approval with.
Be the first to rate this
|
Sign in to rate this
Nice to see your name pop up in Customer Connect Kunal
Be the first to rate this
|
Sign in to rate this
Likewise Janelle, I have found the community to be super useful
Hope you are keeping well
Be the first to rate this
|
Sign in to rate this
Kunal,
Your question sent me on a curiosity quest to see if this is something that could be done. The result of that quest is the below query. This query is by no means 100% complete, but it will pull the approval history of a journal showing all actions in sequence. I plan to clean this up to my business needs and share it with my team. Please feel free to take it an clean it up as necessary for your purpose. Thanks!
James
Average Rating:



1 rating
|
Sign in to rate this
Hi James,
This is great, thanks for sharing.
Be the first to rate this
|
Sign in to rate this