20.1 OBD Application Process

This section describes the process for the OBD application.

Start Batch

To start a batch, follow these steps:
  1. Log in as ECMADMIN and navigate to Enterprise Case Management Application.
  2. Go to the Common Tasks section and select the Rule Run Framework.
  3. Click Run. The Run window is displayed with the available Processes.
  4. Go to the List section, select Oracle_BD_Event_Processing, and click Edit
  5. Add the BD_POPULATE_ENTITY_RELATION Data Transformation task after the BD_Create_Task Data Transformation task and click Save. This task populates data in the KDD_CASE_NTITY_REL_EVNT and KDD_CASE_NTITY_REL_CASE tables.

    Note:

    Refer to the Adding Transformation Rule section.
  6. Run the Oracle_BD_Event_Processing batch.

Load Data from BD to ECM

The BD_Load_From_LA_To_CA process is used for load data from the Landing area to the Consolidation area for OBD. This has the following four sub-processes:
  • Loading BDEvents
    • If you use Event Suppression, the following process must be added to the batch Oracle Behavior Detection to CA Event Suppression - BD_EVENT_SUPPRESSION.

      If the ECM Batch Run has selected the alerts that are closed automatically by Suppression in the BDF, it will close the Events and update the decision of the corresponding Events as Closed per Suppression Rule. The decision Closed per Suppression Rule is currently obtained from the FCC_EVENT_INVESTIGATION_STATUS table, n_status_id = 998. You can modify the decision name in the FCC_EVENT_INVESTIGATION_STATUS table for n_status_id = 998.

  • Entity Surrogate Key Generation for BD
  • Oracle Behavior Detection Evented DataLoad
  • Oracle Behavior Detection Business DataLoad

Below is the list of BD sub-process codes. These sub-processes can be used by OCS and OKYC applications along with their application-specific processes.

Here, Level 1 subprocess code execution is a prerequisite for Level 2 subprocess execution. Similarly, Level2 sub-process code execution is a prerequisite for Level 3 sub-process execution and so on. Subprocess within a level can be executed in any order or it can be executed in parallel.

BD_ENTITY_SUP_INFO sub-process code has to be executed after the business data population (see the Business Metadata Movement).

Correlation

Correlation is used to perform correlation on loaded BD events. This has the following two tasks:
  • PGX_CORRELATION
  • BD_CORRELATION

Scoring

BD_SCORING is used to perform the scoring of OBD events. This has the following four sub-processes:
  • Oracle Behavior Detection EventScoring
  • Oracle Behavior Detection EntityScoring
  • Oracle Behavior Detection CorrelationScoring
  • Oracle Behavior Detection Pre-CaseScoring

Promote to Case

BD_Promote_To_Case_Decisionis used to decide if an OBD correlation can be promoted to a case. This is based on the defined threshold limit. This has the Pre Case PromotionRule task. The task type of this is the Computation Rule.

Create Case

BD_Create_Case process is used for case creation if an OBD event is promoted to case. Below is the list of T2T tasks for BD application:
  • f_generatecaseid
  • f_insertcases
  • t2t_KDD_CASE_ACCOUNTS
  • t2t_KDD_CASE_CUSTOMERS
  • t2t_KDD_CASE_DERIVED_ADDRESS
  • t2t_KDD_CASE_EMPLOYEES
  • t2t_KDD_CASE_ACCOUNT_ADDRESS
  • t2t_KDD_CASE_ACCOUNT_MANAGED
  • t2t_KDD_CASE_ACCOUNT_RSTRNS
  • t2t_KDD_CASE_ACCT_BAL_POSN_SMRY
  • t2t_KDD_CASE_ACCT_EMAIL_ADDR
  • t2t_KDD_CASE_ACCT_PEER_GRP
  • t2t_KDD_CASE_ACCT_PHON
  • t2t_KDD_CASE_ACCT_SMRY_MNTH
  • t2t_KDD_CASE_ACCT_SUPPL_ATTR
  • t2t_KDD_CASE_ACT_PEER_TRXN_SMRY
  • t2t_KDD_CASE_ACCT_NTCPTRY_PRFL
  • t2t_FCC_CASE_ACCT_LIST_MBRSP
  • t2t_KDD_CASE_CLIENT_BANK
  • t2t_KDD_CASE_CLIENT_BANK_SMRY_MNTH
  • t2t_KDD_CASE_CUST_ADDR
  • t2t_KDD_CASE_CUST_EMAIL_ADDRS
  • t2t_KDD_CASE_CUST_LIST_MEMBERSHIP
  • t2t_KDD_CASE_CUST_PHONE
  • t2t_KDD_CASE_CUST_SUPPL_ATTR
  • t2t_KDD_CASE_CUST_SMRY_MNTH
  • t2t_KDD_CASE_CUST_CUST
  • t2t_KDD_CASE_EMP_ACCT
  • t2t_KDD_CASE_EMP_ADDR
  • t2t_KDD_CASE_EMP_EMAIL_ADDR
  • t2t_KDD_CASE_EMP_PHONE
  • t2t_KDD_CASE_INSTL_ACCT_SMRY_MNTH
  • t2t_KDD_CASE_INSTN_MASTER
  • t2t_KDD_CASE_INSURANCE_POLICY
  • t2t_KDD_CASE_INSURANCE_PRODUCT
  • t2t_KDD_CASE_NTWK_USER_ACCT_MAP
  • t2t_KDD_CASE_ONLINE_ACCT
  • t2t_KDD_CASE_ONLINE_ACCT_ACCT
  • t2t_KDD_CASE_PEER_GRP
  • t2t_KDD_CASE_CB_LIST_MEMBERSHIP
  • t2t_KDD_CASE_CB_PEER_TXN_SMRY_MNTH
  • t2t_KDD_CASE_CLIENT_BANK_PEER_GRP
  • t2t_KDD_CASE_EXTERNAL_ENTITY
  • t2t_KDD_CASE_EXTERNAL_ENTITY_MEMBERSHIP
  • t2t_KDD_CASE_HH_ACCT_BAL_SMRY
  • t2t_KDD_CASE_HH_SMRY_MNTH
  • t2t_KDD_CASE_INSURANCE_PLCY_CUST
  • t2t_KDD_CASE_NVSMT_MGR_SMRY_MNTH
  • t2t_KDD_CASE_NVSMT_MGR
  • t2t_KDD_CASE_ACCT_ID_INSTN_ID_MAP
  • t2t_KDD_CASE_ACCT_GRP
  • t2t_KDD_CASE_WIRE_TRXN
  • t2t_KDD_CASE_CASH_TRXN
  • t2t_KDD_CASE_DERIVED_ADDRESS_CASH_TRXN
  • t2t_KDD_CASE_DERIVED_ADDRESS_MI_TRXN
  • t2t_KDD_CASE_DERIVED_ADDRESS_WIRE_TRXN
  • t2t_KDD_CASE_BACK_OFFICE_TRXN
  • t2t_KDD_CASE_CUST_IMP_LICENSE_GOODS
  • t2t_KDD_CASE_CUST_IMP_LICENSE
  • t2t_KDD_CASE_DOC_COLL_CNTRCT
  • t2t_KDD_CASE_DOC_COLL_CNTRCT_EVENT
  • t2t_KDD_CASE_DOC_COLL_DISCRP_DTL
  • t2t_KDD_CASE_DOC_COLL_INVOICE
  • t2t_KDD_CASE_DOC_COLL_MULTNR_DTL
  • t2t_KDD_CASE_DOC_COLL_SHPMT_DTL
  • t2t_KDD_CASE_EXTERNAL_INSURANCE_PLCY
  • t2t_KDD_CASE_EXTERNAL_ORG
  • t2t_KDD_CASE_TRADE_FIN_SWIFT_MSG
  • t2t_KDD_CASE_TRADE_FIN_PARTY
  • t2t_KDD_CASE_TRADE_FIN_GOOD_SRVC
  • t2t_KDD_CASE_TRADE_FIN_DRAFT
  • t2t_KDD_CASE_TRADE_FIN_DOC
  • t2t_KDD_CASE_TRADE_FIN_CNTRCT
  • t2t_KDD_CASE_TRADE_FIN_BRKRGE_DIST
  • t2t_KDD_CASE_TRADE_FIN_BRKRGE
  • t2t_KDD_CASE_TRADE_FIN_ACCT
  • t2t_KDD_CASE_TRADE
  • t2t_KDD_CASE_ORDER
  • t2t_KDD_CASE_TRADE
  • t2t_KDD_CASE_MI_TRXN
  • t2t_KDD_CASE_LOAN_ACCOUNT
  • t2t_KDD_CASE_LOAN
  • t2t_KDD_CASE_LOAN_SMRY_MONTH
  • t2t_KDD_CASE_INSTRUCTION
  • t2t_KDD_CASE_ORDR_EVENT
  • t2t_KDD_CASE_SCRTY_FIRM_DAILY
  • t2t_KDD_CASE_SCRTY_MKT_DAILY
  • t2t_KDD_CASE_TRADE_EXECUTION_EVENT
  • t2t_KDD_CASE_SCRTY
  • t2t_KDD_CASE_EXECUTION
  • CASE_COMPLETION_FLAG

