Flow visibility and data quality · Lesson 4

Investigate exceptions from event records

5 min read

Lesson objectives

  • Locate the last verified event and order gap, test alternative explanations with specific records, and escalate service impact without inventing a cause.

When a customer says an order is late, “late” describes an outcome, not its cause. A specialist inspects the event chain, finds the last point supported by evidence, and compares it with the next expected event. Goods may be delayed, record updates may be delayed, or a promise may have changed without the customer knowing. Each possibility requires different evidence. Keep three columns: verified fact, testable hypothesis and temporary service-protection decision. This prevents one system message from becoming an unsupported accusation against a supplier or carrier.

Start by fixing the scope: which order, line, quantity and promised date? Sort events by when they happened, not only by when someone entered them. If both timestamps exist, retain both: “occurred Tuesday, posted Thursday” suggests a recording delay, not that goods moved Thursday. Normalize time zones before comparing. Label events as commitment, physical movement, information movement or quality check. “Shipping label printed” is an information event, not proof of carrier acceptance. “Truck arrived at site” is a transport event, not proof that all contents passed receipt. The labels turn a status bar into an evidence chain.

Choose a temporary decision without pretending to know the cause. First, preserve the original customer promise; do not edit it to improve the metric. Second, quantify the impact: 2÷20=10% of the order quantity lacks confirmed delivery, and the order is incomplete under a complete-order measure despite the majority arriving. Third, request the warehouse's parcel-level handover record and the carrier's scan list, including any alternate shipment ID. Fourth, alert the customer-service owner to the gap and the expected evidence-check time. That owner decides whether to contact the customer or ship replacements under local policy. The specialist should not delay escalation until a cause is certain, or promise information that has not been verified.

Priority depends on impact, proximity of the next decision and whether evidence can be recovered. A two-unit difference in a safety-sensitive product is unlike a two-unit difference in promotional material, but this program does not set industry-specific safety or compensation rules. A further distinction arises if the customer explicitly agreed to split shipment. Record that condition before classifying the order against a service measure. If many orders lack several events during the same period, suspect a data-integration issue and request a sample of movement IDs rather than opening unrelated tickets. That escalates a possible class of defect; it does not prove a root cause.

An exception record keeps the investigation from becoming endless conversation. Give it an ID linked to the order, detection time, last verified event, expected next event, calculated difference, required source, response owner and next check time. Close it when the customer impact is handled and the record corrected, or when an authorized follow-up decision is recorded. A root cause may remain unresolved after the order is served; track process improvement separately instead of claiming to have solved the cause without evidence. Distinguishing closure of an order's impact from a structural fix is a practical specialist skill.

Lesson summary

Separate verified event, hypothesis and temporary decision. An absent scan does not prove lost goods, and resolving customer impact does not prove root cause.