My Oracle Support Banner

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

Last updated on FEBRUARY 22, 2019

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 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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.