Oracle eBS經驗分享

Write assign item sql at POST-QUERY trigger( block level).

<example>

select name
into  :CHARGE_SET.FREIGHT_COST_TYPE-- (Non-DB item)
from wsh_freight_cost_types_v
where FREIGHT_COST_TYPE_ID=:CHARGE_SET.FREIGHT_COST_TYPE_ID;

After the assignment sql, we need to change the valiation property to flase.

POST-QUERY trigger( block level).

set_item_property('CHARGE_SET.FREIGHT_COST_TYPE',VALIDATE_FROM_LIST, property_false);

WHEN-NEW-RECORD-INSTANCE(Block Level)

set_item_property('CHARGE_SET.FREIGHT_COST_TYPE',VALIDATE_FROM_LIST, property_true);

Or you will get save message after each execute_query.