My Oracle Support Banner

ASN From PO_HEADER Throwing Error 'Duplicate Key Value Violates Unique Constraint...' (Doc ID 2522079.1)

Last updated on OCTOBER 30, 2019

Applies to:

Oracle Warehouse Management Enterprise Edition Cloud Service - Version 8.0.0 and later
Information in this document applies to any platform.

Symptoms

On : NA version, Core Product Functionality

When attempting to create ASN from PO_header getting an error.

ERROR
-----------------------
Duplicate key value violates unique constraint id_key(Facility_id, company_id,load_nbr) (3,199,L100000019) already exists.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Create a PO
2. Create PO details (i.e. add Item and PO Order Qty)
3. After creating PO, try to create Ib_Shipment from PO Header

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
Cause
Solution


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