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 22, 2019

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.

Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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