Table type value set not working properly.

Summary:

Hi Team,

We are facing an issue with a Person EIT of Table Type value set to auto-calculate fields.

The addition of fields is happening correctly. However, when the same field is given a formula (Proposed Salary - Fixed Salary) / Proposed Salary * 100, it does not work consistently.

The field works sometimes, but it stops working suddenly.

Below is the query

FROM Clause - (SELECT TO_NUMBER(LEVEL) - 1 n FROM DUAL CONNECT BY LEVEL <= 1000000) n

 

Value Column Name - n.n

ID Column Name - n.n

 

WHERE Clause - n.n = (
    SELECT 
        ROUND((((TO_NUMBER(:{SEGMENT.Basic Salary}) - TO_NUMBER(:{SEGMENT.HRA}))