Rollback depreciation Fails

问题：

Depreciation for book XXXX has failed.  Please rerun depreciation.A mass transaction is pending for this book. Please complete it and try again. Failed to obtain lock on FA_BOOK_CONTROLS row for book XXXX.

 

检查步骤：

 

select book_type_code, deprn_status,mass_request_id ,deprn_request_id
from fa_book_controls
where book_type_code='&book'

 

发现deprn_status为'E',mass_request_id/deprn_request_id为非空

 

原因分析:

  在执行折旧时出错，故在撤消折旧时会报错/

 

 

措施：

 

  1>datafix;

 

   UPDATE FA_BOOK_CONTROLS

   SET deprn_status='E',

       deprn_request_id=NULL,

       mass_request_id=null

  WHERE book_type_code='&book';

 

  2>re-run depreciation;

 

结果：

  OK啦/

 

 

还有其它原因也会导致操作不成功;

 

1>如果折旧且日记帐在GL中已过帐后,这时rollback journal entries是会报错的(当然rollback depreciation也是不让执行的,会提示让你先执行rollback journal entries)