You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Invalid Payroll Transactions in the Subledger

edited Jan 14, 2021 10:04PM in Reporting and Analytics for HCM 2 comments

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!