Skip to main content
Question

How to import combination values for sales rule combination using DMM

  • January 28, 2026
  • 2 replies
  • 21 views

Forum|alt.badge.img+1

Hi everyone, 
I am trying to import CONFIG_SALES_COMB_VALUES table into IFS via DMM. The table has SEQUENCE_NO column which is used to order different combination values. Records are ORDER BY SEQUENCE_NO ASC and they are imported from smallest to largest sequence. 

 

So, I would expect to see 8 records, and they should be displayed in correct order. However, only 6 records are displayed in IFS in different orders. 

 

Please help!

2 replies

Forum|alt.badge.img+1
  • Author
  • Do Gooder (Customer)
  • January 29, 2026

One possible issue is the Target key 3 - COMBINATION_VALUE_ID. It does not map correctly to the COMBINATION_VALUE_ID.
 


Anyone knows how to change this mapping?


Forum|alt.badge.img+1
  • Author
  • Do Gooder (Customer)
  • January 29, 2026

I found the issue. Target key 3 - COMBINATION_VALUE_ID is assigned when you import it and just stays that way even if correctly imported later on. 
What must be done is using a new set of legacy loads that has not been migrated yet and migrate them in correct order in the 1ST TIME. Target key 3 - COMBINATION_VALUE_ID then is assigned correctly.