Why Is the Constraint CHK_REPL_ITEM_LOC_REPL_METHOD Different in REPL_ITEM_LOC and REPL_ATTR_UPDATE_HEAD Tables? (Doc ID 2102517.1)

Last updated on FEBRUARY 04, 2016

Applies to:

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

Goal

The constraint CHK_REPL_ITEM_LOC_REPL_METHOD is different in the REPL_ITEM_LOC and REPL_ATTR_UPDATE_HEAD tables, as described below:

  REPL_ITEM_LOC -> REPL_METHOD in ('C','M','F','T','D','TI','DI','SO'))
  REPL_ATTR_UPDATE_HEAD -> REPL_METHOD in ('C','M','F','D','DI','TI','SO','S','T','E')

What are the 'S' and 'E' replenishment methods, and why are these only present in REPL_ATTR_UPDATE_HEAD?
 

Solution

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