How to use != in a Constraint when using Linked Items? (Doc ID 1449037.1)

Customer wanted to create a constraint which requires a child product depending on a header field.

It should work similar for Quote Header or Order Header. and hence decided to add 2 linked items.

These linked items take the current context and so have Needs Excution Flag not set.

So consider following two linked items without default values:

1. Account Type Order which refers to field Account Type of bc Order Entry - Orders of bo Order Entry (Sales).
2. Account Type Quote which refers to field Account Type of bc Quote of bo Quote.

and a constraint like:

When(Account Type Order != Residential OR Account Type Quote != Residential) excludes selection of WLAN from Connections)

The intention is to exlude WLAN for customers which are no Residentials and it should work in Quotes and Orders.

But the problem is that if you are working from Quotes linked item Account Type Order has not value and vice versa.

So you have a comparison against NULL. And what will be the result here?

Tests showed that it evalueates to true, but this is not documented and hence should not be relied on.

Solution

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