My Oracle Support Banner

AML Scenario 115000003 Running For Hours (Doc ID 2628097.1)

Last updated on JANUARY 14, 2020

Applies to:

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

Symptoms

On : 5.8.1 version, Web UI

ACTUAL BEHAVIOR
---------------
AML Scenario 115000003 running for hours

The weekly scenario 115000003 running for hours

SQL Advisor
  create index MANTAS.IDX$$_11E8F0001 on
  MANTAS.KDD_CAL("CLNDR_NM","CLNDR_DAY_AGE","CLNDR_DT");

  create index BUSINESS.IDX$$_11E8F0004 on
  BUSINESS.WIRE_TRXN("INTRL_ORIG_ACCT_FL","MANTAS_TRXN_PRDCT_CD","TRXN_EXCTN_
  DT");

  create index BUSINESS.IDX$$_11E8F0006 on
  BUSINESS.WIRE_TRXN("INTRL_SCND_ORIG_ACCT_FL","MANTAS_TRXN_PRDCT_CD","TRXN_E
  XCTN_DT");

  create index BUSINESS.IDX$$_11E8F0007 on
  BUSINESS.WIRE_TRXN("SCND_ORIG_ACCT_ID","MANTAS_TRXN_PRDCT_CD","DATA_DUMP_DT
  ");

Cause

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
Symptoms
Cause
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.