2014 EOY Phase III Patch 20365000 Failure After 12.2.4 Upgrade

(Doc ID 1970375.1)

Last updated on FEBRUARY 07, 2016

Applies to:

Oracle HRMS (US) - Version 12.2.4 to 12.2.4 [Release 12.2]
Oracle HRMS (US) - Version 12.2.5 to 12.2.5 [Release 12.2]
Information in this document applies to any platform.


On : 12.2.4 version, Patch Application Issues

When attempting to apply the payroll EOY phase III patch 20365000 after upgrading an instance from 12.1.3 to 12.2.4, the following error occurs.

The table PAY_MAG_CALC is missing the column ZD_EDITION_NAME
Warning: It is not allowed to add ZD_EDITION_NAME column to existing tables.


ATTENTION: All workers either have failed or are waiting:

  FAILED: file pay_mag_calc_tab.xdf on worker 1.
  FAILED: file pay_mag_data_elem_usages_tab.xdf on worker 3.
  FAILED: file pay_mag_data_elements_tab.xdf on worker 4.
  FAILED: file pay_mag_format_records_tab.xdf on worker 5.
  FAILED: file pay_mag_record_fields_tab.xdf on worker 6.
  FAILED: file pay_mag_record_types_tab.xdf on worker 7.
  FAILED: file pay_mag_report_formats_tab.xdf on worker 8.

The issue can be reproduced at will with the following steps:
upgrading from r12.1.3 to R12.2.4. Applied the payroll EOY phase III patch 20365000 as per doc http://docs.oracle.com/cd/E26401_01/doc.122/e48839/T579510T579526.htm and it failed.

The issue has the following business impact:
Due to this issue, users are unable to continue with 12.2.4 upgrade. Missed the deadline.


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