This error may occur when you try to re-apply the patch 9239090 (EBS 12.1.3), because the mth_pre_upgrade.sql tries to create a table named “MTH.MTH_RESOURCES_D_TEMP” without checking if it exists. All you need is to drop that table and restart the worker. Connect your database as sys/system, and issue the command:

Then run adctrl, enter 2 (Tell worker to restart a failed job), and then enter the number of the failed worked. ADPatch will continue to apply the patch.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">