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.


On : NA version, Core Product Functionality

When attempting to create ASN from PO_header getting an error.

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

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


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

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