SQL Error: ORA-00001: Unique Constraint (SYSADM.PS_GP_PIN) Violated When Importing a Rule Package. (Doc ID 2274705.1)

Last updated on JUNE 09, 2017

Applies to:

PeopleSoft Enterprise HCM Global Payroll Core - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Trying to import a package with some Payroll Formulas from a test environment to the production and it fails with the error below:

ERROR
-----------------------
- 20:20:15.767 ......(GP_PKG_COPY.PKGCPY50.Step02) (SQL)
UPDATE PS_GP_PIN SET PIN_NUM = 1 , PIN_PARENT_NUM = 1 WHERE PIN_NUM =
250299 + 50000000
/
-- Row(s) affected: 0
-- 20:20:15.780 Process 109167 ABENDED at Step GP_PKG_COPY.PKGCPY50.Step02 (Action SQL) -- RC = 805
ROLLBACK
/
-- 20:20:15.784 SQL Error: ORA-00001: unique constraint (SYSADM.PS_GP_PIN) violated

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