Human Capital Management - EBS (MOSC)

MOSC Banner

Patch Failed Loading HR_ADP_ASSIGNMENT_ACTION_TAB.xdf With Error "Index HR_ADP_ASSIGNMENT_ACTION_PK

edited Jun 26, 2020 10:03AM in Human Capital Management - EBS (MOSC) 1 comment

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center