FORMS进阶之——配置文件控制单号生成规则

1.新建order_number序列 CREATE SEQUENCE cux.cux_om_order_number_11733_s START WITH 1000000016; CREATE SYNONYM apps.cux_om_order_number_11733_s for cux.cux_om_order_number_s; 2.新建配置文件： 应用开发员->配置文件:CUX_OM_ORDER_NUM_TYPE_ 11733  (CUX 11733 :订单编号生成规则) 2、修改触发器'WHEN-NEW-FORM-INSTANCE'   ------------------------------------------------ 在CUXOMWKS11733 (程序包主体)中添加 IF fnd_profile.value('CUX_OM_ORDER_NUM_TYPE_11733') = 'AUTOMATIC' THEN set_item_property('HEADERS.ORDER_NUMBER', update_allowed, property_false); set_item_property('HEADERS.ORDER_NUMBER', insert_allowed, property_false); ELSE set_item_property('HEADERS.ORDER_NUMBER', update_allowed, property_true); set_item_property('HEADERS.ORDER_NUMBER', insert_allowed, property_true); END IF; 3.在HEADERS中添加触发器：'PRE-INSERT' 在HEADERS包体中添加 IF fnd_profile.value('CUX_OM_ORDER_NUM_TYPE_11733') = 'AUTOMATIC' THEN SELECT cux_om_order_number_11733_s.nextval INTO :headers.order_number FROM DUAL; END IF; 查看配置文件中订单号是自动还是手动生成 帮助--诊断--检查--块（$PROFILES$）--选择自己的字段