Running SCM Request For Mfg With Clear And Load All Summaries End With Error (Doc ID 473487.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle E-Business Intelligence - Version 11.5.10.0 to 11.5.10.0 [Release 11.5.10]
Information in this document applies to any platform.
***Checked for relevance on 27-Jul-2013***

Symptoms

-- Problem Statement:

Note: This issue is not specific to either the ADS Initial Supply Chain (Manufacturing) Request Group or the  ENI_RES_2_MV materialized view.  It can occur for any request set using clear and load all summaries and for any Materialized View Log


When attempting to run ADS Initial Supply Chain (Manufacturing) Request Group with "Clear and Load All Summaries specified", it fails with the following message in the log file:

CREATE MATERIALIZED VIEW LOG ON "APPS"."ENI_RES_2_MV"
PCTFREE 60 PCTUSED 30 INITRANS 11 MAXTRANS 255 LOGGING
STORAGE(INITIAL 16384 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4 BUFFER_POOL DEFAULT
)
TABLESPACE "APPS_TS_SUMMARY"
WITH ROWID, SEQUENCE ( "NUMBER_RESOURCE", "RESOURCE_ID" ) INCLUDING NEW VALUES EXCLUDING NEW
VALUES

executing apps_array_ddl.apps_array_ddl
Failed creating MV log for APPS.ENI_RES_2_MV, ORA-00933: SQL command not properly ended

Error occurred:
ORA-01001: invalid cursor
ORA-06512: at "APPS.BIS_MV_REFRESH", line 255
ORA-00933: SQL command not properly ended





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