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.
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.
CONSTRAINT "PAY_PGARNER_CALC_RULE_CHK" CHECK (CALC_RULE IN ('FEDRULE', 'FLAT_AMT',
'EXEMPT_BALANCE', 'NOT_ALLOWED', 'ONE_FED', 'ONE_FLAT_AMT',
'ONE_FLAT_PCT', 'ONE_MARSTAT_RULE', 'ONE_EXEMPT_BALANCE', 'FLAT_PCT_GR',
Error message is ORA-02293: cannot validate (HR.PAY_PGARNER_CALC_RULE_CHK) - check constraint violated
Error code is 2293
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
Upgrade from 12.1.3 to 12.2.6
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