Anomalies Detected

Anomalies Detected (2)

Holdings by Region Error (Confidence: 90%)

Source Table: Fund Holdings

Security	Suffix	Market Value (USD)	Region Roll-up %
BP PLC	.LSEG	$50,000,000	25%
HSBC Holdings	.LSEG	$60,000,000	30%
Unilever PLC	.LSEG	$70,000,000	35%
CRH plc	.LSEG	$20,000,000	10%
UK Rollup	—	$180,000,000	110%

Anomalous Sensors:

Time series sensor
Distribution Divergence Sensor

Unlisted Securities Percentage (Confidence: 88%)

Source Table: Fund Holdings

Security Name	Ticker	CUSIP	Market Value (USD)	Portfolio %
Samsung Electronics Co Ltd	005930.KS	Y74758104	$12,500,000	2.5%
Taiwan Semiconductor	TSM	874039100	$15,000,000	3.0%
Private Equity Co-Investment III	—	—	$8,000,000	1.6%
Unlisted Infrastructure Debt Fund	—	—	$6,500,000	1.3%
Pre-IPO Convertible Note - TechStartup X	—	—	$4,500,000	0.9%

Anomalous Sensors:

Unique Value Count Sensor
Numeric Categorical Interaction Variation Sensor

Root Cause Diagnosis: Region Roll up not 100%, calculation error

Similar Historical Incidents

Date: Feb 12, 2024

Resolution Team: Marketing Operations

92%

Data issue

UK region rollup added to 85%

What Happened

Irish stocks retained .LSEG suffix after Brexit but were classified as non-UK in allocation logic.

How It Was Resolved

Updated Sector Roll up to remove anomaly. New calculation logic implemented to map suffixes to correct region

Root Cause Diagnosis: ETF portfolio contains 3.8% unlisted securities (exceeds 2% regulatory threshold). Missing security identifiers preventing proper classification and risk assessment.

Similar Historical Incidents

No similar historical incidents found.

Likely Causes

Alternative Investment Data Feed Integration Failure
Private equity data has come from a different system that doesn't connect to our main security database. Their system uses different ID numbers that don't match our standard stock identifiers.
Pre-IPO Security Classification Override
Users manually entered private investments without proper ID checks. They skipped the validation steps to meet a deadline for reporting new investments
Fund-of-Funds Structure Transparency Gap
When importing fund data, we only see the total value - not what's inside the fund. The system can't break down these complex funds to show the individual investments.

This is the query used to identify the records highlighted in the table.

Anomalies Detected

Source Table: Fund Holdings

Source Table: Fund Holdings

Similar Historical Incidents

Similar Historical Incidents

Traditional SQL Query