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 13, 2023
Applies to:
Oracle Human Resources - Version 12.2.9 and laterInformation in this document applies to any platform.
Symptoms
Problem Statement:
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
Synonyms match.
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
Cause
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
Symptoms |
Cause |
Solution |