Duplicate Serial Number Error in editSerialStatusAndUsageByList Web Service for Verified Not Counterfeit Serial (Doc ID 2025847.1)

Last updated on MAY 12, 2016

Applies to:

Oracle Pedigree and Serialization Manager - Version 2.0.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On Oracle Pedigree and Serialization Management (OPSM) 2.0.0.0.0 version, Web Services

When the editSerialStatusAndUsageByList Web Service is sent to commission serials, the following error is raised if same serial number exists for same product in spite of the serial number being marked as Verified Not Counterfeit.
A custom serial type is used. Serial Uniqueness is based on Product code + Serial Number combination.

ERROR
Duplicate serial numbers were found in the system for item serial number XXX. Please remove this serial number from the request and resend.

EXPECTED BEHAVIOR
Expect no error because the serial is marked as Verified Not Counterfeit.

STEPS
1. Get two serials at Reserved Serial Status for same product with same value for the Serial Number:
1) Counterfeit Status=Verified Not Counterfeit
2) Counterfeit Status=Counterfeit
2. Send an XML message to editSerialStatusAndUsageByList Web Service with SerialStatus=COMMISSIONED
3. See it fails
4. In OPSM, go to Transactions > Maintain Transactions
5. Query the transaction
6. See the following:
Transaction Type: Commission Serials
Error Message:
Duplicate serial numbers were found in the system for item serial number XXX. Please remove this serial number from the request and resend.

Changes

The problem can surface after upgrading to OPSM 2.0.0 

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