My Oracle Support Banner

Cancelled Or Consumed IBLPN Results In Error "duplicate key value violates unique constraint "plt_ukey"" (Doc ID 2399441.1)

Last updated on JANUARY 23, 2023

Applies to:

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

Symptoms

Using RF Device, IBLPN Creation does not work for an IBLPN already cancelled or consumed
Module: RF-Text: Create {lpn}
Screen: RF_Create IBLPN
Issue: When we try to create the IBLPN with one LPN in consumed or cancelled status system show an error message and after ejects user of the system.

ERROR
-----------------------
duplicate key value violates unique constraint "plt_ukey" DETAIL: Key (facility_company_xref_id,pallet_nbr)=(123, PLTXXXXXX) already exists.

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.