Script otamlsw.odf Fails during Application of Patch 6678700

Action plan to avoid otamlsw.odf  job issue

Issue:

DROP INDEX OTA.OTA_CATEGORY_USAGES_TL_PK
AD Worker error:
The following ORACLE error:

ORA-02429: cannot drop index used for enforcement of unique/primary key

occurred while executing the SQL statement:

DROP INDEX OTA.OTA_CATEGORY_USAGES_TL_PK

AD Worker error:
Unable to compare or correct tables or indexes or keys
        because of the error above

Solution:

Disable the constraint OTA_EVENT_ASSOCIATIONS_UK2 as follows:

SQL> select * from dba_constraints
     where constraint_name = 'OTA_EVENT_ASSOCIATIONS_UK2'

SQL> alter table OTA_EVENT_ASSOCIATIONS disable constraint OTA_EVENT_ASSOCIATIONS_UK2;

Reference:

-Oracle SR 3-6974638882
-Doc ID 1312500.1: Under What Conditions Can Adding A Primary Key Constraint Not Create An Index?
-Doc ID 370633.1: ALTER TABLE DROP PRIMARY KEY CONSTRAINT DOES NOT DROP