Checked the web application query again, as Arvin advised that the changes in the shipped date only fix the issue in the scanner, but the issue in the portal is still not fixed. Checked the data for checking what condition it does not meet in the query, but as per checking, the query is displaying the expected data, but it is not in the portal, will continue the testing tomorrow.