Duplicate rows found for alternate key applying HCM Patch Bundle 8 19154027 (Doc ID 1928775.1)

Last updated on SEPTEMBER 09, 2016

Applies to:

Oracle Fusion Application Toolkit - Version 11.1.8.0.0 and later
Information in this document applies to any platform.

Symptoms

Applying HCM Patch Bundle 8 19154027 on Fusion Application 11.1.8.0.0 version, following errors occur:

ERROR
-----------------------

2014-08-15T17:17:08.104-05:00] [apps] [ERROR] [SDF-10803] [oracle.apps.fnd.applseed.rt.loader.core] [tid: 10] [ecid: 0000KVRh^dr4ep5hVPNa4c1JvcIi000001,0] Loading failed for record [44/75] [FormulaResultRuleAll.State.US_WORK_HEAD_TAX_PROCESSOR.US.0x0000.WK_STATE.US_WORK_CITY_TAX_PROCESSOR.P.0x0000.0x0000.0x0000.US_WORK_HEAD_TAX_PROCESSOR.4712-12-31.0001-01-01]
[2014-08-15T17:17:08.110-05:00] [apps] [ERROR] [] [oracle.apps.fnd.applseed.rt.loader.core] [tid: 10] [ecid: 0000KVRh^dr4ep5hVPNa4c1JvcIi000001,0] oracle.apps.fnd.applseed.rt.loader.exception.SDLoaderException: Duplicate rows found for alternate key: 4712-12-31 0001-01-01 State US_WORK_HEAD_TAX_PROCESSOR US null WK_STATE US_WORK_CITY_TAX_PROCESSOR P null null null US_WORK_HEAD_TAX_PROCESSOR [[

[2014-08-15T17:17:08.129-05:00] [apps] [ERROR] [SDF-10803] [oracle.apps.fnd.applseed.rt.loader.core] [tid: 10] [ecid: 0000KVRh^dr4ep5hVPNa4c1JvcIi000001,0] Loading failed for record [45/75] [FormulaResultRuleAll.County.US_WORK_HEAD_TAX_PROCESSOR.US.0x0000.WK_COUNTY.US_WORK_CITY_TAX_PROCESSOR.P.0x0000.0x0000.0x0000.US_WORK_HEAD_TAX_PROCESSOR.4712-12-31.0001-01-01]
[2014-08-15T17:17:08.129-05:00] [apps] [ERROR] [] [oracle.apps.fnd.applseed.rt.loader.core] [tid: 10] [ecid: 0000KVRh^dr4ep5hVPNa4c1JvcIi000001,0] oracle.apps.fnd.applseed.rt.loader.exception.SDLoaderException: Duplicate rows found for alternate key: 4712-12-31 0001-01-01 County US_WORK_HEAD_TAX_PROCESSOR US null WK_COUNTY US_WORK_CITY_TAX_PROCESSOR P null null null US_WORK_HEAD_TAX_PROCESSOR [[


STEPS TO REPRODUCE
----------------------------------------
The issue can be reproduced at will with the following steps:
Running the HCM Patch Bundle 8 (19154027)

Cause

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