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 Quality Assurance

Log: OOS Trending and Repeat-Failure Register

A plug-and-play structured register for out-of-specification results built so recurring failures by method, analyst, instrument, and product can actually be trended and caught as a systemic signal, with metrics, thresholds, a review cadence, and 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 register for capturing OOS events in a structured, queryable form so recurring problems by method, analyst, instrument, or product surface before they become a pattern an inspector finds first. A single OOS is a laboratory or manufacturing event; the same method, the same instrument, or the same analyst behind several OOS events in a short window is a quality system signal, and you can only see the second if the data is structured, discrete fields, not prose summaries. Keep one register per site or per laboratory. Replace every <<FILL: ...>> placeholder, maintain it in a queryable system rather than a narrative log, and route the review record through your normal QA oversight. Verify each cited regulation against the current source before you rely on it.

Why structure matters

An OOS investigation record answers “what happened with this result.” This register answers a different question: “does this keep happening, and to what.” A laboratory that closes every individual OOS competently can still have a failing instrument, an undertrained analyst, or a marginal method generating a disproportionate share of them, and that will not show up anywhere unless the closed investigations are coded into fields and counted. This register is the layer between the individual OOS investigation record and the quality metrics program: narrower and more diagnostic than an aggregate OOS rate, because it is broken out by the specific method, analyst, instrument, and product that generated each event.

Part 1: OOS register (one row per event)

FieldFormatRequiredNotes
OOS IDTextYesLinks to the full investigation record
Date openedDateYesFor time-based trending
Material / productText or codeYesFor per-product rates
Test / method (ID, version)CodeYesFor per-method rates
Instrument IDCodeYes, where applicableFor per-instrument rates
AnalystInitials or IDYesFor per-analyst rates; never used punitively without a documented process cause first
Phase 1 conclusionAssignable cause / No causeYesDrives the lab-error fraction
Assignable-cause categoryControlled listConditionale.g. integration, preparation, standard/reagent, equipment/SST, calculation, other
Phase 2 root-cause categoryControlled listConditionale.g. process parameter, raw material, equipment, N/A if closed at Phase 1
DispositionRelease / Reject / Further characterizeYes
CAPA referenceTextConditionalWhere raised
Closure dateDateYes, to closeFor time-to-close
Timeline metYes / NoYesPer the governing OOS SOP target

Register table

OOS IDDateMaterialMethodInstrumentAnalystPhase 1Cause categoryPhase 2 categoryDispositionCAPAClosedOn time
<<FILL>><<FILL>><<FILL>><<FILL>><<FILL>><<FILL>><<FILL>><<FILL>><<FILL>><<FILL>><<FILL>><<FILL>><<FILL>>

Compute on a defined cadence (commonly monthly, with a rolling quarterly and annual view for the periodic review and the product’s annual review). Use the right denominator so a high-throughput method or a busy analyst is not unfairly flagged.

MetricDefinitionThreshold / action
Overall OOS rateConfirmed OOS per <<FILL: 1,000 tests>><<FILL: e.g. above 12-month baseline = review>>
OOS rate by methodOOS per <<FILL: 100 runs>>, per method ID<<FILL: e.g. > 2x the site mean for that method type = method robustness review>>
OOS rate by instrumentOOS (especially SST/equipment-category assignable causes) per <<FILL: 100 runs>>, per instrument ID<<FILL: e.g. >= N assignable-cause events in a quarter = maintenance/requalification trigger>>
OOS rate by analystOOS per <<FILL: 100 runs performed>>, per analyst<<FILL: e.g. >= N events with the same cause category = training signal, not a disciplinary trigger by itself>>
OOS rate by product / materialConfirmed OOS per <<FILL: 100 batches or lots tested>>, per product<<FILL: rising trend = feed to Phase 2 pattern review and the product's annual review>>
Lab-error fractionEvents closed at Phase 1 (assignable cause) / total events<<FILL: rising fraction = lab practice or training signal; falling fraction with rising Phase 2 closures = potential product/process signal>>
Repeat-cause rateEvents sharing the same cause category, same method or instrument, within the period / total events<<FILL: >= N repeats = systemic, not isolated>>
On-time closure rateEvents closed within the SOP-committed timeline / total closed<<FILL: target %>>

Part 3: Review record

FieldEntry
Review period<<FILL>>
Total OOS events in period<<FILL>>
Metrics reviewed against thresholds<<FILL>>
Outliers identified (method / instrument / analyst / product)<<FILL>>
Decisions (requalification, retraining, method review, CAPA, escalate to management review)<<FILL>>
Prior-period actions: status<<FILL: closed / open, overdue called out>>
Reviewer (name, date)<<FILL>>
QA approval (name, date)<<FILL>>

