DSU ON ALLOCATION_ORDER_RELEASE_D IS NOT WORKING

Summary:

I tried to update fee details on ALLOCATION_ORDER_RELEASE_D using the followong query but nothing is getting updated and no query exception UPDATE ALLOCATION_ORDER_RELEASE_D AORD
SET (ATTRIBUTE1, ATTRIBUTE17, ATTRIBUTE19,ATTRIBUTE_NUMBER1) = (
SELECT IL.ATTRIBUTE1, IL.ATTRIBUTE17, IL.ATTRIBUTE19,IL.ATTRIBUTE_NUMBER1 FROM INVOICE_LINEITEM IL WHERE IL.LINEITEM_SEQ_NO = AORD.LINEITEM_SEQ_NO AND IL.INVOICE_GID = AORD.INVOICE_GID
)
WHERE AORD.INVOICE_GID = $GID

we have the values on invoice line item ob attributes i also validated then i alos tried somthing hard code also like below that also not updating

UPDATE ALLOCATION_ORDER_RELEASE_D SET ATTRIBUTE1 ='TEST' WHERE INVOICE_GID ='DOMAIN.123'