1月27日---新增资产保存后，又修改了启用日期，导致Ytd折旧出现负数

与用户沟通后了解到该资产增加后没有运行过创建会计科目，解决方案是及时删除Fa模块所有该资产的数据，重建资产。

---删除错误资产----------------------------------------------------------------------------------------------------------------
create table bak.FA_ASSET_HISTORY160128 as
/*select **/ delete from FA_ASSET_HISTORY  where ASSET_ID ='125124';


create table bak.FA_BOOKS160128 as
/*select **/ delete from FA_BOOKS where ASSET_ID ='125124';


create table bak.FA_ADDITIONS_B160128 as
/*select **/ delete from FA_ADDITIONS_B where ASSET_ID    ='125124'   ;


create table bak.FA_ADDITIONS_TL160128 as
/*select **/ delete from FA_ADDITIONS_TL where ASSET_ID  ='125124' ;


create table bak.FA_DEPRN_SUMMARY160128 as
/*select **/ delete from FA_DEPRN_SUMMARY where  ASSET_ID  ='125124' ;


create table bak.FA_DISTRIBUTION_HISTORY160128 as
/*select **/ delete from FA_DISTRIBUTION_HISTORY FDH where ASSET_ID  ='125124' ;


create table bak.FA_ASSET_INVOICES160128 as
/*select **/ delete from FA_ASSET_INVOICES where ASSET_ID  ='125124' ;






create table bak.xla_events160128 as
/*select **/ delete from xla_events
 where EVENT_ID in (select EVENT_ID
                       from FA_TRANSACTION_HEADERS where ASSET_ID    ='125124' );
                       


create table bak.FA_TRANSACTION_HEADERS160128 as
/*select **/ delete from FA_TRANSACTION_HEADERS where ASSET_ID    ='125124'; -- 事物处理                       
-------------------------------------------------------------------------------------------------------------     


create table bak.xla_transaction_entities160128 as
/*select **/ delete from xla_transaction_entities where transaction_number in('1703195','1703196','1703204','1703205','1703206');--对应上面TRANSACTION_HEADER_ID_IN








select * from bak.FA_TRANSACTION_HEADERS160128