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

Last updated on SEPTEMBER 07, 2016

Applies to:

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

Symptoms

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.

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