资产模块报废资产后，运行创建会计科目，会计程序黄色警告

资产模块报废资产后，运行创建会计科目，会计程序黄色警告。
经查，会计事件中有错误状态，资产XC.02.0065借贷不平，无法传至总账。


改子分类账xla_ae_lines，xla_distribution_links   贷项，然后改子分类账事件表：xla_events状态event_status_code为改成U，process_status_code改成  F
然后运行将日记账分录传送至总账-资产
再将状态改为P，P
完成。

SELECT *
  FROM FA_RETIREMENTS_V
 WHERE 'FULL RETIREMENT' = 'REINSTATEMENT'
   AND TRANSACTION_HEADER_ID_OUT = 1675190
UNION
SELECT *
  FROM FA_RETIREMENTS_V
 WHERE 'FULL RETIREMENT' != 'REINSTATEMENT'
   AND TRANSACTION_HEADER_ID_IN = 1675190
;


select * from xla_transaction_entities where transaction_number in('1679190','1679191','1679192','1679193','1679194','1679195','1679196');--对应上面TRANSACTION_HEADER_ID_IN


select * from  xla_events where entity_id = '74933993'for update;/* and event_id = '83657429'*/;


SELECT x.gl_transfer_status_code,x.gl_transfer_date,x.* FROM XLA_AE_HEADerS x where x.event_id = '83657429' for update;--66069587,66068587
/*create table bak.xla_ae_lines160121 as*/
select* from xla_ae_lines where ae_header_id = 66070587 for update;
/*create table bak.xla_distribution_links160121 as*/
select * from xla_distribution_links  where ae_header_id = 66070587  for update;


select * from gl_import_references where gl_sl_link_id in ('93196560','93196561','93196559')


select * from xla_entity_types_vl


select * from xla_entity_id_mappings


select * from xla_event_types_vl


 
select * from gl_import_references


where period_name = '2016-01'
select * from gl_je_batches where default_period_name = '2016-01'
 je_batch_id = '19684155'


SELECT * FROM APPS.FND_LOOKUP_VALUES WHERE LOOKUP_TYPE ='XLA_EVENT_PROCESS_STATUS' ;


SELECT * FROM APPS.FND_LOOKUP_VALUES WHERE LOOKUP_TYPE ='XLA_EVENT_STATUS' ;


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




select * from xla_transaction_entities where transaction_number = '1676190';--对应上面TRANSACTION_HEADER_ID_IN


select * from  xla_events where entity_id = '74958245'/* and event_id = '83657429'*/;


SELECT x.gl_transfer_status_code,x.gl_transfer_date,x.* FROM XLA_AE_HEADerS x where x.event_id = '83681681';
create table bak.xla_ae_lines160121 as
select* from xla_ae_lines where ae_header_id = 66068588 for update;
create table bak.xla_distribution_links160121 as
select * from xla_distribution_links  where ae_header_id = 66067587  for update;


select * from gl_import_references where gl_sl_link_id in ('93197563','93197564','93197562')

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

转载于:http://blog.itpub.net/30835162/viewspace-1986291/