My Oracle Support Banner

BD8125:ML-StructuringAvoidReportThreshold(118860028) Failed To Load Error:Failed final attempt to create view DSVIEW118863997 with exception java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist (Doc ID 2969744.1)

Last updated on AUGUST 29, 2023

Applies to:

Oracle Financial Services Behavior Detection Platform - Version 8.1.1 and later
Information in this document applies to any platform.

Goal

BD8125:ML-StructuringAvoidReportThreshold(118860028) failed to load with errors like below

Failed final attempt to create view DSVIEW118863997 with exception java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
-- matching impacted Accounts
SELECT distinct
t.CUST_INTRL_ID,
t.ACCT_INTRL_ID,
a.ACCT_SEQ_ID
FROM
ofsaaatm.ACCT a,
ofsaaatm.ML_STRUCTAVTSHLD_CU_TRXN_B_TMP t
WHERE
a.ACCT_INTRL_ID = t.ACCT_INTRL_ID
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.