Duplicate MERCHANDISE_ID and LOCATION_ID in COLLECTION_MAPS_TBL (Doc ID 1960578.1)

Last updated on JUNE 05, 2016

Applies to:

Oracle Retail Markdown Optimization - Version 12.0.6 to 13.0.0 [Release 12.0 to 13.0]
Information in this document applies to any platform.

Symptoms

The batch failed and investigation revealed duplicates in COLLECTION_MAPS_TBL.  The same merchandise_id and location_id belongs to two different collection_id.

This condition may show up related to eligibility, trying to put the same item_id into ITEM_DATA twice due to the multiple collection_ids.

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