11i to R12 Upgrade Fails in pefkcmt.sql Script with Error: ORA-02293: cannot validate (HR.PER_ASS_TYPES_RATE_NULL_CHK) - check constraint violated (Doc ID 850317.1)

Last updated on JUNE 16, 2015

Applies to:

Oracle Human Resources - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

On :  12.0.6 version, Install / Upgrade Issues

When attempting to upgrade from R11i(11.5.10.2) to R12(R12.0.6) Upgraded Driver = u4440000.drv
$PER_TOP/patch/115/sql/pefkcmt.sql script fails and the following error occurs:


Steps To Reproduce:

The issue can be reproduced with the following steps:
1. sqlplus -s APPS/***** @$PER_TOP/patch/115/sql/pefkcmt.sql &un_per &pw_per &index_tspace
2. Error occurs

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