SQL Error: ORA-00001: Unique Constraint (SYSADM.PS_GP_PIN) Violated When Importing a Rule Package.
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.
Trying to import a package with some Payroll Formulas from a test environment to the production and it fails with the error below:
- 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
-- 20:20:15.784 SQL Error: ORA-00001: unique constraint (SYSADM.PS_GP_PIN) violated
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