My Oracle Support Banner

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

Last updated on FEBRUARY 04, 2019

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.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.