My Oracle Support Banner

WMS_LPN_CONTENTS_LOT_V View Is Not Considering UOM (Doc ID 2436980.1)

Last updated on AUGUST 19, 2018

Applies to:

Oracle Warehouse Management - Version 12.1.3 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

Actual Behavior
WMS_LPN_CONTENTS_LOT_V view is not considering UOM and summing up all the content LPN quantities for the LPN.

Expected Behavior
WMS_LPN_CONTENTS_LOT_V view should consider UOM.

Steps to Reproduce

  1. Create Lot controlled Item with Primary UOM: Each
  2. Perform Misc Receipt 1 Each into Lot, LPN
  3. Perform Misc Receipt 1 Bag (1 Bag = 10 Each) into the same Lot and LPN
  4. select * from WMS_LPN_CONTENTS where PARENT_LPN_ID = &lpn_id;
    See two records: one record with 1 Ea and the other record with 1 BG.
  5. select * from WMS_LPN_CONTENTS_LOT_V where PARENT_LPN_ID = &lpn_id;
    See one record with 2 Ea

 

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!


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