Demantra Java.sql.BatchUpdateException ORA-12083 During Export ORA-12083

(Doc ID 1465584.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Demantra Demand Management - Version 7.3.0.2 to 7.3.1
Information in this document applies to any platform.

Symptoms

On : 7.3.0.2 version, Workflow

When attempting to run Export Workflows,
the following error occurs.

ERROR
-----------------------
ERROR appserver.error:
java.sql.BatchUpdateException: error occurred during batching: ORA-12083: must use DROP MATERIALIZED VIEW to drop "DEMANTRA_UAT"."BIEO_EXPORT_PART_BLM_MV"


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Workflow Manager
2. Run an Export Workflow

Cause

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