My Oracle Support Banner

ITEM_LOC.RECEIVE_AS_TYPE is Populated as 'E' but Expected Null for Store Location (Doc ID 2987535.1)

Last updated on NOVEMBER 16, 2023

Applies to:

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


 ITEM_LOC.RECEIVE_AS_TYPE This column determines whether the stock on hand for a pack component item or the pack itself will be updated when a pack is received at a warehouse. Valid values are Each (E) or Pack (P). This value is required for all pack items where the location type is Warehouse (W). For vendor packs, this must be set to Pack (P), for buyer packs it can be either Each (E) or Pack (P). Will be filled with P for stores too.

Steps to Reproduce:

  1. On RMFCS pick up a valid SKU Item that has range with Stores.
  2. Go to More Actions > Simple Pack > Setup and add create a pack.
  3. Fill in the required fields and press OK.
  4. Press Create Packs button and Save all.
  5. Check the ITEM_LOC data for that new Simple Pack and notice that RECEIVE_AS_TYPE field is filled for Stores, when it is only used for Warehouse.




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.