Is There Way to Join Subledger to Payables Invoices via Query?

Summary:

Is there a way to join Payables Invoices - Transactions Real Time to Subledger Accounting - Journals Real Time via a SQL query?

Content (please ensure you mask any confidential information):

We need to report the most recent coding for an invoice line and since our Accounting team is using the override function, there isn't a way to see what the most recent coding is when they override the same line multiple times in one day. In the Subledger - Journals Real Time subject area, there is an accounting date with a time stamp. But joining the two subject areas in OTBI results in an error.