xla_events

 

LOOKUP_TYPE                          LANGUAGE  LOOKUP_CODE MEANING              DESCRIPTION 
XLA_EVENT_PROCESS_STATUS     US                 D                                                Draft Draft 
XLA_EVENT_PROCESS_STATUS     US                 E                                                Error Error 
XLA_EVENT_PROCESS_STATUS     US                 I                                                 Invalid Invalid 
XLA_EVENT_PROCESS_STATUS     US                 P                                                Processed Processed 
XLA_EVENT_PROCESS_STATUS     US                 R                                                Related Event In Error Related Event In Error 
XLA_EVENT_PROCESS_STATUS     US                 U                                                Unprocessed Unprocessed 


LOOKUP_TYPE                  LANGUAGE          LOOKUP_CODE MEANING         DESCRIPTION 
XLA_EVENT_STATUS           US                          I                                          Incomplete Incomplete 
XLA_EVENT_STATUS           US                          N                                         No Action No Action 
XLA_EVENT_STATUS           US                          P                                          Processed Processed 
XLA_EVENT_STATUS           US                          U                                          Unprocessed Unprocessed 
LOOKUP_TYPE                          LANGUAGE  LOOKUP_CODE MEANING              DESCRIPTION 
XLA_EVENT_PROCESS_STATUS     US                 D                                                Draft Draft 
XLA_EVENT_PROCESS_STATUS     US                 E                                                Error Error 
XLA_EVENT_PROCESS_STATUS     US                 I                                                 Invalid Invalid 
XLA_EVENT_PROCESS_STATUS     US                 P                                                Processed Processed 
XLA_EVENT_PROCESS_STATUS     US                 R                                                Related Event In Error Related Event In Error 
XLA_EVENT_PROCESS_STATUS     US                 U                                                Unprocessed Unprocessed 


LOOKUP_TYPE                  LANGUAGE          LOOKUP_CODE MEANING         DESCRIPTION 
XLA_EVENT_STATUS           US                          I                                          Incomplete Incomplete 
XLA_EVENT_STATUS           US                          N                                         No Action No Action 
XLA_EVENT_STATUS           US                          P                                          Processed Processed 
XLA_EVENT_STATUS           US                          U                                          Unprocessed Unprocessed 

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_events
where EVENT_ID=20879204
and application_id=200;

delete from xla_events
where EVENT_ID=20879204
and application_id=200;
--one row deleted

 

commit;