Patch Failed Loading HR_ADP_ASSIGNMENT_ACTION_TAB.xdf With Error "Index HR_ADP_ASSIGNMENT_ACTION_PK
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). Applied solution in Metalink Note. But still patch is failing with same errors. INDEX is also not created. SQL> exec AD_ZD_SEED.UPGRADE('HR_ADP_ASSIGNMENT_ACTION'); PL/SQL procedure successfully completed. SQL> commit; Commit complete. SQL> select index_name from dba_indexes where index_name='HR_ADP_ASSIGNMENT_ACTION_PK'; no rows selected Actual error from worker log. ================================================================================ Applying XDF file : /u01/app/EBS/R122/PRJ/fs1/EBSapps/appl/per/12.0.0/patch/115/xdf/HR_ADP_ASSIGNMENT_ACTION_TAB.xdf ================================================================================ 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