EBS关库存期间问题，待定事务处理

select /*count(organization_id)*/ 
       costed_flag,
       acct_period_id, ---*****该字段一定要注意确定是否正确，否则出错
       transaction_set_id,
       request_id,
       transaction_group_id,
       error_code,
       error_explanation,
       transaction_date
  from MTL_MATERIAL_TRANSACTIONS
  where costed_flag = 'E'
  --and organization_id=122
  /* group by organization_id */
   and to_char(transaction_date,'yyyy-mm-dd')>='2019-04-28'
   and to_char(transaction_date,'yyyy-mm-dd')<='2019-03-29';


Update MTL_MATERIAL_TRANSACTIONS
     set costed_flag = 'N',
          /*acct_period_id      = 919, -*/--*/ ---*****该字段一定要注意确定是否正确，否则出错
         transaction_set_id   = NULL,
         request_id           = null,
         transaction_group_id = null,
         error_code           = null,
         error_explanation    = null
         /*  cost_update_id       = null, ----×****再确认该字段是否需要null*/
   where 
   organization_id = 122
     and costed_flag = 'E'
     and to_char(transaction_date,'yyyy-mm-dd')<='2019-04-28'
     and to_char(transaction_date,'yyyy-mm-dd')>='2019-03-29';