Oracle Fusion Quality: Sampling Challenge for WIP Inspections

Pramod — Sun, 27 Sep 2026 18:28:09 +0000

Setting a tight AQL on a small batch in Oracle Fusion Quality may result in a situation where the inspection screen returns numbers that look broken. Below is a situation I encountered recently and fixed:

The problem

In-line WIP inspection configured in this manner:

ANSI/ASQC Z1.4
Single sampling plan, normal inspection
General Inspection Level II
AQL of 0.01

A process manufacturing work order for a 10 KG batch. The inspection triggers at the operation and shows:

Accepted:  1,250
Pending:  -1,240

A negative pending quantity. It looks like a calculation error, so it usually goes straight into a support ticket.

The fix

Two options. Pick based on what the business actually needs.

Raise the AQL to something the batch size can support.** A ten unit batch can only demonstrate a quality level that a sample of ten or fewer can prove. That means a much looser AQL than 0.01.
Drop AQL sampling for small batches.** Use fixed count or percentage sampling instead. If you want all ten units inspected, configure a 100 percent plan and say so directly.

Root cause

Sample size does not scale down with batch size the way people expect.

Under Z1.4, the lot size and inspection level give you a sample size code letter. The code letter gives you a sample size. You then read across to your AQL column for the accept and reject numbers.

The catch is what happens when the AQL is too tight for that sample to prove anything. A sample of 315 units cannot demonstrate a defect rate of one in ten thousand. There is no acceptance number that separates a good lot from a bad one at that level.

Z1.4 handles this with an arrow in the table. Instead of accept and reject numbers, it sends you down to the first plan that can discriminate at your AQL, and you use that plan's sample size. At AQL 0.010 on single sampling normal inspection, that plan is 1,250 samples with accept 0, reject 1.

That is where 1,250 comes from. Fusion is reading the standard correctly.

The second number then follows:

batch quantity  -  required sample  =  pending
      10        -       1,250       =   -1,240

The batch made 10 units. The plan wants 1,250 inspected. Pending is the shortfall, negative because the requirement is larger than the entire lot.

So the real answer is that an AQL of 0.01 is not achievable on a batch of ten. No sampling scheme can prove that quality level from a population that small. The screen is showing you a statistical impossibility, not a bug.

Additional tips

Before you commit to an AQL, work out the sample size it implies and compare it against your normal lot size. If the sample is bigger than the lot, the plan will never run.

Watch out for AQLs chosen because they sound rigorous. 0.01 reads well in a quality plan and almost nobody checks whether it is attainable at their batch sizes.

The same symptom appears any time the required sample exceeds the lot, not just at 0.01. If you see a negative pending quantity, check the sampling plan against lot size first.

If your tests are destructive or expensive, look at special inspection levels S-1 through S-4. They produce much smaller samples than the general levels and are designed for exactly that situation.

Z1.4 exists to avoid inspecting everything when lots are large. On a ten unit batch there is nothing to save, so the whole mechanism works against you. Small batch process manufacturing and acceptance sampling are an awkward pairing, and it is worth deciding early which of your products should use sampling at all.

DEV Community: Pramod

Oracle Fusion Quality: Sampling Challenge for WIP Inspections

The problem

The fix

Root cause

Additional tips