SUPPORT / SAMPLES & SAS NOTES
 

Support

Installation Note 69237: Primary keys are not defined for Core database tables in the SAS® Anti-Money Laundering Oracle DDL

DetailsHotfixAboutRate It

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

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Anti-Money LaunderingLinux for x648.3Viya
* 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.