SUPPORT / SAMPLES & SAS NOTES
Installation Note 69236: Foreign keys for SAS® Anti-Money Laundering Core database tables are missing in the Oracle DDL
 |  |  |  |  |
The foreign key constraints on the following Core database tables are missing in the SAS Anti-Money Laundering Oracle DDL (data definition language):
- Account Event Fact table - FSC_ACCOUNT_EVENT_FACT
ALTER TABLE core.fsc_account_event_fact
ADD CONSTRAINT fsc_account_event_fact_branch_key_fkey FOREIGN KEY ("branch_key")
REFERENCES core.fsc_branch_dim,
ADD CONSTRAINT fsc_account_event_fact_account_key_fkey FOREIGN KEY ("account_key")
REFERENCES core.fsc_account_dim,
ADD CONSTRAINT fsc_account_event_fact_transaction_type_key_fkey FOREIGN KEY ("transaction_type_key")
REFERENCES core.fsc_transaction_type_dim,
ADD CONSTRAINT fsc_account_event_fact_transaction_status_key_fkey FOREIGN KEY ("transaction_status_key")
REFERENCES core.fsc_transaction_status_dim,
ADD CONSTRAINT fsc_account_event_fact_transaction_key_fkey FOREIGN KEY ("transaction_key")
REFERENCES core.fsc_transaction_dim;
ADD CONSTRAINT fsc_account_event_fact_branch_key_fkey FOREIGN KEY ("branch_key")
REFERENCES core.fsc_branch_dim,
ADD CONSTRAINT fsc_account_event_fact_account_key_fkey FOREIGN KEY ("account_key")
REFERENCES core.fsc_account_dim,
ADD CONSTRAINT fsc_account_event_fact_transaction_type_key_fkey FOREIGN KEY ("transaction_type_key")
REFERENCES core.fsc_transaction_type_dim,
ADD CONSTRAINT fsc_account_event_fact_transaction_status_key_fkey FOREIGN KEY ("transaction_status_key")
REFERENCES core.fsc_transaction_status_dim,
ADD CONSTRAINT fsc_account_event_fact_transaction_key_fkey FOREIGN KEY ("transaction_key")
REFERENCES core.fsc_transaction_dim;
- Account Trade Fact - FSC_ACCOUNT_TRADE_FACT
ALTER TABLE core.fsc_account_trade_fact
ADD CONSTRAINT fsc_account_trade_fact_branch_key_fkey FOREIGN KEY ("branch_key")
REFERENCES core.fsc_branch_dim,
ADD CONSTRAINT fsc_account_trade_fact_account_key_fkey FOREIGN KEY ("account_key")
REFERENCES core.fsc_account_dim,
ADD CONSTRAINT fsc_account_trade_fact_transaction_type_key_fkey FOREIGN KEY ("transaction_type_key")
REFERENCES core.fsc_transaction_type_dim,
ADD CONSTRAINT fsc_account_trade_fact_transaction_status_key_fkey FOREIGN KEY ("transaction_status_key")
REFERENCES core.fsc_transaction_status_dim,
ADD CONSTRAINT fsc_account_trade_fact_associate_key_fkey FOREIGN KEY ("associate_key")
REFERENCES core.fsc_associate_dim,
ADD CONSTRAINT fsc_account_trade_fact_transaction_key_fkey FOREIGN KEY ("transaction_key")
REFERENCES core.fsc_transaction_dim;
ADD CONSTRAINT fsc_account_trade_fact_branch_key_fkey FOREIGN KEY ("branch_key")
REFERENCES core.fsc_branch_dim,
ADD CONSTRAINT fsc_account_trade_fact_account_key_fkey FOREIGN KEY ("account_key")
REFERENCES core.fsc_account_dim,
ADD CONSTRAINT fsc_account_trade_fact_transaction_type_key_fkey FOREIGN KEY ("transaction_type_key")
REFERENCES core.fsc_transaction_type_dim,
ADD CONSTRAINT fsc_account_trade_fact_transaction_status_key_fkey FOREIGN KEY ("transaction_status_key")
REFERENCES core.fsc_transaction_status_dim,
ADD CONSTRAINT fsc_account_trade_fact_associate_key_fkey FOREIGN KEY ("associate_key")
REFERENCES core.fsc_associate_dim,
ADD CONSTRAINT fsc_account_trade_fact_transaction_key_fkey FOREIGN KEY ("transaction_key")
REFERENCES core.fsc_transaction_dim;
- Cash Flow Bank Bridge - FSC_CASH_FLOW_BANK_BRIDGE
ALTER TABLE core.fsc_cash_flow_bank_bridge
ADD CONSTRAINT fsc_cash_flow_bank_bridge_bank_key_fkey FOREIGN KEY ("bank_key")
REFERENCES core.fsc_bank_dim,
ADD CONSTRAINT fsc_cash_flow_bank_bridge_transaction_key_fkey FOREIGN KEY ("transaction_key")
REFERENCES core.fsc_transaction_dim;
ADD CONSTRAINT fsc_cash_flow_bank_bridge_bank_key_fkey FOREIGN KEY ("bank_key")
REFERENCES core.fsc_bank_dim,
ADD CONSTRAINT fsc_cash_flow_bank_bridge_transaction_key_fkey FOREIGN KEY ("transaction_key")
REFERENCES core.fsc_transaction_dim;
- Cash Flow Fact - FSC_CASH_FLOW_FACT
ALTER TABLE core.fsc_cash_flow_fact
ADD CONSTRAINT fsc_cash_flow_fact_transaction_key_fkey FOREIGN KEY ("transaction_key")
REFERENCES core.fsc_transaction_dim,
ADD CONSTRAINT fsc_cash_flow_fact_account_key_fkey FOREIGN KEY ("account_key")
REFERENCES core.fsc_account_dim,
ADD CONSTRAINT fsc_cash_flow_fact_transaction_type_key_fkey FOREIGN KEY ("transaction_type_key")
REFERENCES core.fsc_transaction_type_dim,
ADD CONSTRAINT fsc_cash_flow_fact_transaction_status_key_fkey FOREIGN KEY ("transaction_status_key")
REFERENCES core.fsc_transaction_status_dim,
ADD CONSTRAINT fsc_cash_flow_fact_branch_key_fkey FOREIGN KEY ("branch_key")
REFERENCES core.fsc_branch_dim,
ADD CONSTRAINT fsc_cash_flow_fact_remitter_ext_party_key_fkey FOREIGN KEY ("remitter_ext_party_key")
REFERENCES core.fsc_ext_party_account_dim,
ADD CONSTRAINT fsc_cash_flow_fact_beneficiary_ext_party_key_fkey FOREIGN KEY ("beneficiary_ext_party_key")
REFERENCES core.fsc_ext_party_account_dim,
ADD CONSTRAINT fsc_cash_flow_fact_associate_key_fkey FOREIGN KEY ("associate_key")
REFERENCES core.fsc_associate_dim,
ADD CONSTRAINT fsc_cash_flow_fact_executing_party_key_fkey FOREIGN KEY ("executing_party_key")
REFERENCES core.fsc_party_dim,
ADD CONSTRAINT fsc_cash_flow_fact_executing_ext_party_key_fkey FOREIGN KEY ("executing_ext_party_key")
REFERENCES core.fsc_ext_party_account_dim,
ADD CONSTRAINT fsc_cash_flow_fact_secondary_account_key_fkey FOREIGN KEY ("secondary_account_key")
REFERENCES core.fsc_account_dim;
ADD CONSTRAINT fsc_cash_flow_fact_transaction_key_fkey FOREIGN KEY ("transaction_key")
REFERENCES core.fsc_transaction_dim,
ADD CONSTRAINT fsc_cash_flow_fact_account_key_fkey FOREIGN KEY ("account_key")
REFERENCES core.fsc_account_dim,
ADD CONSTRAINT fsc_cash_flow_fact_transaction_type_key_fkey FOREIGN KEY ("transaction_type_key")
REFERENCES core.fsc_transaction_type_dim,
ADD CONSTRAINT fsc_cash_flow_fact_transaction_status_key_fkey FOREIGN KEY ("transaction_status_key")
REFERENCES core.fsc_transaction_status_dim,
ADD CONSTRAINT fsc_cash_flow_fact_branch_key_fkey FOREIGN KEY ("branch_key")
REFERENCES core.fsc_branch_dim,
ADD CONSTRAINT fsc_cash_flow_fact_remitter_ext_party_key_fkey FOREIGN KEY ("remitter_ext_party_key")
REFERENCES core.fsc_ext_party_account_dim,
ADD CONSTRAINT fsc_cash_flow_fact_beneficiary_ext_party_key_fkey FOREIGN KEY ("beneficiary_ext_party_key")
REFERENCES core.fsc_ext_party_account_dim,
ADD CONSTRAINT fsc_cash_flow_fact_associate_key_fkey FOREIGN KEY ("associate_key")
REFERENCES core.fsc_associate_dim,
ADD CONSTRAINT fsc_cash_flow_fact_executing_party_key_fkey FOREIGN KEY ("executing_party_key")
REFERENCES core.fsc_party_dim,
ADD CONSTRAINT fsc_cash_flow_fact_executing_ext_party_key_fkey FOREIGN KEY ("executing_ext_party_key")
REFERENCES core.fsc_ext_party_account_dim,
ADD CONSTRAINT fsc_cash_flow_fact_secondary_account_key_fkey FOREIGN KEY ("secondary_account_key")
REFERENCES core.fsc_account_dim;
- External Party Account - FSC_EXT_PARTY_ACCOUNT_DIM
ALTER TABLE core.fsc_ext_party_account_dim
ADD CONSTRAINT fsc_ext_party_account_dim_bank_key_fkey FOREIGN KEY ("bank_key")
REFERENCES core.fsc_bank_dim;
ADD CONSTRAINT fsc_ext_party_account_dim_bank_key_fkey FOREIGN KEY ("bank_key")
REFERENCES core.fsc_bank_dim;
A workaround is to apply these foreign key constraints.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Anti-Money Laundering | Linux for x64 | 8.3 | Viya | ||