-- Creted by Prudhvi </code> DECLARE p_event_source_info xla_events_pub_pkg.t_event_source_info; BEGIN p_event_source_info.source_application_id := NULL; --101 GL -- 602 XLE p_event_source_info.application_id := 222; -- AR p_event_source_info.legal_entity_id := 1234; p_event_source_info.ledger_id := 1; p_event_source_info.entity_type_code := 'TRANSACTIONS'; p_event_source_info.transaction_number := NULL; p_event_source_info.source_id_int_1 := 1234; -- Customer Transaction ID; p_event_source_info.source_id_int_2 := NULL; p_event_source_info.source_id_int_3 := NULL; p_event_source_info.source_id_int_4 := NULL; p_event_source_info.source_id_char_1 := NULL; p_event_source_info.source_id_char_2 := NULL; p_event_source_info.source_id_char_3 := NULL; p_event_source_info.source_id_char_4 := NULL; xla_events_pub_pkg.delete_event (p_event_source_info => p_event_source_info, p_event_id => 1234, -- xla_events p_valuation_method => NULL, p_security_context => NULL ); DBMS_OUTPUT.put_line('Updated Status'); commit; exception when others then DBMS_OUTPUT.put_line('Error:'||SQLERRM); END;