Independent and not affiliated with the FDA, MHRA, ISPE, PDA, or any agency. Get the appgoutham@madhadi.com
madhadi.comData Integrity & GxP Quality
Browse all topics → Articles Templates & Procedures Learning paths GlossaryScenariosToolsRegulatory ReferencesLearning PathsTopics About Start here
Log Plug-and-play starting point Supply Chain & GDP

Log: DSCSA Exception and Data Discrepancy Log

A plug-and-play log for tracking DSCSA/EPCIS data exceptions separately from suspect-product investigations: schema failures, VRS timeouts, aggregation mismatches, late transmissions, the triage decision, resolution, and trend review, with a filled specimen.

Document type: Log

Read and copy the template below into your own quality system. It is a generic starting point for your own internal use, provided as is, with no warranty; see the Terms and License. Adopting it does not by itself create compliance.

This is a ready-to-use log for tracking DSCSA and EPCIS data exceptions, the technical and data-quality failures that are common at volume and are not, by themselves, evidence about product legitimacy. Keeping this log separate from the suspect and illegitimate product investigation record does two things: it stops routine connectivity noise from diluting a patient-safety investigation log, and it makes chronic trading-partner or platform problems visible as a trend, not just a string of one-off tickets. Replace every <<FILL: ...>> placeholder. A filled specimen follows. This content is educational and general, not legal or regulatory advice.

Document control header

FieldEntry
Document titleDSCSA Exception and Data Discrepancy Log
Document number<<FILL: LOG-ID, e.g. LOG-SC-027>>
Version<<FILL: version>>
Owner<<FILL: role, e.g. Trade Compliance Manager>>
Parent SOP<<FILL: suspect/illegitimate product SOP ID, for the escalation path>>
Review cadence<<FILL: e.g. weekly entry review, monthly trend review>>
Retention<<FILL: period, generally aligned to the 6-year DSCSA record period>>

When to use this log versus the suspect-product investigation record

Log an entry here for any EPCIS or verification event that does not reconcile cleanly. Most entries close as a data exception and never leave this log. An entry is escalated to the suspect and illegitimate product investigation record, per <<FILL: SOP-ID>>, only when the cause cannot be explained and reproduced as an internal or trading-partner data or IT problem, or when an independent physical or transactional red flag is present alongside it. Record the triage decision here either way, and cross-reference the investigation number when one is opened.

Field definitions

FieldFormatRequiredWhoWhen
Entry IDtextYesLoggerOn detection
Date / time detectedYYYY-MM-DD HH:MMYesLoggerOn detection
Connection / trading partnertextYesLoggerOn detection
Product / NDC / lot (if applicable)textNoLoggerOn detection
Exception categoryschema failure / VRS timeout / GLN mismatch / aggregation mismatch / late transmission / duplicate event / otherYesLoggerOn detection
Descriptionfree textYesLoggerOn detection
Triage decisiondata exception / suspect-product triggerYesLogger, reviewed by QA or trade complianceAt triage
Cause identifiedfree text (mapping error, outage, known lag, unexplained)YesInvestigatorAt resolution
Escalated to investigationinvestigation number or “No”YesTrade compliance / QAIf escalated
Resolutionfree textYesInvestigatorAt closure
Closure dateYYYY-MM-DDYesReviewerAt closure

Log

Entry IDDate/timeConnectionCategoryDescriptionTriageEscalatedResolutionClosed
<<FILL>><<FILL>><<FILL>><<FILL>><<FILL>><<FILL>><<FILL>><<FILL>><<FILL>>

Monthly trend review

Perform this review on the cadence in the header, even in a month with no entries; a zero-entry month is itself recorded, not omitted.

FieldEntry
Review period<<FILL: from>> to <<FILL: to>>
Total entries<<FILL>>
By category<<FILL: count per category>>
By connection / trading partner<<FILL: count per partner, flag any partner with a rising count>>
Escalated to suspect-product investigation<<FILL: count and investigation numbers>>
Recurring or unresolved pattern identified<<FILL: e.g. one partner's connection producing repeated late-transmission entries>>
Action arising<<FILL: e.g. change control on a mapping fix, a conversation with the partner, an EPCIS version review>>
Reviewed by (name, date)<<FILL>>

Acceptance criteria

  • Every EPCIS or verification event that does not reconcile has an entry, whether or not it is escalated.
  • The triage decision and its rationale are recorded for every entry, not just the escalated ones.
  • No entry sits open past <<FILL: target closure time, e.g. 5 business days>> without an assigned owner and a documented reason.
  • The monthly trend review identifies recurring patterns by connection and by category, and every identified pattern has a stated action or a documented reason none was needed.
  • Escalated entries cross-reference the investigation number, and closed suspect-product investigations that originated here are traceable back to their log entry.

