Reclassification Changes for a Item Are Not Getting Reflected in POS_MERCH_CRITERIA Table

(Doc ID 2119095.1)

Last updated on MARCH 22, 2016

Applies to:

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


Reclassification changes for a item are not getting reflected in the POS_MERCH_CRITERIA table.

Steps to Reproduce:

  1. Create a product restriction to an item with Minimum Age.
  2. Add location and item.
  3. Save the product restriction.
  4. Execute batch_orpos_extract.ksh, posdnld_post, and poscdnld_post (prepost.pc).
  5. Reclassify the item to a different department.
  6. Execute reclsdly.
  7. Execute batch_orpos_extract.ksh.
  8. Notice that POS_MERCH_CRITERIA table does not reflect the latest merchandise hierarchy.


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