My Oracle Support Banner

Why Does the Second Rule Not Execute When There Are 2 Expressions in the Rule? (Doc ID 3077684.1)

Last updated on MARCH 26, 2025

Applies to:

Oracle Retail Assortment & Item Planning Enterprise Edition Cloud Service - Version 23.2 and later
Oracle Retail Merchandise Financial Planning Enterprise Edition Cloud Service - Version 25.1 and later
Oracle Retail Assortment & Item Planning Fashion Soft Lines Cloud Service Plus - Version 23.1 and later
Oracle Retail Inventory Planning Optimization Cloud Service Advanced Edition - Version 25.1 and later
Oracle Retail Assortment Planning Cloud Service Advanced Edition - Version 25.1 and later
Information in this document applies to any platform.

Goal

Please clarity the calc behaviour, because it seems that the engine executes the second expression in the rule instead of the first one.

The double expression in the rule is the following:
MeasureA = if(!MeasureD, if(!MeasureC, 0, if( MeasureB.level ([CLND].[sesn]) != MeasureE && MeasureB.level ([CLND].[sesn]) != -1,if(MeasureB != -1, MeasureB, MeasureE), MeasureE)), 0)
MeasureB = if(MeasureF, if(!MeasureD, if(MeasureA != MeasureE, MeasureA, -1), -1), 0)

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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