Replicate Abended - WARNING OGG-00869 OCI Error ORA-01732: data manipulation operation not legal on this view (Doc ID 2240243.1)

Last updated on APRIL 03, 2017

Applies to:

Oracle GoldenGate - Version 11.2.1.0.28 and later
Information in this document applies to any platform.

Symptoms

 WARNING OGG-00869 OCI Error ORA-01732: data manipulation operation not legal on this view (status = 1732). DELETE FROM "CMS_CBX"."VW_ACC_LIST_CA010MB_MV" WHERE "OD_PORTAL_ACC_ID" = :b0 AND "COUNTRY_CD" = :b1 AND "OD_ACC_NO" = :b2 AND "HOST_ID" = :b3 AND "OD_HOST_ACC_ID" = :b4 AND "OD_ACC_STATUS" = :b5 AND "OD_BRANCH_CODE" = :b6 AND "OD_CCY_CODE" = :b7 AND "OD_ACC_NAME" = :b8 AND "OD_ACC_TYPE_1" = :b9 AND "OD_ACC_TYPE_2" = :b10 AND "OD_RESIDENT_TYPE" = :b11 AND "OD_IBAN_ACC_NO" = :b12 AND "OD_ACC_OWNER" = :b13 AND "OD_FLG_INT_ACC" = :b14 AND "COD_BIC" = :b15 AND "COD_BANK" = :b16 AND "OD_FLG_STATUS1" = :b17 AND "OD_COD_TYP1" = :b18 AND "COD_COUNTRY" = :b19 AND "OD_BAL_TYPE" = :b20 AND "COD_CORECIF" = :b21 AND "UDF_1" = :b22 AND "UDF_2" = :b23 AND "UDF_3" = :b24 AND "UDF_4" = :b25 AND "UDF_5" = :b26 AND "UDF_6" = :b27 AND "UDF_7" = :b28 AND "UDF_8" = :b29 AND "OD_ADD_INFO" = :b30 AND "OD_BANK_RESIDENT_TYPE" = :b31 AND "UDF_9" = :b32 AND "UDF_10" = :b33 AND "UDF_11" = :b34 AND "UDF_12" = :b35 AND "UDF_13" = :b36 AND ROWNUM = 1.

 ERROR OGG-01296 Error mapping from CMS_CBX.VW_ACC_LIST_CA010MB_MV to CMS_CBX.VW_ACC_LIST_CA010MB_MV.

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