I have the requirement that the BUSINESS_UNIT field needs to be updated in the Voucher tables(VCHR_LINE_STG), I'm writing SQL in SQL action in the application engine After the update statement, the results are returning the null values. The total process is not running. How can we handle null Values?
Will PeopleCode work for this scenario? If works which code will work for Null values
Table name: VCHR_LINE_STG, Field name: BUSINESS_UNIT.
Thanks