Cancelled Or Consumed IBLPN Results In Error "duplicate key value violates unique constraint "plt_ukey""

(Doc ID 2399441.1)

Last updated on MAY 22, 2018

Applies to:

Oracle Warehouse Management Enterprise Edition Cloud Service - Version 8.0.2 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.

Changes

 

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