How to: Generate a GD after modifying a flight information such as Route, Crew etc.

Owned by Dipayan Dey (Deactivated)
Last updated: 10/10/2017
1 min read

CBP Gen Dec Reports returns BLANK data if run for next day (+1)

Steps to recreate -

1. Go to AircraftFollow
2. Take a flight from 11th Oct
3. Change the route of the flight to SINHNL
4. Now, Generate the Gen Dec Report for CBP for the flight

What Happens?
Report returns as BLANK without any crew / flight info.

Step-by-step guide

The following requirements must be fulfilled to see pre-generated GendDec reports in CrewPortal

  1. CPDutyJob must creates set of records that will be used in Crew Portal to find GenDec reports by combination of CPDutyEmployee, CPDutyFlight and FlightFollows 
  2. The Reports only retrieve data if it meets the following condition: the Flight Departure date must be between (current date - 1 month) and (current date - 1 month) + DaysAfterCurrentFlightBriefDocument UPMT value.

Once the UpdateCPDutyJob completes the job execution after a Flight info viz. Crew / Route is altered and updated, then the GenDec generates data.
When we try to generate immediately after making a change to the flight it doesn't show up in the GD as the UpdateCPDutyJob hasn't completed updating the relational Employee, Flight and Duty tables.