My Oracle Support Banner

CUST_SMRY_DAILY Table - Few Columns Are Not Present (Doc ID 2443353.1)

Last updated on NOVEMBER 10, 2019

Applies to:

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

Symptoms

Client is trying to run BDF's :


1) CustomerDailyProfile_FOTPS
2) CustomerDailyProfile_TRADE
3) CustomerProfile

and getting Error , upon Investigation found that

Following Columns are not present in "CUST_SMRY_DAILY" Table and because of it BDF's are failing

TOT_CHK_OUT_AM,
TOT_CHK_IN_AM,
CASH_TRXN_OUT_AM,
CASH_TRXN_IN_AM,
CASH_EQUIV_TRXN_IN_AM,
CASH_EQUIV_TRXN_OUT_AM,
HRG_CHK_TRXN_IN_AM,
HRG_CHK_TRXN_OUT_AM,
HRG_CL_TRXN_IN_AM,
HRG_CL_TRXN_OUT_AM

Changes

Environment has been upgraded and data model was customized.

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
Changes
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.