My Oracle Support Banner

IntegrityCheck Fails When Aggregate Product Line Is Not A Primary (Doc ID 2200332.1)

Last updated on FEBRUARY 06, 2019

Applies to:

Siebel Order Validation Engine - Version 16.0 [IP2016] and later
Information in this document applies to any platform.


On : 16.0 [IP2016] version, Order Management

IntegrityCheck fails when Aggregate Product Line is not a primary

Facing an issue with Integrity Check. Basically, it's preventing a Modify Quote over the Root Bundle Component in case the product belonging to the Bundle Aggregate is not having the Aggregate Product Line as Primary.

Here the steps to reproduce in vanilla via mockup products

Build a Promotion definition as below.
¦- T_PROD_1
¦- T_PROD_2
Aggregate Product Line: PL
¦- T_PROD_PL_1
¦- T_PROD_PL_2

Remark: in order to reproduce the issue PL must not be a primary Product Line for the products T_PROD_PL_1 and T_PROD_PL_2

Activate an Order as below, and turn into assets:

T_BUNDLE (add)
¦- ROOT (add)
¦- T_PROD_1 (add)
¦- T_PROD_PL_1 (add)

Then make a "Modify" Quote for the root Bundle component ROOT and change a child product:
¦- ROOT (-)
¦- T_PROD_1 (delete)
¦- T_PROD_2 (add)

Verify the Quote/Order, at this time the IntegrityCheck fails.

After some investigations, realized that the failure is only occurring when the product "T_PROD_PL_1" is not having "PL" as primary product line.

This represents a strong constrain because prevent Customer from using the same product in two (or more) different Aggregate Product Lines.


Integrity check should not fail in case non primary product product lines

The issue can be reproduced at will with the following steps:
1. Create two simple products(Example:- T_PROD_1,T_PROD_2)
2. Create one customizable Product with two child Products(Example : ROOT,child : T_PROD_1(Min : 0, Max : 100, Def : 1),T_PROD_2(Min : 0, Max : 100, Def : 0))
3. Create 2 Product lines(Example :- PL, PL1)
4. Create one more simple products(Example :-T_PROD_PL_1)
5. For this product : T_PROD_PL_1 add 2 product lines(PL, PL1) and Make PL1 as primary
6. Create Promotion (Example:- T_BUNDLE_PROM) with component Product(ROOT)
7. Click on aggregate View Tab and PL product line

Place Order with T_BUNDLE_PROM promotion and T_PROD_PL_1 product from aggregate class
Prepare assets
Place Modify order for ROOT
Delete T_PROD_1 and add T_PROD_2
Click on done button
Click on Verify button on order header and see the validation message or
click on Flag icon to see the validation message

Got the error message as follows.

Promotion 'T_BUNDLE_PROM' does not meet the following rules: Promotion
'T_BUNDLE_PROM' does not apply to 'T_PROD_PL_1'




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.