STORE_ADD Updates LIKE_STORE, COPY_REPL_IND, COPY_ACTIVITY_IND, COPY_CLEARANCE_IND Columns Incorrectly (Doc ID 1948673.1)

Last updated on APRIL 06, 2017

Applies to:

Oracle Retail Merchandising System - Version 13.2.4 to 13.2.9 [Release 13.2]
Information in this document applies to any platform.

Symptoms

When more than one record is added to STORE_ADD table through store.fmb, the columns  LIKE_STORE, COPY_REPL_IND, COPY_ACTIVITY_IND, COPY_CLEARANCE_IND are updated with the values of the last updated store.


Steps to Reproduce:

Create 2 stores from store.fmb repeating the following 2 times:

  1. Enter store details in the main page
  2. Click Zoning Locs and enter values
  3. Click Address and enter values
  4. Click Like Store and enter values
  5. Click OK to complete store creation
  6. Note that both rows for the 2 stores in STORE_ADD has the values entered pertaining to the second store (columns LIKE_STORE, COPY_REPL_IND, COPY_ACTIVITY_IND, COPY_CLEARANCE_IND)

Changes

 

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