CASE_ASSIGNMENT

Here, Level 1, Level 2, Level 2, Level 2, Level 3, Level 4, Level 5, Level 6, and Level 7 should run in sequence. Sub-processes within any level (for example, level3) can be executed in any order in parallel (depending upon the hardware specification) or sequentially.

Table 20-1 Level Details

Level Process Name
Level 1 Oracle Behavior Detection to CA Event Lookup
Level 2 Oracle Behavior Detection to CA Event
Level 2 Oracle Behavior Detection to CA Event Binding
Level 2 Oracle Behavior Detection to CA Event Details
Level 3 CA Lookup
Level 4 CA Event Entity Map
Level 5 CA Business
Level 6 Additional Information
Level 7 CA Evented

Table 20-2 Process Details

Level 1 Level 2 Level 3 Level 4 Level 5 Level 6
BD_EVENT_L OOKUP BD_EVENT BD_ACCOUNT_ GROUP_LOOKU P BD_EVENT_EN TITY_MAP_AC Business Metadata Movement Evented Data Movement
BD_EVENT_B INDING BD_ACCOUNT_ LOOKUP BD_EVENT_EN TITY_MAP_AG BD_ACCT BD_ACCT_EVENT
BD_EVENT_D ETAILS BD_CUSTOMER _LOOKUP BD_EVENT_EN TITY_MAP_BOT BD_ACCT_ADD R BD_ACCT_ACCT_ ADDR_EVNT
BD_DERIVED_A DDRESS_LOOK UP BD_EVENT_EN TITY_MAP_CT BD_ACCT_BAL_ POS N_SMRY BD_ACCT_BAL_P OSN_SMRY_EVN T
BD_EMPLOYEE _LOOKUP BD_EVENT_EN TITY_MAP_CUS T BD_ACCT_EMAI L_ADDR BD_ACCT_GRP_E VNT
BD_EVENT_LO OKUP BD_EVENT_EN TITY_MAP_DA BD_ACCT_GRP BD_ACCT_PEER_ GRP_EVNT
BD_EXTERNAL_ ENTITY_LOOKU P BD_EVENT_EN TITY_MAP_EE BD_ACCT_ID_IN STN_ID_MAP BD_ACCT_PR_TX N_SMRY_MN_EV NT
BD_INSTITUTIO N_LOOKUP BD_EVENT_EN TITY_MAP_EM PL BD_ACCT_LIST _MEMBERSHIP BD_ACCT_RSTRN _EVNT
BD_INVESTME NT_ADVISOR_L OOKUP BD_EVENT_EN TITY_MAP_IA BD_ACCT_PEER _GRP BD_ACCT_SMRY_ MNTH_EVNT
BD_LOAN_LOO KUP BD_EVENT_EN TITY_MAP_IM BD_ACCT_PEER _TRXN_SMRY_ MNTH BD_BACK_OFFICE _TRXN_EVNT
BD_MARKET_C ENTER_LOOKU P BD_EVENT_EN TITY_MAP_MIT BD_ACCT_PHO N BD_CASH_TRXN_ EVNT
BD_PEER_GRO UP_LOOKUP BD_EVENT_EN TITY_MAP_WT BD_ACCT_RSTR N BD_CB_PR_TXN_ SM_MNT_EVNT
BD_ACCT_SMR Y_MNTH BD_CLIENT_BAN K_EVNT
BD_BACK_OFFI CE_TRXN BD_CLINT_BNK_P R_GRP_EVNT
BD_CASH_TRX N BD_CLNT_BNK_S M_MNT_ EVNT
BD_CB_LIST_M EMBERSHIP BD_CUST_EVNT
BD_CB_PR_TRX N_SMRY_MNT H BD_CUST_IMP_LI CENSE_EVNT
BD_CLIENT_BA NK BD_CUST_IMP_LI C_GOD_EVNT
BD_CLIENT_BA NK_PEER_GRP BD_CUST_SMRY_ MNTH_EVNT
BD_CLIENT_BA NK_SMRY_MNT H BD_CUST_SUPPL _ATR_EVNT
BD_CUST BD_DERIVED_AD DRESS_EVNT
BD_CUST_ACC T BD_EMP_ACCT_E VNT
BD_CUST_ADD R BD_EMP_ADDR_E VNT
BD_CUST_E- MAIL_ADDR BD_EMP_E- MAIL_ADDR_EVN T
BD_CUST_IMP_ LICENSE BD_EMP_EVNT
BD_CUST_IMP_ LICENSE_GOOD
BD_CUST_LIST _MEMBERSHIP
BD_CUST_PHO N
BD_CUST_SMR Y_MNTH
BD_CUST_SUP PLE MENTAL_ATR BD_EMP_PHON_ EVNT
BD_DERIVED_A DDRESS BD_HH_BAL_POS N_SMRY_EVNT
BD_EMP BD_INSTL_ACCT_ SMRY_MNTH_EV NT
BD_EMP_ACCT BD_INSTN_MAST ER_EVNT
BD_EMP_ADDR BD_INSURANCE_ POLICY_EVNT
BD_EMP_E- MAIL_ADDR BD_INSURANCE_ PRODUCT_EVNT
BD_EMP_PHON BD_INS_PLCY_CU ST_EVNT
BD_EVENT_SC ORE BD_LOAN_EVNT
BD_EXTERNAL_ ENTITY BD_LOAN_SMRY_ MNTH_EVNT
BD_EXTERNAL_ ENTITY_ADDR BD_MANGD_ACC T_EVNT
BD_EXTRNAL_E NTTY_MMBRS HP BD_MI_TRXN_EV NT
BD_FCC_EXTER NAL_ENTITY_LI NK BD_NTCPTRY_PR FL_EVNT
BD_HH_BAL_P OSN_SMRY BD_NVSMT_MGR _EVNT
BD_INSTN_MA STER BD_NVSMT_MGR _SMRY_MNTH_E VNT
BD_INSURANC E_POLICY BD_PEER_GRP_E VNT
BD_INSURANC E_POLICY_CUS T BD_WIRE_TRXN_ EVNT
BD_INSURANC E_PRODUCT BD_XTRNL_ENTY _ADR_EVNT
BD_LOAN
BD_LOAN_SMR Y_MNTH
BD_MANGD_AC CT BD_MI_TRXN
BD_NTCPTRY_P RFL
BD_NVSMT_M GR
BD_NVSMT_M GR_SMRY_MNT H
BD_PEER_GRP
BD_WIRE_TRXN
BD_ENTITY_SU P_INFO This subprocess code must be executed after the business data population (see the Business Metadata Movement).

