Promotion Import Deletes And Recreates Records In S_PROM_ITEM (Doc ID 2154655.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Symptoms

ACTUAL BEHAVIOR
---------------
Product Import Problem after applying PS11 (IP2015)

Every time the promotion is imported in a target environment , new records are created in S_PROM_ITEM table causing the ABO functionality to fail for existing Asset

STEPS

---------------

Set up 2 environment source and target.

In the Source create a promotion with below structure

1) Created Customizable product Root1/Root2 with below structure

Root1
|_Child1
|_Child2

Root2
|_Child3
|_Child4

2) Created Promotion "Prom" and added Root1, Root2 product

3) Export from source and import in target.

Execute the below query

select row_id,integration_id from siebel.s_prom_item where promotion_id ='1-1KJP'

Result :

Row_id Integration_id
1-26VJ 1-26VJ
1-26VK 1-26VK

4) Now import the promotion again

select row_id,integration_id from siebel.s_prom_item where promotion_id ='1-1KJP'

Result :

Row_id Integration_id
1-270R 1-270R
1-270S 1-270S

Every time the promotion is imported in target environment, it deletes the existing entry and creates a new one.

This is causing all ABO operations to fail

Cause