GP-MEX: Cobol Error When IMPUESTO EST Has More Than 1 Instance (Doc ID 1458851.1)

Last updated on JULY 06, 2016

Applies to:

PeopleSoft Enterprise HRMS Global Payroll Mexico - Version 9 to 9 [Release 9]
Information in this document applies to any platform.

Symptoms

When Global Payroll Mexico is run for one employee that has IMPUESTO EST deduction positive input the following error occurs.

Application Program Failed
In Pgm Section : GPPUWAIN: HA000-EXECUTE-SQL
With Return Code: 00805
Error Message : ORA-00001: unique constraint (SYSADM.PS_GPMX_ST_TAX_WA) violated

The issue can be reproduced at will with the following steps:

  1. You have a payroll identify and calculated
  2. Choose a employee that have an amount calculated on IMPUESTO EST deduction
  3. In One Time(Positive Input) Page enter a new row for IMPUESTO EST with action type ADD and enter certain amount
  4. Run the payroll on Calculate absence and Payroll page and go to process monitor
  5. You can see the instance got an Error on the Cobol process

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms