When Searching Move Order INVTOMAI By 'Lines' (Items Tab) In Results Box, Header Date Is Used For Search Date Required APP-INV-05507 (Doc ID 2945402.1)

Last updated on APRIL 27, 2023

Applies to:

Symptoms

Move order form search on move order line date actually searches header dates. 

Searching via Find in the Move Order form, when using "Date Required" range located in the "Items" tab of the "Find Move Orders" form by selecting "Lines"
the query does not search for the lines of move orders with the date required based on the lines as expected. It is using the Headers Date Required date.

 
Error

APP-INV-05507: There were no Move order records found

Expect (in the results area when checking the Lines Radio Button) that the results should be filtered on the Date Required field based on lines.
If Header Radio Button is checked, then search by the Header's Date Required is appropriate, but when selecting the Lines Radio Button, intuitively it is expected that
the Date Required should be checked against the Lines.

Steps

1. Create Move Order: Inventory > Move orders > Create Move Order

2.  Enter Line with Date Required of May 2023 on the line >Approve and  Note March date on the Header is March 2023

3. Close window

4. Move Order > Move Order > Find Move Order (Click Flashlight)

a. First find by Move Order Number > Move Order is found (Baseline test)
b. Check Move order by Item > Move Order is found (Additional Baseline test)
c. Check Move order by May 2023 Date Required date (Under Lines tab in Find Pop-up and clicking on ** Lines ** Radio Button in the results section) > Move Order is NOT found, this is the issue
d. Check Move order by May 2023 Date Required date (Under Lines tab in Find Pop-up and clicking on ** Header ** Radio Button in the Results Section ) >

Move Order IS found and this is being validated against the header of the move order even though the lines radio button is checked

Changes

Cause

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