Acceptance criteria

  • OOS data is captured in discrete, queryable fields (method, instrument, analyst, product, cause category), not free text.
  • Metrics are computed on the defined cadence with the correct denominator, so a busy method or analyst is not flagged on raw count alone.
  • Any metric crossing its threshold is named in the review record with a decision and an owner; a review that always concludes “no action” is not a real review.
  • Repeat-cause concentration by instrument, method, or analyst is explicitly checked, not left to be noticed by chance.
  • The register feeds, and is reconciled against, the site’s quality metrics program rather than existing as a parallel, disconnected count.

Retention

Retain the register and each period’s review record per the records retention schedule, for not less than <<FILL: retention period>>.

References

21 CFR 211.192 (investigation of discrepancies and failures) and 211.180(e) (review of records to evaluate quality standards, including trend detection). FDA Guidance for Industry, Investigating Out-of-Specification (OOS) Test Results for Pharmaceutical Production (originally October 2006, Level 2 revision May 2022). ICH Q10, Pharmaceutical Quality System (performance monitoring, management review, and continual improvement). ICH Q9, Quality Risk Management (risk-based prioritization of signals arising from trends). EU GMP Chapter 1 (Pharmaceutical Quality System) and the Product Quality Review.

Confirm the current version of each reference before issue.


Filled specimen

The following shows one quarter’s register excerpt and review for an example QC laboratory, so you can see the level of detail an inspector expects. The company, instrument, and numbers are illustrative; replace them with your own.

Reporting period: 01 May 2026 to 31 July 2026. Scope: finished-product HPLC assay testing, Site B QC laboratory.

Register (excerpt)

OOS IDDateMaterialMethodInstrumentAnalystPhase 1Cause categoryDispositionCAPAOn time
OOS-2026-011812 MayProduct X, lot AB1211AM-201 v6HPLC-07J. DoeAssignable causeIntegrationRelease (corrected)CAPA-2026-0061Yes
OOS-2026-013429 MayProduct X, lot AB1219AM-201 v6HPLC-07J. DoeAssignable causeIntegrationRelease (corrected)CAPA-2026-0061Yes
OOS-2026-015114 JunProduct Y, lot CD3302AM-114 v3HPLC-07S. NairAssignable causeSST failureRelease (corrected)CAPA-2026-0074Yes
OOS-2026-014202 JunProduct X, lot AB1234AM-201 v6HPLC-07J. DoeAssignable causeIntegrationRelease (corrected)CAPA-2026-0078Yes
OOS-2026-016709 JulProduct Z, lot EF4410AM-201 v6HPLC-11M. AlvarezNo causeN/ARejectCAPA-2026-0091Yes
MetricValueDecision
OOS rate, HPLC-074 of 5 site events in the quarter, all on one instrumentInstrument-level pattern regardless of cause category mix
Repeat-cause rate, integration3 of 4 HPLC-07 events, all coded “integration,” all involving J. DoeAnalyst and instrument both implicated; not a coincidence at this concentration
Lab-error fraction4 of 5 events (80 percent) closed at Phase 1High fraction; investigate whether the laboratory practice itself, not the product, is generating events

Decision: the repeat integration-cause events on HPLC-07, concentrated with one analyst, triggered a targeted review rather than three separate closed CAPAs treated as unrelated. The review found the CDS default integration parameters on HPLC-07 had drifted from the method’s validated settings after a software update, and J. Doe had not been retrained on manual integration justification since the update. Corrective action: reset and lock the default integration parameters on HPLC-07 against the validated method, verify the same setting on every instrument the update touched, and retrain all analysts using that CDS on manual integration justification, not just the one analyst whose name appeared most often.

This is what the register is for: three individually closed, individually correct OOS investigations, each with a valid documented laboratory cause, still added up to one unaddressed system problem until they were counted against the same instrument and cause category together.

Common inspection findings this register prevents

  • Individually well-documented OOS investigations that never get compared to each other, so a repeat instrument or analyst pattern goes unnoticed.
  • An OOS rate tracked only in aggregate, hiding that the events are concentrated in one method, one instrument, or one analyst.
  • CAPAs closed as isolated laboratory-error fixes when the same root cause recurred across multiple events.
  • A high lab-error (Phase 1 closure) fraction with no review of whether the laboratory practice, not the product, is the actual signal.
  • A trending review that runs every period but never changes a decision, signalling the review is procedural rather than real.

How to adapt this register

  1. Set your controlled cause-category lists in Part 1 so the fields stay queryable and match the categories your OOS SOP already defines.
  2. Calibrate the thresholds in Part 2 to your testing volume; a low-volume specialty method needs a different trigger than a high-throughput release assay.
  3. Reconcile the overall OOS rate and lab-error fraction with the same figures reported in your quality metrics program so the two never diverge.
  4. Feed confirmed outliers into instrument requalification, analyst training, or method review as the finding warrants, and track the resulting action to closure in the next period’s review.
Use madhadi.com as an app Full screen, works offline, one tap from your home screen.