Symptoms:
12211 Patch 31856789 fails at pay_us_tax_types_tab.xdf
Time is: Tue Apr 11 2023 13:31:44
FAILED: file pay_us_tax_types_tab.xdf on worker 1 for product pay username APPS.
Time is: Tue Apr 11 2023 13:31:44
ATTENTION: All workers either have failed or are waiting:
FAILED: file pay_us_tax_types_tab.
xdf on worker 1.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.
Current time is: Tue Apr 11 2023 13:31:44
Executing statement
ALTER TABLE HR.PAY_US_TAX_TYPES ADD CONSTRAINT “PAY_UTT_TAX_TYPE_CODE_CHK” CHECK (TAX_TYPE_CODE IN (‘CITY’, ‘COUNTY’, ‘EIC’, ‘NW_FIT’, ‘FIT’, ‘FUTA’,
‘MEDICARE’, ‘SCHOOL’, ‘SDI’, ‘NW_SIT’, ‘SIT’, ‘SS’, ‘SUI’, ‘HT’, ‘WC’,
‘WC2’, ‘STEIC’, ‘SUI1′,’SDI1’, ‘MISC1’, ‘MISC2′,’CITY_MISC’ ) )
Start time for statement above is Tue May 16 18:38:10 CDT 2023
End time for statement above is Tue May 16 18:38:10 CDT 2023
Error in executing statement ALTER TABLE HR.PAY_US_TAX_TYPES ADD CONSTRAINT “PAY_UTT_TAX_TYPE_CODE_CHK” CHECK (TAX_TYPE_CODE IN (‘CITY’, ‘COUNTY’, ‘EIC’, ‘NW_FIT’, ‘FIT’, ‘FUTA’,
‘MEDICARE’, ‘SCHOOL’, ‘SDI’, ‘NW_SIT’, ‘SIT’, ‘SS’, ‘SUI’, ‘HT’, ‘WC’,
‘WC2’, ‘STEIC’, ‘SUI1′,’SDI1’, ‘MISC1’, ‘MISC2′,’CITY_MISC’ ) )
Error message is ORA-02293: cannot validate (HR.PAY_UTT_TAX_TYPE_CODE_CHK) – check constraint violated
Error code is 2293
==========================================================
Done calling the utility function. Return Code = [1] TimeStamp = [Tue May 16 18:38:10 CDT 2023]
Updating task with status 1
AD Worker error:
The utility FndXdfCmp returned error for the above task.
Solution
- Skipped the above worker
- Upgraded to HRMS RUP17 after 12211 patch
Metalink Reference:
Upgrade to 12.2.X Errors ORA-02293: Cannot Validate (HR.PAY_UTT_TAX_TYPE_CODE_CHK) When Loading PAY_US_TAX_TYPES.xdf (Doc ID 2759734.1))
Orama.blog 