R12.1.1 Upgrade Driver Failed On Pyfkteng.Sql Error: ORA-02293: cannot validate (HR.PAY_UTT_TAX_TYPE_CODE_CHK) - check constraint violated (Doc ID 1272859.1)

Last updated on DECEMBER 20, 2016

Applies to:

Oracle HRMS (US) - Version 12.1.1 to 12.1.1 [Release 12.1]
Oracle Payroll - Version 12.1.1 to 12.1.1 [Release 12.1]
Information in this document applies to any platform.
***Checked for relevance on 15-AUG-2012***

Symptoms

R12.1.1 upgrade driver had failed on pyfkteng.sql with the following error.

declare
*
ERROR at line 1:
ORA-02293: cannot validate (HR.PAY_UTT_TAX_TYPE_CODE_CHK) - check constraint
violated
ORA-06512: at "SYS.DBMS_SQL", line 1053
ORA-06512: at line 2470

 

Changes

Upgrade from release 11.5.10 to release 12.1.1

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