Demantra Solutions - EBS (MOSC)

MOSC Banner

Demantra Update Lock Expression Not Working With Nested If Then Else

Hi All,

Below is my expression in update lock expression, but the condition is not honored by Demantra.

if(( If (  IsNull( WK38 Control) , 0, WK38 Control) = -2)  And  ( If (  IsNull( Lock Slotting) , 0, Lock Slotting)=1 )  And ( If (  IsNull( WK38) , -1, WK38)=0 ) ,1,0)=1

Problem that I am facing is if any of the 3 conditions holds true then Update Lock kicks in and stops the update in worksheet, but I want that only when all 3 of them are true then Update Lock should prevent the update and show the message. I have tried writing the statement by breaking it down to individual (mentioned below) If Then Else statements and joining them by AND logic but that does not work as well.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Demantra Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center