oracle ogg formatascci字段出现null问题

formatascii字段出现null值问题
update 操作其他字段出现null值操作

B|2017-04-19:08:15:37.000000|1492560937|49084|
D|A|test.test_bill|DANJ_NO|KPP00000000003|RIQI_DATE|NULL|YEZ_ID|NULL|DANW_ID|NULL|CAIGOU_STAFF|NULL|CAOZ_STAFF|NULL|ZHIJ_STAFF|NULL|SHOUH_STAFF|NULL|SHANGJ_DANJ_NO|NULL|CAIGDDJ_NO|NULL|YEW_TYPE|NULL|RUK_TYPE|NULL|HUIC_FLG|NULL|DANJXC_SIDE|NULL|YEWDJ_NO|NULL|HANGHAO|NULL|SHANGP_ID|NULL|LOT|NULL|SHENGCHAN_DATE|NULL|YOUX_DATE|NULL|NUM|NULL|YANS_RLT|NULL|PRICE|NULL|AMOUNT|NULL|HANGH_CGD|NULL|DHPZ_FLG|NULL|DAOH_WAY|NULL|PIHAO_MIEJ|NULL|TRANSPORT_TOOL|NULL|LCP_TPRT|NULL|
I|A|test.test_bill|DANJ_NO|KPP00000000002|RIQI_DATE|NULL|YEZ_ID|NULL|DANW_ID|NULL|CAIGOU_STAFF|NULL|CAOZ_STAFF|NULL|ZHIJ_STAFF|NULL|SHOUH_STAFF|NULL|SHANGJ_DANJ_NO|NULL|CAIGDDJ_NO|NULL|YEW_TYPE|NULL|RUK_TYPE|NULL|HUIC_FLG|NULL|DANJXC_SIDE|NULL|YEWDJ_NO|NULL|HANGHAO|NULL|SHANGP_ID|NULL|LOT|NULL|SHENGCHAN_DATE|NULL|YOUX_DATE|NULL|NUM|NULL|YANS_RLT|NULL|PRICE|NULL|AMOUNT|NULL|HANGH_CGD|NULL|DHPZ_FLG|NULL|DAOH_WAY|NULL|PIHAO_MIEJ|NULL|TRANSPORT_TOOL|NULL|LCP_TPRT|NULL|
C|

extract配置文件如下:
extract e1
dynamicresolution
SETENV(ORACLE_SID=test)
userid ggs,password ggs
FORMATASCII ,DELIMITER '|',  ,NAMES,OP,NOQUOTE
exttrail C:\Ogg\dirdat\e1
table test.test_bill,keycols(danj_no,riqi_date,yez_id,danw_id,caigou_staff,caoz_staff,zhij_staff,shouh_staff,shangj_danj_no,caigddj_no,yew_type,ruk_type,huic_flg,danjxc_side,yewdj_no,hanghao,shangp_id,lot,shengchan_date,youx_date,num,yans_rlt,price,amount,hangh_cgd,dhpz_flg,daoh_way,pihao_miej,transport_tool,lcp_tprt) ;

在数据库中运行下面一句：
 alter table  test.test_bill add supplemental log data(all) columns;


C:\Ogg\dirdat\e1的文件内容如下:
B|2017-04-19:08:35:14.000000|1492562114|49085|
D|A|test.test_bill|DANJ_NO|KPP00000000003|RIQI_DATE|2014-09-02:16:10:02|YEZ_ID|DWI32461605|DANW_ID|DWI32467934|CAIGOU_STAFF|1|CAOZ_STAFF|1|ZHIJ_STAFF|1|SHOUH_STAFF|1|SHANGJ_DANJ_NO|JHF00364863|CAIGDDJ_NO|JHF00364863|YEW_TYPE|1|RUK_TYPE|1|HUIC_FLG|Y|DANJXC_SIDE|0|YEWDJ_NO|JHF00364863|HANGHAO|2|SHANGP_ID|SPH00067755|LOT|1406205|SHENGCHAN_DATE|2014-06-28:00:00:00|YOUX_DATE|2015-11-30:00:00:00|NUM|1500.00|YANS_RLT|9|PRICE|128.44000|AMOUNT|192660|HANGH_CGD|1|DHPZ_FLG|1|DAOH_WAY|NULL|PIHAO_MIEJ|NULL|TRANSPORT_TOOL|NULL|LCP_TPRT|NULL|
I|A|test.test_bill|DANJ_NO|KPP00000000003|RIQI_DATE|2014-09-02:16:10:02|YEZ_ID|11|DANW_ID|DWI32467934|CAIGOU_STAFF|1|CAOZ_STAFF|1|ZHIJ_STAFF|1|SHOUH_STAFF|1|SHANGJ_DANJ_NO|JHF00364863|CAIGDDJ_NO|JHF00364863|YEW_TYPE|1|RUK_TYPE|1|HUIC_FLG|Y|DANJXC_SIDE|0|YEWDJ_NO|JHF00364863|HANGHAO|2|SHANGP_ID|SPH00067755|LOT|1406205|SHENGCHAN_DATE|2014-06-28:00:00:00|YOUX_DATE|2015-11-30:00:00:00|NUM|1500.00|YANS_RLT|9|PRICE|128.44000|AMOUNT|192660|HANGH_CGD|1|DHPZ_FLG|1|DAOH_WAY|NULL|PIHAO_MIEJ|NULL|TRANSPORT_TOOL|NULL|LCP_TPRT|NULL|
C|


另一种操作也能达到效果，在ggsci中：
dblogin userid ggs,password ggs
add trandata test.test_bill allcols


说明：需要添加keycols，并且keycols中添加所有字段，才能在文件中显示update操作的前后内容，否则如下显示：
B|2017-04-19:08:59:54.000000|1492563594|49086|
V|A|test.test_bill|DANJ_NO|KPP00000000003|RIQI_DATE|2014-09-02:16:10:02|YEZ_ID|DWI32461605|DANW_ID|DWI32467934|CAIGOU_STAFF|1|CAOZ_STAFF|1|ZHIJ_STAFF|1|SHOUH_STAFF|1|SHANGJ_DANJ_NO|JHF00364863|CAIGDDJ_NO|JHF00364863|YEW_TYPE|1|RUK_TYPE|1|HUIC_FLG|Y|DANJXC_SIDE|0|YEWDJ_NO|JHF00364863|HANGHAO|2|SHANGP_ID|SPH00067755|LOT|1406205|SHENGCHAN_DATE|2014-06-28:00:00:00|YOUX_DATE|2015-11-30:00:00:00|NUM|1500.00|YANS_RLT|9|PRICE|128.44000|AMOUNT|192660|HANGH_CGD|1|DHPZ_FLG|1|DAOH_WAY|NULL|PIHAO_MIEJ|NULL|TRANSPORT_TOOL|NULL|LCP_TPRT|NULL|
C|