FNDLOAD常用命令

FNDLOAD常用命令

FNDLOAD 用法

导出描述性弹性域时

可以使用下面SQL查询DESCRIPTIVE_FLEXFIELD_NAME

SELECT fnd_dfv.title
      ,fnd_dfv.descriptive_flexfield_name
      ,fnd_dfv.application_table_name
      ,fnd_dfu.descriptive_flex_context_code
      ,fnd_dfu.application_column_name
      ,fnd_dfu.form_left_prompt
      ,fnd_dfu.form_above_prompt
  FROM fnd_descriptive_flexs_vl    fnd_dfv
      ,fnd_descr_flex_col_usage_vl fnd_dfu
 WHERE fnd_dfu.descriptive_flexfield_name =
       fnd_dfv.descriptive_flexfield_name
   AND fnd_dfv.title = 'XYG_ITEM_TP_FLEX';

SELECT integrator_code, fa.application_short_name
  FROM bne_interfaces_vl intc, fnd_application fa
 WHERE intc.integrator_app_id = fa.application_id
   AND user_name = '&Interface_Name';
-- CUX_AP_INVOICE_UPLOAD_ADI_INT

 FNDLOAD apps/xxx0 Y DOWNLOAD $BNE_TOP/patch/115/import/bneintegrator.lct INVOICE_WEBADI_INTG.ldt BNE_INTEGRATORS INTEGRATOR_ASN=SQLAP INTEGRATOR_CODE=CUX_AP_INVOICE_UPLOAD_XINTG

FNDLOAD apps/xxx0 Y DOWNLOAD $BNE_TOP/patch/115/import/bnelay.lct INVOICE_WEBADI_LOY.ldt BNE_LAYOUTS LAYOUT_ASN="SQLAP" LAYOUT_CODE="CUX_AP_INVOICE_UPLOAD_LOY"