Very Slow Change Schedule Action On Flight Shipments (Doc ID 2544657.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

When performing action Change Schedule the following SQL is performed for every flight even if it is expired.

select flight_gid,flight_xid,major_record_type,is_air_cargo,leave_time_after_midnight,arrival_time_after_midnight,elapsed_time,flight_category,src_iata_city_code,dest_iata_city_code,day_adjustment_counter,effective_date,discontinue_date,frequency,traffic_restriction,src_location_gid,dest_location_gid,domain_name, lv_tm_after_midnight_uom_code, ar_tm_after_midnight_uom_code, elapsed_tm_uom_code from flight where flight_gid =?

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.