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 | ||
An update for this issue is available for SAS Compliance Solutions 8.3. For instructions on how to access and apply these software updates, see the documentation links at the top of
https://tshf.sas.com/techsup/download/hotfix/HF2/ComplianceSol_83_home.html#69236| Type: | Installation Note |
| Priority: | medium |
| Date Modified: | 2023-06-21 12:26:29 |
| Date Created: | 2022-05-26 10:36:43 |