Skip to main content

Hello,

 

This is regarding the error I am getting when I add object relation transformation where relationship is m:n.

 

Not sure what exactly I am missing here.

 

Below is the error.

 

Error while executing transformation transformation_ENTITY_OBJECT_custom_PurchaseOrderHeader, with id f4583963-8785-4497-b862-e063abc0db63: ERROR: Cannot set a NOT NULL column (PurchaseOrderRequisition_ID) to a NULL value in INSERT/UPDATE statement

Hi Raman,

 

have you tried using the COALESCE Function? This function returns the first element that is not NULL.


Reply