Form Personalization Triggers Multiple times for PO_LINES.UNIT_PRICE (POXPOEPO)

Hello,

Using Form Personalization we are trying to change the PO_LINES.UNIT_PRICE as PO_LINES.UNIT_PRICE/0.68 whenever PO_HEADERS.ATTRIBUTE2 = 'Yes'.

The form personalization should update the unit_price only once. but when we clear the second line the first line price getting increased.

The Trigger Event used is "WHEN-NEW-RECORD-INSTANCE".

Trigger Object is "PO_LINES"

Condition ":PO_HEADERS.ATTRIBUTE2 = 'Yes'"

Processing Mode Not in Enter-Query Mode

Actions:

Seq - 1

Type - Property

Object Type - Item

Target Object - PO_LINES.UNIT_PRICE

Property Name - VALUE

Value - = select TO_CHAR(${item.PO_LINES.UNIT_PRICE.VALUE}/0.68) from dual