Patch 21900901 Errors with ORA-02293 when Upgrading from 12.1.3 to 12.2.6 (Doc ID 2265550.1)

Last updated on MAY 12, 2017

Applies to:

Oracle HRMS (US) - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms



When attempting to upgrade from 12.1.3 to 12.2.6 by applying patch 21900901 (ORACLE E-BUSINESS SUITE 12.2.6 RELEASE UPDATE PACK),
the following error occurs.

ERROR
-----------------------

Error in executing statement ALTER TABLE HR.PAY_US_GARN_EXEMPTION_RULES_F ADD
CONSTRAINT "PAY_PGARNER_CALC_RULE_CHK" CHECK (CALC_RULE IN ('FEDRULE', 'FLAT_AMT',
'FLAT_PCT', 'MARSTAT_RULE',
'EXEMPT_BALANCE', 'NOT_ALLOWED', 'ONE_FED', 'ONE_FLAT_AMT',
'ONE_FLAT_PCT', 'ONE_MARSTAT_RULE', 'ONE_EXEMPT_BALANCE', 'FLAT_PCT_GR',
'FED_GR_RULE') )
Error message is ORA-02293: cannot validate (HR.PAY_PGARNER_CALC_RULE_CHK) - check constraint
violated
Error code is 2293



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. upgrade from 12.1.3 to 12.2.6 by applying patch 21900901



Changes

 Upgrade from 12.1.3 to 12.2.6

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