E1:31: Cannot Delete Duplicate Serial Number (Doc ID 2308101.1)

Last updated on SEPTEMBER 15, 2017

Applies to:

JD Edwards EnterpriseOne Shop Floor Control - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

E1 9.1 / P31114 Work Order Completions
            F3105 Serial Number Associations

Cannot delete a Serial Number from the F3105 table in the following scenario.

When the same serial number is associated to two different work orders of the same parent item and a completion (P31114) is processed on the first work order, the completion on the second work order will fail (as expected) with error "Quantity Restriction Exceeded for Item".
Then, when trying to delete the 'duplicate' serial number from the second work order, error "Delete Not Possible - Quantities Exist" (error id 2309).
The first work order completion can be reversed (to remove "existing" quantity with the SN). However, the "Delete Not Possible - Quantities Exist" error still displays when trying again to delete the serial number from the second work order.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms