Skip to Main Content

Load amount values in ARCS as a result of Debit and credit

Hello All , I need to load amount value which will be result of Credit column -Debit column in Oracle ARCS cloud.
I have set the credit column as lookup table and debit column as Amount and set the mapping as AMOUNTX=TO_NUMBER(REPLACE(UD13, ',', ''))-AMOUNT.
I received the validation error as - File "<string>", line 1462, in updateTDATASEG_T_TDATASEGW
SQLException: java.sql.SQLException: ORA-01407: cannot update ("LOJHGCAERMV"."TDATASEG_T"."AMOUNTX") to NULL
Can anyone please guide me on this