When Patch20203366 Is Applied, Failed At MTH_ENTITY_PLANNED_USAGE_HR_MV.xdf With ORA-23413

(Doc ID 2198150.1)

Last updated on OCTOBER 28, 2016

Applies to:

Oracle Manufacturing Operations Center - Version 12.1.3 and later
Information in this document applies to any platform.


When <patch.20203366> is applied, the following errors rarely occurred.
*On <patch.9239090>, this issue occurs also.

ATTENTION: All workers either have failed or are waiting:
  FAILED: file MTH_ENTITY_PLANNED_USAGE_HR_MV.xdf on worker 1.
  FAILED: file MTH_ENTITY_PLANNED_USAGE_SM_MV.xdf on worker 2.
  FAILED: file MTH_ENTITY_PLANNED_USAGE_MV.xdf on worker 7.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.

The following errors were logged in adworker's log.
Exception occured ORA-23413: table "MTH"."MTH_ENTITY_PLANNED_USAGE" does not have a materialized view log
ORA-06512: at "APPS.AD_MV", line 131
ORA-06512: at "APPS.AD_MV", line 289
ORA-06512: at line 1

The issue can be rarely reproduced with the following steps:

  1. Apply <Patch.20203366>
  2. adpatch stopped with error.


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms