ITPub博客

首页 > 数据库 > Oracle > 新增资产保存后,又修改了启用日期,导致Ytd折旧出现负数

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

原创 Oracle 作者:悲观的蘑菇 时间:2016-02-04 10:14:00 0 删除 编辑
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

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30835162/viewspace-1986279/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2016-02-02

  • 博文量
    6
  • 访问量
    19584