Problem facing in Persoanlization
Hi Experts.
we have EBS R12.1.3.
we are going to personlization to populate the Line Type with default value on sales order line in Order Management. but At the entry time it's giving an
error : ORA-00907 MISSING RIGHT PARENTHESIS.
Personalization steps are as follows:
TRIGGER EVENT : WHEN-VALIDATE-RECORD
TRIGGER OBJECT : LINE
CONDITION : :ORDER.ORDER_TYPE_ID IS NOT NULL AND :LINE.ORDERED_ITEM_ID IS NOT NULL AND :LINE.SHIP_FROM_ORG_ID IS NOT NULL
ACTION :
TYPE -- PROPERTY
OBJECT TYPE -- ITEM
TARGER OBJECT -- LINE.LINE_TYPE
PROPERTY NAME -- VALUE
VALUE --
=select XX_BENZLER_DEFAULT_LINE_TYPE('''||${item.ORDER.ORDER_TYPE_ID.value}||''',