Installation Note 69237: Primary keys are not defined for Core database tables in the SAS® Anti-Money Laundering Oracle DDL
The SAS Anti-Money Laundering Oracle DDL (data definition language) is missing primary key constraints for the following Core database tables:
- FSC_ACCOUNT_TRADE_FACT
- FSC_EXT_PARTY_ACCOUNT_DIM
- FSC_HOUSEHOLD_ACCOUNT_BRIDGE
- FSC_TRANSACTION_STATUS_DIM
- FSC_ACCOUNT_EVENT_FACT
- FSC_ASSOCIATE_DIM
- FSC_ACCOUNT_DIM
- FSC_PARTY_DIM
- FSC_HOUSEHOLD_DIM
- FSC_PARTY_ACCOUNT_BRIDGE
- FSC_BRANCH_DIM
- FSC_TRANSACTION_TYPE_DIM
- FSC_ACCOUNT_PROFILE_FACT
- FSC_CASH_FLOW_FACT
- FSC_HOUSEHOLD_PARTY_BRIDGE
- FSC_TRANSACTION_DIM
- FSC_PARTY_PROFILE_FACT
- FSC_BANK_DIM
- FSC_CASH_FLOW_BANK_BRIDGE
- FSC_ADDRESS_DIM
- FSC_PARTY_ASSOC
- WL_TEMP_ADDRESS_MC_DIM
- WL_TEMP_PARTY_MC_DIM
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
| SAS System | SAS Anti-Money Laundering | Linux for x64 | 8.3 | | Viya | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
| Type: | Installation Note |
| Priority: | medium |
| Date Modified: | 2023-06-21 12:22:16 |
| Date Created: | 2022-05-26 10:54:13 |
