Hi,
Thanks for replying.
This solution is not working, I guess it's not reading values from fields because they are read-only set to always and are both of AutoNumeric(plug-in) type. I have the below code written in the process as per your instructions.

declare
e_error exception;
l_num number;
begin
l_num := to_number(:P1_ASSET,'99,999,999,999') - to_number(:P1_LIABILITIES,'99,999,999,999');
if l_num=0 then
raise e_error;
end if;
end;

I'm converting it to number as I have it displayed on screen in the format of currency like 100,000

Thank you for your quick response and providing alternative.

But I do have a question is the solution possible that it validates only when we click submit as I’m having 2 other different buttons and this is checking every time as it has lose focus. I only want to check it when user clicks submit button and not check if other 2 buttons clicked.

Thanks!

I'm really sorry to confuse you all here.

Actually all those true actions with different where condition is setting different values.
I'm having 40 items
- 2 dynamic actions(taking 2 inputs(5/11/21,previous), 4+4 true actions): Setting 40 items, and all 8 true actions have different affected elements(items) from 40
- 2 dynamic actions(taking 2 inputs(5/11/21,next), 4+4 true actions): Setting the same 40 items, and all 8 true actions have different affected elements(items) from 40

So, I can only say it is setting the same 40 items only when input changes between 'previous' and 'next', also when I say different where condition that means I'm comparing input date different year like
to_char(f.statement_dt, 'yyyymm') = to_char(add_months(:P10_START_DATE,-24), 'yyyymm')

I hope I'm making clear point. Again sorry for the confusion.
Thanks!