My Oracle Support Banner

Repl_Item_Loc Populating With Incorrect Inner_Pack_Size And Supp_Pack_Size (Doc ID 2512662.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 16.0 and later
Information in this document applies to any platform.

Goal

Repl_Item_Loc table is being populated with the incorrect inner_pack_size and supp_pack_size.
Expected results would be that these fields be populated from the primary supplier associated with the item_loc from the Item_supp_country table.
This behavior appears to be on items with multiple suppliers (only one primary) that have been modified recently.

Example:
Item has 2 Suppliers
SUPP_A --> Primary INNER_SIZE 10
SUPP_B INNER_SIZE 15

Ranged to 2 locations
WH_A with primary supplier SUPP_A
ST_A with primary supplier SUPP_B

Replenishment set up as WH Stocked from WH_A to ST_A
REPL_ITEM_LOC has INNER_PACK_SIZE as 10, although the primary supplier for ST_A is 15
 

Solution

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


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