My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

Applies to:

Siebel CRM - Version 15.10 [IP2015] and later
Information 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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.