Upgrade from to 12.2 Fails On Pyfkbal.sql and Pyfkteng.sql

(Doc ID 1927835.1)

Last updated on MAY 03, 2016

Applies to:

Oracle Payroll - Version 12.2 and later
Information in this document applies to any platform.


When attempting to upgrade from application version to 12.2, the upgrade driver fails on pyfkbal.sql and pyfkteng.sql with the following error,

ORA-02293: cannot validate (HR.PAY_BAL_TAX_TYPE_CHK) - check constraint violated
ORA-02293: cannot validate (HR.PAY_PGARNER_GARN_CATEGORY_CHK) - check constraint violated

The issue can be reproduced at will with the following steps:
1.)  Apply patches 10117518 and 18040523 (Oracle Application DBA 12.2 Patch and CUP5 patch) per Doc ID 1320300.1 and patch readme.

2.) Then install the following patches with adpatch preinstall=y per Doc ID 1320300.1

18007406  Oracle E-Business Suite Consolidated UPgrade Patch 5 (CUP5) for R12.2.0
18973713   Ugrade script deletes category with category_id 10000
18951016  Performance issue encountered on multi Fund Accounting upgrade ar120trxpsa.sql
19080116  Performance problem with apxlaupg.sql script during 12.2. upgrade
18086421  ORA-00942 error happened when applying merged drivers
18332882  GE - 12.2.0 Upgrade Patch (per note 1636918.1)
17068163   PJI XDFS Fail during upgrade from 11i to 12.2

3.) Then merge the preinstall patches with the 12.2 upgrade driver u10124646.drv using the steps in Doc ID 1320300.1

4.) Apply the merged upgrade driver patch


 Upgrade from application version to 12.2


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