References

DSCSA, section 582 of the Federal Food, Drug, and Cosmetic Act (21 U.S.C. 360eee-1); suspect/illegitimate product provisions. GS1 EPCIS and CBV standards (message and vocabulary conformance, the source of most schema-level exceptions). FDA guidance on DSCSA suspect and illegitimate product identification and notification.

Confirm the current statute and guidance before issue.

Revision history

VersionDateAuthorSummary of change
<<FILL: 1.0>><<FILL: date>><<FILL: author>>Initial issue.

Filled specimen

A week of illustrative entries for a wholesale distributor’s serialization program, followed by the trend review that catches the pattern a single entry would not show.

Entry IDDate/timeConnectionCategoryDescriptionTriageEscalatedResolutionClosed
EXC-2026-03012026-08-11 09:14Manufacturer B (AS2)Late transmissionT3/EPCIS for shipment SH-88213 arrived 6 hours after physical receiptData exceptionNoKnown lag on Manufacturer B’s batch AS2 window; no product impact, product held pending data per WI2026-08-11
EXC-2026-03022026-08-12 14:02Manufacturer B (AS2)Late transmissionT3/EPCIS for shipment SH-88240 arrived 5.5 hours after physical receiptData exceptionNoSame known cause as EXC-2026-03012026-08-12
EXC-2026-03032026-08-13 10:40VRS networkVRS timeoutVerification request on a saleable return timed out after 15 seconds, 2 retriesData exceptionNoResponder maintenance window confirmed with manufacturer; unit quarantined per WI pending retry, retried successfully next business day2026-08-14
EXC-2026-03042026-08-14 11:55Manufacturer B (AS2)Late transmissionT3/EPCIS for shipment SH-88266 arrived 7 hours after physical receiptData exceptionNoSame cause, third occurrence in the week2026-08-14
EXC-2026-03052026-08-15 16:20VRS networkVRS invalidVerification on a saleable return returned explicit invalid, not a timeoutSuspect-product triggerYes, SIP-2026-021Escalated per SOP; see suspect-product investigation recordOpen, tracked in SIP-2026-021

Trend review, August 2026:

FieldEntry
Total entries5
By categoryLate transmission: 3, VRS timeout: 1, VRS invalid: 1
By connectionManufacturer B: 3 (all late transmission), VRS network: 2
Escalated1 (EXC-2026-0305, SIP-2026-021)
Pattern identifiedThree late-transmission entries from Manufacturer B in one week, each individually triaged as a data exception with no product impact, but the recurrence itself is the signal: this is a chronic connection issue, not three unrelated events.
Action arisingRaised with Manufacturer B’s trade compliance contact; requested either a shorter batch window or a move to a faster transport. Tracked as a partner-connection improvement item, not a deviation, since no product was affected. Re-review in 30 days to confirm the pattern resolves.
Reviewed byM. Duarte, Trade Compliance, 02 Sep 2026

What this specimen teaches: none of the three late-transmission entries individually looked worth escalating, and each was correctly triaged as a data exception on its own. It was the trend review, not any single entry, that turned three shrugged-off events into an action against the partner connection. That is exactly what a log separate from the investigation record is for.

Common inspection findings this log prevents

  • No record exists of EPCIS or verification exceptions that did not rise to a suspect-product investigation, so the program cannot show it tracks or trends its own data quality.
  • A pattern of the same connection or partner producing repeated exceptions was never surfaced because each one was closed individually with no trend review.
  • Every technical exception was escalated to the suspect-product SOP by default, producing an inflated investigation count that obscures the real patient-safety signals inside it.
  • An exception that should have been escalated (an explicit invalid verification, not a timeout) was logged and closed here without ever reaching the suspect-product workflow.
  • Zero-entry periods are simply not recorded, so it cannot be shown the exception process was running at all during that period.

How to adapt this log

  1. Set your document number, owner, cadence, and parent SOP in the header.
  2. Add categories specific to your platform (for example a specific EPCIS field validation your system flags) alongside the generic ones.
  3. Tie the escalation field directly to your suspect/illegitimate product SOP’s investigation numbering so the two records cross-reference cleanly.
  4. Feed the monthly trend review into your supplier or trading-partner performance review, not just an internal file, so a chronic partner-side problem becomes visible where it can actually be fixed.
  5. Confirm the current statute and guidance referenced before issue.
Use madhadi.com as an app Full screen, works offline, one tap from your home screen.