现在deprn_status字段是R，运行折旧的时候报错



原因是之前运行过折旧，但是因为什么原因没有跑完，且有问题，已查不到原来折旧请求的日志，只能改fa_book_controls表的deprn_status 状态 ,
改完后再次运行折旧，正常完成。


update fa_book_controls
 set deprn_request_id = NULL,
  mass_request_id = NULL,
  deprn_status = 'E'
  where deprn_status = 'R'
  and book_type_code='****_FA_BOOK';


---------------------------------------------------------


--create table  bak.fa_book_controls151221 as
select/* f.enabled_flag,*/f.book_type_code, f.deprn_request_id, f.mass_request_id, f.deprn_status,f.*
 from fa_book_controls f
where book_type_code = '****_FA_BOOK'/* for update*/;



select fd.period_counter,fd.*
 from fa_deprn_periods fd
where book_type_code = '****_FA_BOOK'
and period_close_date is null;








select *
 from fa_deprn_summary
where book_type_code = '****_FA_BOOK'
and period_counter =24192
 and deprn_amount is not null;


 select *
from fa_deprn_detail
 where book_type_code = '****_FA_BOOK'
and period_counter =24192
and deprn_amount is not null;




update fa_book_controls
SQL> set deprn_request_id = NULL, 
SQL> deprn_status = 'E'
SQL> where deprn_status = 'S'
SQL> and book_type_code = '&book_type_code';