Table 20-3 Sub-processes

CA Area Process Name Process Parameter
CA Event Oracle Behavior Detection to CA Event BD_EVENT
CA Event Oracle Behavior Detection to CA Event Binding BD_EVENT_BINDING
CA Event Oracle Behavior Detection to CA Event Details BD_EVENT_DETAILS
CA Event Oracle Behavior Detection to CA Trade Lookup BD_TRADE_LOOKUP
CA Event Oracle Behavior Detection to CA Order Lookup BD_ORDER_LOOKUP
CA Event Oracle Behavior Detection to CA Security Lookup BD_SECURITY_LOOKUP
CA Event Oracle Behavior Detection to CA Event Entity Map Trade BD_EVENT_ENTITY_MAP_TRADE
CA Event Oracle Behavior Detection to CA Event Entity Map Order BD_EVENT_ENTITY_MAP_ORDER
CA Event Oracle Behavior Detection to CA Event Entity Map Security BD_EVENT_ENTITY_MAP_SCRTY
CA Event Oracle Behavior Detection to CA Event Entity Map Customer Account Position BD_EVENT_ENTITY_MAP_ACCT_POSN
CA Event Oracle Behavior Detection to CA Trade BD_TRADE
CA Event Oracle Behavior Detection to CA Evented Trade BD_TRADE_EVNT
CA Event Oracle Behavior Detection to CA Order BD_ORDR
CA Event Oracle Behavior Detection to CA Evented Order BD_ORDR_EVNT
CA Event Oracle Behavior Detection to CA Order Event BD_ORDR_EVENT
CA Event Oracle Behavior Detection to CA Security BD_SCRTY
CA Event Oracle Behavior Detection to CA Evented Security BD_SCRTY_EVNT
CA Event Oracle Behavior Detection to CA Security Market Daily Profile BD_SCRTY_MKT_DAILY
CA Event Oracle Behavior Detection to CA Evented Security Market Daily Profile BD_SCRTY_MKT_DAILY_EVNT
CA Event Oracle Behavior Detection to CA Security Firm Daily Profiles BD_SCRTY_FIRM_DAILY
CA Event Oracle Behavior Detection to CA Evented Security Firm Daily Profiles BD_SCRTY_FIRM_DAILY_EVNT
CA Event Oracle Behavior Detection to CA Event Entity Map Execution BD_EVENT_ENTITY_MAP_EXCTN
CA Event Oracle Behavior Detection to CA Evented Execution BD_EXECUTION_EVNT
CA Event Oracle Behavior Detection to CA Trade Execution BD_TRADE_EXECUTION_EVENT 4. BD_Create_Case
CA Lookup Oracle Behavior Detection to CA Account ATM Daily Lookup BD_ACCOUNTATMDAILY_LOOKUP
CA Lookup Oracle Behavior Detection to CA Account ATM Daily Lookup BD_CustomerBalance_LOOKUP
CA Lookup Oracle Behavior Detection to CA Account Balance Summary Lookup BD_ACCT_SMRY_MNTH_LOOKUP
CA Lookup Oracle Behavior Detection to CA Account Client Bank Lookup BD_ACCT_CLIENTBANK_LOOKUP
CA Lookup Oracle Behavior Detection to CA Account Daily Lookup BD_ACCOUNTDLY_LOOKUP
CA Lookup Oracle Behavior Detection to CA Account Group Lookup BD_ACCOUNT_GROUP_LOOKUP
CA Lookup Oracle Behavior Detection to CA Account Lookup BD_ACCOUNT_LOOKUP
CA Lookup Oracle Behavior Detection to CA Account PeerGroup Lookup BD_ACCOUNT_PEERGROUP_LOOKUP
CA Lookup Oracle Behavior Detection to CA Account Trade Daily Lookup BD_ACCOUNTTRADEDLY_LOOKUP
CA Lookup Oracle Behavior Detection to CA Account Transaction Daily Lookup BD_ACCOUNTTRXNDLY_LOOKUP
CA Lookup Oracle Behavior Detection to CA Anticipatory Profile Lookup BD_ANTICIPATORYPRFL_LOOKUP
CA Lookup Oracle Behavior Detection to CA Back Office Transaction Lookup BD_BACK_OFFICE_TRXN_LOOKUP
CA Lookup Oracle Behavior Detection to CA Cash Transaction Lookup BD_CASH_TRXN_LOOKUP
CA Lookup Oracle Behavior Detection to CA Client Bank Peer Transaction Summary Lookup BD_CBPEERTRXNSMRY_LOOKUP
CA Lookup Oracle Behavior Detection to CA Client Bank PeerGroup Lookup BD_CLIENTBANK_PEERGRP_LOOKUP
CA Lookup Oracle Behavior Detection to CA Client Bank Summary Lookup BD_CLINETBANKBSMRY_LOOKUP
CA Lookup Oracle Behavior Detection to CA ClientBank Transaction Summary Lookup BD_ACCT_PR_TRXN_SMR_MN_LOOKUP
CA Lookup Oracle Behavior Detection to CA Customer Account Lookup BD_CUSTOMER_ACCOUNT_LOOKUP
CA Lookup Oracle Behavior Detection to CA Customer Customer Lookup BD_CUSTOMER_CUSTOMER_LOOKUP
CA Lookup Oracle Behavior Detection to CA Customer Daily Lookup BD_CUSTOMERDLY_LOOKUP
CA Lookup Oracle Behavior Detection to CA Customer MarketServed Lookup BD_CUSTOMER_MRKTSRV_LOOKUP
CA Lookup Oracle Behavior Detection to CA Customer Product Lookup BD_CUSTOMER_PRODUCT_LOOKUP
CA Lookup Oracle Behavior Detection to CA Customer Summary Lookup BD_CUSTOMERSMRY_LOOKUP
CA Lookup Oracle Behavior Detection to CA Customers Lookup BD_CUSTOMER_LOOKUP
CA Lookup Oracle Behavior Detection to CA Customer Account Position BD_ACCT_POSN
CA Lookup Oracle Behavior Detection to CA Derived Address Lookup BD_DERIVED_ADDRESS_LOOKUP
CA Lookup Oracle Behavior Detection to CA Employee Account Lookup BD_EMPLOYEE_ACCOUNT_LOOKUP
CA Lookup Oracle Behavior Detection to CA Employee Lookup BD_EMPLOYEE_LOOKUP
CA Lookup Oracle Behavior Detection to CA Event Lookup BD_EVENT_LOOKUP
CA Lookup Oracle Behavior Detection to CA External Entity Daily Lookup BD_EXTERNALENTITYDLY_LOOKUP
CA Lookup Oracle Behavior Detection to CA External Entity Lookup BD_EXTERNAL_ENTITY_LOOKUP
CA Lookup Oracle Behavior Detection to CA House Hold Summary Lookup BD_HOUSEHOLDSMRY_LOOKUP
CA Lookup Oracle Behavior Detection to CA Household Balance Lookup BD_HOUSEHOLDBALDLY_LOOKUP
CA Lookup Oracle Behavior Detection to CA Institution Account Daily Lookup BD_INSTLACCOUNTDLY_LOOKUP
CA Lookup Oracle Behavior Detection to CA Institution Account Summary Lookup BD_INSTACCOUNTSMRY_LOOKUP
CA Lookup Oracle Behavior Detection to CA Institution Lookup BD_INSTITUTION_LOOKUP
CA Lookup Oracle Behavior Detection to CA Insurance Policy Balance Lookup BD_INSURANCEPOLICYBAL_LOOKUP
CA Lookup Oracle Behavior Detection to CA Insurance Policy Daily Lookup BD_INSURANCEPOLICYDLY_LOOKUP
CA Lookup Oracle Behavior Detection to CA InsurancePolicy Customer Lookup BD_INSURPOLICY_CUST_LOOKUP
CA Lookup Oracle Behavior Detection to CA Investment Advisor Lookup BD_INVESTMENT_ADVISOR_LOOKUP
CA Lookup Oracle Behavior Detection to CA Investment Advisor Lookup BD_INVESTMENTADVISORLOOKUP
CA Lookup Oracle Behavior Detection to CA Investment Advisor Summary Lookup BD_INVESTMENTSMRY_LOOKUP
CA Lookup Oracle Behavior Detection to CA LinkAnalysis Lookup BD_LINKANALYSIS_LOOKUP
CA Lookup Oracle Behavior Detection to CA Loan Lookup BD_LOAN_LOOKUP
CA Lookup Oracle Behavior Detection to CA Loan Summary Lookup BD_LOANSMRY_LOOKUP
CA Lookup Oracle Behavior Detection to CA MI Transaction Lookup BD_MI_TRXN_LOOKUP
CA Lookup Oracle Behavior Detection to CA Managed Account Daily Lookup BD_MANAGEDACCOUNTDLY_LOOKUP
CA Lookup Oracle Behavior Detection to CA Managed Account Lookup BD_MANAGEDACCOUNT_LOOKUP
CA Lookup Oracle Behavior Detection to CA Market Center Lookup BD_MARKET_CENTER_LOOKUP
CA Lookup Oracle Behavior Detection to CA NetworkLogon Lookup BD_NETWORKLOGON_LOOKUP
CA Lookup Oracle Behavior Detection to CA NetworkUser Account Lookup BD_NTWKUSER_ACCOUNT_LOOKUP
CA Lookup Oracle Behavior Detection to CA Online Account Lookup BD_ONLINEACCOUNT_LOOKUP
CA Lookup Oracle Behavior Detection to CA OnlineAccount Account Lookup BD_ONLINEACCT_ACCT_LOOKUP
CA Lookup Oracle Behavior Detection to CA Peer Group Lookup BD_PEER_GROUP_LOOKUP
CA Lookup Oracle Behavior Detection to CA Trade Lookup BD_TRADE_LOOKUP
CA Lookup Oracle Behavior Detection to CA Wire Transaction Lookup BD_WIRE_TRXN_LOOKUP
CA Lookup Oracle Behavior Detection to CA Execution Lookup BD_EXECUTION_LOOKUP
CA Lookup Oracle Behavior Detection to CA Issuer Lookup BD_ISSUER_LOOKUP
CA Lookup Oracle Behavior Detection to CA Issuer BD_ISSUER
CA Lookup Oracle Behavior Detection to CA Organization Lookup BD_ORG_LOOKUP
CA Lookup Oracle Behavior Detection to CA Organization BD_ORG**
CA Event Entity Map Oracle Behavior Detection to CA Event Entity Map Account BD_EVENT_ENTITY_MAP_AC
CA Event Entity Map Oracle Behavior Detection to CA Event Entity Map Account Balance Position Summary BD_EVENT_ENTITY_MAP_ABPS
CA Event Entity Map Oracle Behavior Detection to CA Event Entity Map Account Group BD_EVENT_ENTITY_MAP_AG
CA Event Entity Map Oracle Behavior Detection to CA Event Entity Map Account Summary Month BD_EVENT_ENTITY_MAP_ASM
CA Event Entity Map Oracle Behavior Detection to CA Event Entity Map Back Office Transaction BD_EVENT_ENTITY_MAP_BOT
CA Event Entity Map Oracle Behavior Detection to CA Event Entity Map Cash Transaction BD_EVENT_ENTITY_MAP_CT
CA Event Entity Map Oracle Behavior Detection to CA Event Entity Map Client Bank Summary Month BD_EVENT_ENTITY_MAP_CBSM
CA Event Entity Map Oracle Behavior Detection to CA Event Entity Map Customer BD_EVENT_ENTITY_MAP_CUST
CA Event Entity Map Oracle Behavior Detection to CA Event Entity Map Customer Summary Month BD_EVENT_ENTITY_MAP_CSM
CA Event Entity Map Oracle Behavior Detection to CA Event Entity Map Derived Address BD_EVENT_ENTITY_MAP_DA
CA Event Entity Map Oracle Behavior Detection to CA Event Entity Map Employee BD_EVENT_ENTITY_MAP_EMPL
CA Event Entity Map Oracle Behavior Detection to CA Event Entity Map External Entity BD_EVENT_ENTITY_MAP_EE
CA Event Entity Map Oracle Behavior Detection to CA Event Entity Map Institution Master BD_EVENT_ENTITY_MAP_IM
CA Event Entity Map Oracle Behavior Detection to CA Event Entity Map Investment Advisor BD_EVENT_ENTITY_MAP_IA
CA Event Entity Map Oracle Behavior Detection to CA Event Entity Map Loan BD_EVENT_ENTITY_MAP_LOAN
CA Event Entity Map Oracle Behavior Detection to CA Event Entity Map Loan summary month BD_EVENT_ENTITY_MAP_LSM
CA Event Entity Map Oracle Behavior Detection to CA Event Entity Map MI Transaction BD_EVENT_ENTITY_MAP_MIT
CA Event Entity Map Oracle Behavior Detection to CA Event Entity Map Trade BD_EVENT_ENTITY_MAP_TRADE
CA Event Entity Map Oracle Behavior Detection to CA Event Entity Map Wire Transaction BD_EVENT_ENTITY_MAP_WT
CA Event Entity Map Oracle Behavior Detection to CA Event entity map Account ATM summary daily BD_EVENT_ENTITY_MAP_AASD
CA Event Entity Map Oracle Behavior Detection to CA Event entity map Anticipatory Profile BD_EVENT_ENTITY_MAP_NP
CA Event Entity Map Oracle Behavior Detection to CA Event entity map Employee Account BD_EVENT_ENTITY_MAP_EA
CA Event Entity Map Oracle Behavior Detection to CA Event entity map Household Balance position summary BD_EVENT_ENTITY_MAP_HBPS
CA Event Entity Map Oracle Behavior Detection to CA Event Scoring BD_EVENT_SCORE
CA Business Oracle Behavior Detection to CA Account BD_ACCT
CA Business Oracle Behavior Detection to CA Account ATM summary Daily BD_ACCT_ATM_SMRY_DAILY
CA Business Oracle Behavior Detection to CA Account Address BD_ACCT_ADDR
CA Business Oracle Behavior Detection to CA Account Balance Position Summary BD_ACCT_BAL_POSN_SMRY
CA Business Oracle Behavior Detection to CA Account Email Address BD_ACCT_EMAIL_ADDR
CA Business Oracle Behavior Detection to CA Account Group BD_ACCT_GRP
CA Business Oracle Behavior Detection to CA Account Institution mapping BD_ACCT_ID_INSTN_ID_MAP
CA Business Oracle Behavior Detection to CA Account List Membership BD_ACCT_LIST_MEMBERSHIP
CA Business Oracle Behavior Detection to CA Account Peer Group BD_ACCT_PEER_GRP
CA Business Oracle Behavior Detection to CA Account Peer Transaction Summary Month BD_ACCT_PEER_TRXN_SMRY_MNTH
CA Business Oracle Behavior Detection to CA Account Phone BD_ACCT_PHON
CA Business Oracle Behavior Detection to CA Account Restriction BD_ACCT_RSTRN
CA Business Oracle Behavior Detection to CA Account Summary Month BD_ACCT_SMRY_MNTH
CA Business Oracle Behavior Detection to CA Account Supplemental Attribute BD_ACCT_SUPPLEMENTAL_ATR
CA Business Oracle Behavior Detection to CA Anticipatory Profile BD_NTCPTRY_PRFL
CA Business Oracle Behavior Detection to CA Back Office Transaction BD_BACK_OFFICE_TRXN
CA Business Oracle Behavior Detection to CA Cash Transaction BD_CASH_TRXN
CA Business Oracle Behavior Detection to CA Client Bank BD_CLIENT_BANK
CA Business Oracle Behavior Detection to CA Client Bank List Membership BD_CB_LIST_MEMBERSHIP
CA Business Oracle Behavior Detection to CA Client Bank Peer Group BD_CLIENT_BANK_PEER_GRP
CA Business Oracle Behavior Detection to CA Client Bank Peer Transaction Summary Month BD_CB_PR_TRXN_SMRY_MNTH
CA Business Oracle Behavior Detection to CA Client Bank Summary Month BD_CLIENT_BANK_SMRY_MNTH
CA Business Oracle Behavior Detection to CA Customer Account Role BD_CUST_ACCT_ROLE
CA Business Oracle Behavior Detection to CA Customer to Customer BD_CUST_CUST
CA Business Oracle Behavior Detection to CA Customers BD_CUST
CA Business Oracle Behavior Detection to CA Customers Account BD_CUST_ACCT
CA Business Oracle Behavior Detection to CA Customers Address BD_CUST_ADDR
CA Business Oracle Behavior Detection to CA Customers Email Address BD_CUST_EMAIL_ADDR
CA Business Oracle Behavior Detection to CA Customers IMP License BD_CUST_IMP_LICENSE
CA Business Oracle Behavior Detection to CA Customers IMP License Good BD_CUST_IMP_LICENSE_GOOD
CA Business Oracle Behavior Detection to CA Customers List Membership BD_CUST_LIST_MEMBERSHIP
CA Business Oracle Behavior Detection to CA Customers Phone BD_CUST_PHON
CA Business Oracle Behavior Detection to CA Customers Summary Months BD_CUST_SMRY_MNTH
CA Business Oracle Behavior Detection to CA Customers Supplemental Attribute BD_CUST_SUPPLEMENTAL_ATR
CA Business Oracle Behavior Detection to CA Derived Address BD_DERIVED_ADDRESS
CA Business Oracle Behavior Detection to CA Employee BD_EMP
CA Business Oracle Behavior Detection to CA Employee List BD_EMPLOYEE
CA Business Oracle Behavior Detection to CA Employee Address BD_EMP_ADDR
CA Business Oracle Behavior Detection to CA Employee Email Address BD_EMP_EMAIL_ADDR
CA Business Oracle Behavior Detection to CA Employee Phone BD_EMP_PHON
CA Business Oracle Behavior Detection to CA Employee to Account BD_EMP_ACCT
CA Business Oracle Behavior Detection to CA External Entity BD_EXTERNAL_ENTITY
CA Business Oracle Behavior Detection to CA External Entity Address BD_EXTERNAL_ENTITY_ADDR
CA Business Oracle Behavior Detection to CA External Entity Link BD_FCC_EXTERNAL_ENTITY_LINK
CA Business Oracle Behavior Detection to CA External Entity Membership BD_EXTRNAL_NTTY_MMBRSHP
CA Business Oracle Behavior Detection to CA House Hold Summary Month BD_EVENT_ENTITY_MAP_HSM
CA Business Oracle Behavior Detection to CA HouseHold Balance Position Summary BD_HH_BAL_POSN_SMRY
CA Business Oracle Behavior Detection to CA Household summary Month BD_HH_SMRY_MNTH
CA Business Oracle Behavior Detection to CA Institution Master BD_INSTN_MASTER
CA Business Oracle Behavior Detection to CA Institutional Account Summary Month BD_INSTL_ACCT_SMRY_MNTH
CA Business Oracle Behavior Detection to CA Insurance Policy BD_INSURANCE_POLICY
CA Business Oracle Behavior Detection to CA Insurance Policy Customer BD_INSURANCE_POLICY_CUST
CA Business Oracle Behavior Detection to CA Insurance Product BD_INSURANCE_PRODUCT
CA Business Oracle Behavior Detection to CA Investment Manager BD_NVSMT_MGR
CA Business Oracle Behavior Detection to CA Investment Manager Summary Month BD_NVSMT_MGR_SMRY_MNTH
CA Business Oracle Behavior Detection to CA LinkAnalysis Link BD_LINKANALYSIS_LINK
CA Business Oracle Behavior Detection to CA LinkAnalysis LinkSummary BD_LINKANALYSIS_LINKSUMMARY
CA Business Oracle Behavior Detection to CA LinkAnalysis Network BD_LINKANALYSIS_NETWORK
CA Business Oracle Behavior Detection to CA LinkAnalysis Node BD_LINKANALYSIS_NODE
CA Business Oracle Behavior Detection to CA LinkAnalysis TypeSummary BD_LINKANALYSIS_TYPESUMMARY
CA Business Oracle Behavior Detection to CA Loan BD_LOAN
CA Business Oracle Behavior Detection to CA Loan Summary Month BD_LOAN_SMRY_MNTH
CA Business Oracle Behavior Detection to CA MI Transaction BD_MI_TRXN
CA Business Oracle Behavior Detection to CA Managed Account BD_MANGD_ACCT
CA Business Oracle Behavior Detection to CA Online Account BD_ONLINE_ACCT
CA Business Oracle Behavior Detection to CA Online Account BD_ONLINE_ACCT_ACCT
CA Business Oracle Behavior Detection to CA Peer Group BD_PEER_GRP
CA Business Oracle Behavior Detection to CA Trade BD_TRADE
CA Business Oracle Behavior Detection to CA TransactionPartyCrossReference BOT BD_TRXN_PARTY_XREF_BOT
CA Business Oracle Behavior Detection to CA TransactionPartyCrossReference FOT BD_TRXN_PARTY_XREF_FOT
CA Business Oracle Behavior Detection to CA Wire Transaction BD_WIRE_TRXN
Additional Information BD_ENTITY_SUP_INFO This sub-process code has to be executed after the business data population (see the Business Metadata Movement) BD_ENTITY_SUP_INFO
CA Evented Oracle Behavior Detection to CA Evented Account BD_ACCT_EVENT
CA Evented Oracle Behavior Detection to CA Evented Account ATM summary Daily BD_ACCT_ATM_SMRY_DAILY_EVNT
CA Evented Oracle Behavior Detection to CA Evented Account Address BD_ACCT_ACCT_ADDR_EVNT
CA Evented Oracle Behavior Detection to CA Evented Account Balance Position Summary BD_ACCT_BAL_POSN_SMRY_EVNT
CA Evented Oracle Behavior Detection to CA Evented Account Group BD_ACCT_GRP_EVNT
CA Evented Oracle Behavior Detection to CA Evented Account Peer Group BD_ACCT_PEER_GRP_EVNT
CA Evented Oracle Behavior Detection to CA Evented Account Peer Transaction Summary Month BD_ACCT_PR_TXN_SMRY_MN_EVNT
CA Evented Oracle Behavior Detection to CA Evented Account Restriction BD_ACCT_RSTRN_EVNT
CA Evented Oracle Behavior Detection to CA Evented Account Summary Month BD_ACCT_SMRY_MNTH_EVNT
CA Evented Oracle Behavior Detection to CA Evented Account Supplemental Attribute BD_ACCT_SUPPLEMENTAL_ATR_EVNT
CA Evented Oracle Behavior Detection to CA Evented Anticipatory Profile BD_NTCPTRY_PRFL_EVNT
CA Evented Oracle Behavior Detection to CA Evented Back Office Transaction BD_BACK_OFFICE_TRXN_EVNT
CA Evented Oracle Behavior Detection to CA Evented Cash Transaction BD_CASH_TRXN_EVNT
CA Evented Oracle Behavior Detection to CA Evented Client Bank BD_CLIENT_BANK_EVNT
CA Evented Oracle Behavior Detection to CA Evented Client Bank Peer Group BD_CLINT_BNK_PR_GRP_EVNT
CA Evented Oracle Behavior Detection to CA Evented Client Bank Peer Transaction Summary Month BD_CB_PR_TXN_SM_MNT_EVNT
CA Evented Oracle Behavior Detection to CA Evented Client Bank Summary Month BD_CLNT_BNK_SM_MNT_EVNT
CA Evented Oracle Behavior Detection to CA Evented Customer Balance Position Summary BD_CUST_BAL_POSN_SMRY_EVNT
CA Evented Oracle Behavior Detection to CA Evented Customers BD_CUST_EVNT
CA Evented Oracle Behavior Detection to CA Evented Customers IMP License BD_CUST_IMP_LICENSE_EVNT
CA Evented Oracle Behavior Detection to CA Evented Customers IMP License Good BD_CUST_IMP_LIC_GOD_EVNT
CA Evented Oracle Behavior Detection to CA Evented Customers Summary Months BD_CUST_SMRY_MNTH_EVNT
CA Evented Oracle Behavior Detection to CA Evented Customers Supsupplemental Attribute BD_CUST_SUPPL_ATR_EVNT
CA Evented Oracle Behavior Detection to CA Evented Customer Account Position BD_ACCT_POSN_ARC
CA Evented Oracle Behavior Detection to CA Evented Derived Address BD_DERIVED_ADDRESS_EVNT
CA Evented Oracle Behavior Detection to CA Evented Employee BD_EMP_EVNT
CA Evented Oracle Behavior Detection to CA Evented Employee Address BD_EMP_ADDR_EVNT
CA Evented Oracle Behavior Detection to CA Evented Employee Email Address BD_EMP_EMAIL_ADDR_EVNT
CA Evented Oracle Behavior Detection to CA Evented Employee Phone BD_EMP_PHON_EVNT
CA Evented Oracle Behavior Detection to CA Evented Employee to Account BD_EMP_ACCT_EVNT
CA Evented Oracle Behavior Detection to CA Evented External Entity BD_EXTERNAL_ENTITY_EVNT
CA Evented Oracle Behavior Detection to CA Evented External Entity Address BD_XTRNL_ENTY_ADR_EVNT
CA Evented Oracle Behavior Detection to CA Evented External Org BD_EXTRL_ORG_EVNT
CA Evented Oracle Behavior Detection to CA Evented HouseHold Balance Position Summary BD_HH_BAL_POSN_SMRY_EVNT
CA Evented Oracle Behavior Detection to CA Evented Household summary Month BD_HH_SMRY_MNTH_EVNT
CA Evented Oracle Behavior Detection to CA Evented Institution Master BD_INSTN_MASTER_EVNT
CA Evented Oracle Behavior Detection to CA Evented Insurance Policy BD_INSURANCE_POLICY_EVNT
CA Evented Oracle Behavior Detection to CA Evented Insurance Policy Customer BD_INS_PLCY_CUST_EVNT
CA Evented Oracle Behavior Detection to CA Evented Insurance Product BD_INSURANCE_PRODUCT_EVNT
CA Evented Oracle Behavior Detection to CA Evented Investment Manager BD_NVSMT_MGR_EVNT
CA Evented Oracle Behavior Detection to CA Evented Investment Manager Summary Month BD_NVSMT_MGR_SMRY_MNTH_EVNT
CA Evented Oracle Behavior Detection to CA Evented Loan BD_LOAN_EVNT
CA Evented Oracle Behavior Detection to CA Evented Loan Summary Month BD_LOAN_SMRY_MNTH_EVNT
CA Evented Oracle Behavior Detection to CA Evented MI Transaction BD_MI_TRXN_EVNT
CA Evented Oracle Behavior Detection to CA Evented Managed Account BD_MANGD_ACCT_EVNT
CA Evented Oracle Behavior Detection to CA Evented Online Account BD_ONLINE_ACCT_EVNT
CA Evented Oracle Behavior Detection to CA Evented Peer Group BD_PEER_GRP_EVNT
CA Evented Oracle Behavior Detection to CA Evented Trade BD_TRADE_EVNT
CA Evented Oracle Behavior Detection to CA Evented Wire Transaction BD_WIRE_TRXN_EVNT
CA Evented Oracle Behavior Detection to CA Evented Institutional Account Summary Month BD_INSTL_ACCT_SMRY_MNTH_EVNT
CA Evented Oracle Behavior Detection to CA Evented Execution BD_EXECUTION_EVNT
Following processes are related to network building block:
  • BD_LINKANALYSIS_LOOKUP (Oracle Behavior Detection to CA LinkAnalysis Lookup)
  • BD_LINKANALYSIS_NETWORK (Oracle Behavior Detection to CA LinkAnalysis Network)
  • BD_LINKANALYSIS_NODE (Oracle Behavior Detection to CA LinkAnalysis Node)
  • BD_LINKANALYSIS_LINK (Oracle Behavior Detection to CA LinkAnalysis Link)
  • BD_LINKANALYSIS_LINKSUMMARY(Oracle Behavior Detection to CA LinkAnalysis LinkSummary)
  • BD_LINKANALYSIS_TYPESUMMARY(Oracle Behavior Detection to CA LinkAnalysis TypeSummary)
