Batch Fcstprg Fails with ORA-01732 in RMS 16.0

(Doc ID 2416376.1)

Last updated on JULY 03, 2018

Applies to:

Oracle Retail Merchandising System - Version 16.0.1 and later
Information in this document applies to any platform.

Goal

Batch fcstprg failed with below error message:

" fcstprg_1~20180411110209~truncate_table~DEPT_SALES_FORECAST~-1732~ORA-01732: data manipulation operation not legal on this view~Execute Immediate statement: DELETE RMS16.DEPT_SALES_FORECAST WHERE DOMAIN_ID = 1"

In the RMS database the object DEPT_SALES_FORECAST is a materialized view created like below:

CREATE MATERIALIZED VIEW DEPT_SALES_FORECAST
ON PREBUILT TABLE
REFRESH FORCE ON DEMAND
ENABLE QUERY REWRITE
AS
SELECT fsc.dept dept,
  1 domain_id,
  fsc.loc loc,
  fsc.eow_date eow_date,
  SUM(fsc.forecast_sales) forecast_sales
  FROM class_sales_forecast fsc,
  store s
  WHERE fsc.loc = s.store
  GROUP BY fsc.dept, fsc.loc, fsc.eow_date;

 

Solution

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