When Patch20203366 Is Applied, Failed At MTH_ENTITY_PLANNED_USAGE_HR_MV.xdf With ORA-23413
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:
- Apply <Patch.20203366>
- adpatch stopped with error.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms