"Were you able to find a resolution? From what I gather, it sounds like a major clean up process. I agree with Derek, this is a very complex problem, especially since the direct deposits no longer match the pay data. In the future, depending on the…"
A Social Network for PeopleSoft Professionals
Oscar Garcia's Discussions
SQL update payroll check data
Started this discussion. Last reply by Angela Morehouse-Brown Oct 28, 2009. 3 Replies 0 Likes
Our Payroll dept ran payroll last week and found out later that they had about 1200 checks wrong. There was an overpayment on an Earns Code. We are in the middle of an Open Enrollment and too many…Continue
Oscar Garcia's Page
Gifts Received
Oscar Garcia has not received any gifts yet
Latest Activity
Oscar Garcia replied to Oscar Garcia's discussion SQL update payroll check data
"Derek,
did open a case with Oracle, because of all the amounts (tax, flsa rates, YTD totals...), the off-cycle was not going to give us what we needed. I restored a copy of prod right before we confirmed and ran the missing job. Since I have all…"
PSoftPros replied to Oscar Garcia's discussion SQL update payroll check data
"Hi Oscar,
Your problem seems rather complex for a simple SQL Update. Given that there are so many tables involved, including tax tables, etc.. I would highly advise against performing a SQL Update. If you have not done so already, log a case with…"
Profile Information
- How many years of PeopleSoft experience do you have?
- Over 10 Years
- What PeopleSoft applications does your company use?
- Human Capital
- What is your expertise?
- Developer, System Admin, DBA
Latest PeopleSoft Jobs
PeopleSoft Finanical HR/Payroll 8.9
Calabasas , CAPeopleSoft Administrator
Brooklyn , NYPeopleSoft DBA(Oracle)
Lisle , ILPeopleSoft Senior P/A(Financials)
Bridgewater , NJPeopleSoft Manager IS
Chicago , ILPeopleSoft Books
Events
© 2012 Created by PSoftPros.
