Promotion Import Deletes And Recreates Records In S_PROM_ITEM
(Doc ID 2154655.1)
Last updated on NOVEMBER 18, 2020
Applies to:
Siebel CRM - Version 15.10 [IP2015] and laterInformation in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |