Saturday, June 1, 2019

ORA-00001: unique constraint (SYSADM.PS_GP_PI_GEN_SOVR) violated in Global Payroll

This error usually occurs when the COBOL process GPPDPRUN errors out and we run it again on top of that. It basically tries to insert the same set of rows on the payroll processing tables with the earlier set of rows already present. And when it does that it throws the UNIQUE CONSTRAINT error.

The first thing that we need to do is check the process log where we will get the clue as to where exactly process failed. Important thing to notice here is, if you process the payroll through streams then it's better to check which particular stream caused the COBOL to fail. Once the stream is located then just cancel that particular stream and re-run it, the error will be gone.

However, if the payroll is processed without streams then the whole payroll needs to be cancelled and re-run which will resolve the issue.

9 comments:

  1. Useful information,unique constraint violated in global payroll,Know the importance and role of pay roll software,Payroll Management Software is used by companies to help manage the computation and reporting of employee’s salaries efficiently and accurately. Are you looking for best Payroll Software India? Then allsec is one of them, helps you to manage attendance, leaves, payroll etc.

    ReplyDelete

  2. Nice Blog!! Pioneer E Solutions one of the best custom HRMS Software Development companies in India. This helps to manage from Recruitment to performance. We provide you the best HRMS software that helps you manage your employee's information, attendance, leaves, salary, and other HR management system.

    ReplyDelete
  3. It is useful for my education and will be helpful also for my future on going through your blog on global payroll. And please do go through our other links and services.

    Payroll Software india
    Payroll Management Software
    Payroll Outsourcing Services 

    ReplyDelete
  4. wow thanks for sharing this helpful article about payroll management software really that's an amazing article about payroll software, I want to really buy this product for my restaurant. thanks again buddy

    ReplyDelete
  5. Thanks for your marvelous posting! I really enjoyed reading it, you can be a great author.I will remember to bookmark your blog and may come back sometime soon. I want to encourage that you continue your great posts, have a nice holiday weekend!
    organisational development Perth

    ReplyDelete
  6. Good day! This is my first visit to your blog! We are a group of volunteers and starting a new initiative in a community in the same niche. Your blog provided us valuable information to work on. You have done a marvellous job!
    Expert HR Services Perth

    ReplyDelete
  7. With havin so much content do you ever run into any issues of plagorism or copyright violation? My site has a lot of unique content I've either written myself or outsourced but it looks like a lot of it is popping it up all over the web without my agreement. Do you know any methods to help reduce content from being stolen? I'd genuinely appreciate it.
    Expert HR Services Perth

    ReplyDelete