Form Personalization in Procurement

Hello all and happy new year,

I'm trying to have a SUM DFF in the PO Header, that will "feed" from the Quantity field in the lines area.

I created a DFF, and made the following form-personalization:

WHEN-VALIDATE-RECORD

PO_LINES

Processing Mode: Both

Property

Item

PO_HEADERS.ATTRIBUTE1

VALUE

=(SELECT SUM(pla.quantity_committed)

FROM po_headers_all pha,

     po_lines_all pla

WHERE 1=1

AND pha.po_header_id = pla.po_header_id

AND pha.org_id = 81

AND pha.po_header_id = ''||${item.PO_LINES.PO_HEADER_ID.value}||''

GROUP BY pha.po_header_id)

It works fine when I try to Validate it, but I want the header level DFF (aka ATTRIBUTE1) to be