Patch Failed Loading HR_ADP_ASSIGNMENT_ACTION_TAB.xdf With Error "Index HR_ADP_ASSIGNMENT_ACTION_PK does not exist in HR"
(Doc ID 2633941.1)
Last updated on FEBRUARY 05, 2020
Applies to:Oracle Human Resources - Version 12.2.9 and later
Information in this document applies to any platform.
Patch fails loading HR_ADP_ASSIGNMENT_ACTION_TAB.xdf with the following error.
Table Name is HR_ADP_ASSIGNMENT_ACTION
Table exists in the target database
Checking for differences
Number of columns for the table in the xml file is 5
The table HR_ADP_ASSIGNMENT_ACTION is missing the column ZD_EDITION_NAME
Warning: It is not allowed to add ZD_EDITION_NAME column to existing tables.
Ignoring ZD_EDITION_NAME column and continuing ...
Executing grants on HR_ADP_ASSIGNMENT_ACTION to APPS
GRANT ALL ON HR.HR_ADP_ASSIGNMENT_ACTION TO APPS WITH GRANT OPTION
Executing grants on HR_ADP_ASSIGNMENT_ACTION# to APPS
GRANT ALL ON HR.HR_ADP_ASSIGNMENT_ACTION# TO APPS WITH GRANT OPTION
Index hashcode(s) extracted from the XDF.
Hashcodes generated for DB indexes.
Index HR_ADP_ASSIGNMENT_ACTION_PK does not exist in HR.
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
- Apply patch:28840850(ORACLE E-BUSINESS SUITE 12.2.9 RELEASE UPDATE PACK)
- Worker job fails loading HR_ADP_ASSIGNMENT_ACTION_TAB.xdf
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