Skip to main content
Question

Error while executing transformation OCPM

  • August 22, 2024
  • 1 reply
  • 42 views

raman.silot11
Level 3
Forum|alt.badge.img+1

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

1 reply

Forum|alt.badge.img+8

Hi Raman,

 

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