My Oracle Support Banner

Salesprocess.ksh Updates ITEM_LOC_HIST.RETAIL as Null for Non-pack Items (Doc ID 2179118.1)

Last updated on FEBRUARY 09, 2018

Applies to:

Oracle Retail Merchandising System - Version 14.1 and later
Information in this document applies to any platform.


When salesprocess.ksh processes records for non-packs, RMS13.CORESVC_SALES_UPLOAD_PRST_SQL.PERSIST_ITEM_LOC_HIST updates the ITEM_LOC_HIST table with a NULL value for Retail.

Steps to Reproduce:

  1. Process the sales into RMS.
  2. Check ITEM_LOC_HIST record for the same item-loc.
  3. Retail column will be null.


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.