Duplicate MERCHANDISE_ID and LOCATION_ID in COLLECTION_MAPS_TBL
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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms