Invalid Payroll Transactions in the Subledger

Content

We have been up for a year on Oracle and have had a very rocky go of it.  We have about 50k (yep thats right) invalid transactions for 2020 in the subledger from payroll.  I need to identify those transactions so that we can complete a journal entry and then delete them out.

I created a report using the subledger subject area and I am able to get whatever details I need from that, but the transactions do not balance.  This is apparently because the particular transaction that failed does not have a gl string at all and doesn't seem to be in the subject area at all.  I took a look at the subject area for payroll costing and can get the transaction there, but harder to identify just the invalids and so I have millions of rows of transactions there that I definitely need to narrow down.  I also find that