- continue debugging the application to find the cause of the error, it is only extracting few data
- as per checking, the cause of the error is in the script, it has a filter in where clause causing the application to extract that data that meets the filter
- the filter is cstflg = 1, verify the use of the filter with Ms. Jane, as per ms. Jane, if the field value equals 1, means, it is the updated cost
- modify the query and remove the condition, as per Ms. Jane, the data in cstpln is all updated thus it does not need that filter
- test the modified application and as per checking, the Masterfile extracted is now correct versus the data in JDa