Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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
Get Started with Redwood for Oracle Cloud HCM   Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.

For more information, please refer to this announcement explaining best practices for getting answers to questions.

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!