xla_events

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;