The following table describes the Promote to Case T2Ts.

Table 20-4 Promote to Case T2Ts

LEVEL 0 LEVEL 1 LEVEL2 LEVEL 3
KDD_CASES KDD_CASE_ACCOUNTS KDD_CASE_ACCT_ADDRS
KDD_CASE_ACCT_ATM_SMRY_DAILY KDD_CASE_ACCT_BAL_POSN_SMRY
KDD_CASE_ACCT_GRP KDD_CASE_ACCT_LIST_MEMBERSHIPS
KDD_CASE_ACCT_ID_INSTN_ID_MAP KDD_CASE_ACCT_RSTRNS
KDD_CASE_ACCT_PEER_GRP KDD_CASE_ACCT_SMRY_MNTH
KDD_CASE_ACT_PEER_TXN_SMR_MNTH KDD_CASE_ACCT_SUPPL_ATTR
KDD_CASE_ATTRBT_VAL_MAP KDD_CASE_INSTL_ACCT_SMRY_MNTH
KDD_CASE_BACK_OFFICE_TRXN KDD_CASE_MANGD_ACCT
KDD_CASE_CASH_TRXN KDD_CASE_ACCT_EMAIL_ADDR
KDD_CASE_CB_PEER_TXN_SMRY_MNTH KDD_CASE_ACCT_PHON
KDD_CASE_CUSTOMERS KDD_CASE_HH_BAL_POSN_SMRY
KDD_CASE_CUST_ACCT KDD_CASE_HH_SMRY_MNTH
KDD_CASE_CUST_CREDIT_RTNG KDD_CASE_CUST_ADDRS
KDD_CASE_DERIVED_ADDRESS KDD_CASE_CUST_EMAILS
KDD_CASE_EMP KDD_CASE_CUST_LIST_MEMBERSHIPS
KDD_CASE_EMP_ACCT KDD_CASE_CUST_PHONS
KDD_CASE_INSTN_MASTER KDD_CASE_CUST_SMRY_MNTH
KDD_CASE_INSTRUCTION KDD_CASE_CUST_SUPPL_ATTR
KDD_CASE_INVOLVED_PARTY_LINK KDD_CASE_EMP_ADDR
KDD_CASE_LINKS KDD_CASE_EMP_EMAIL_ADDR
KDD_CASE_LOAN KDD_CASE_EMP_PHONE
KDD_CASE_CUST_CUST
KDD_CASE_LOSS_RECOVERY KDD_CASE_CB_LIST_MEMBERSHIP
KDD_CASE_LOSS_RECVRY_COST_CR KDD_CASE_CLIENT_BANK KDD_CASE_EXTRNL_NTITY_ADDR KDD_CASE_EXTRNL_NTITY_MBRSHP KDD_CASE_EXTRL_NTITY_SMRY_MNTH
KDD_CASE_MI_TRXN KDD_CASE_CLIENT_BANK_PEER_GRP KDD_CASE_EXTRNL_NTITY_ADDR KDD_CASE_EXTRNL_NTITY_MBRSHP KDD_CASE_EXTRL_NTITY_SMRY_MNTH
KDD_CASE_NARRATIVE KDD_CASE_CLIENT_BANK_SMRY_MNTH KDD_CASE_EXTRNL_NTITY_ADDR KDD_CASE_EXTRNL_NTITY_MBRSHP KDD_CASE_EXTRL_NTITY_SMRY_MNTH
  • KDD_CASE_ACCOUNTS (Level 1) process has to be executed before the execution of KDD_CASE_ACCT_ADDRS, KDD_CASE_ACCT_BAL_POSN_SMRY, KDD_CASE_ACCT_LIST_MEMBERSHIPS, KDD_CASE_ACCT_RSTRNS, KDD_CASE_ACCT_SMRY_MNTH, KDD_CASE_ACCT_SUPPL_ATTR, KDD_CASE_INSTL_ACCT_SMRY_MNTH, KDD_CASE_MANGD_ACCT, KDD_CASE_ACCT_EMAIL_ADDR, and KDD_CASE_ACCT_PHON.
  • KDD_CASE_ACCT_GRP (Level 1) process has to be executed before the execution of KDD_CASE_HH_BAL_POSN_SMRY, and KDD_CASE_HH_SMRY_MNTH.
  • KDD_CASE_CUSTOMERS (Level 1) process has to be executed before the execution of KDD_CASE_CUST_ADDRS, KDD_CASE_CUST_EMAILS, KDD_CASE_CUST_LIST_MEMBERSHIPS, KDD_CASE_CUST_PHONS, KDD_CASE_CUST_SMRY_MNTH, and KDD_CASE_CUST_SUPPL_ATTR.
  • KDD_CASE_EMP (Level 1) process has to be executed before the execution of KDD_CASE_EMP_ADDR, KDD_CASE_EMP_EMAIL_ADDR, and KDD_CASE_EMP_PHON.
  • KDD_CASE_INSTN_MASTER (Level 1) process has to be executed before execution of KDD_CASE_CB_LIST_MEMBERSHIP, KDD_CASE_CLIENT_BANK, KDD_CASE_CLIENT_BANK_PEER_GRP, KDD_CASE_CLIENT_BANK_SMRY_MNTH, and KDD_CASE_EXTERNAL_ENTITY.
  • KDD_CASE_LOAN (Level 1) process has to be executed before the execution of KDD_CASE_LOAN_SMRY_MNTH.
  • KDD_CASE_NVSMT_MGR (Level 1) process has to be executed before the execution of KDD_CASE_NVSMT_MGR_SMRY_MNTH.
  • KDD_CASE_EXTERNAL_ENTITY (Level 2) process has to be executed before execution of KDD_CASE_EXTRNL_NTITY_ADDR, KDD_CASE_EXTRNL_NTITY_MBRSHP, and KDD_CASE_EXTRL_NTITY_SMRY_MNTH.

End Batch

BD_ECM_End_E2E_Batch is used for ending the batch execution for BD.