Second Search in Prepare Mass Additions, Without Closing the Form, Gives Different Results
Last updated on MARCH 08, 2017
Applies to:Oracle Assets - Version 12.1.3 and later
Information in this document applies to any platform.
When searching mass additions by queue name, get a list, then search again without changing any search parameter, get only one-two records instead of all results that were after the first search.
Examining Last Query showed that on the second search the following condition is added to the query:
AND (MASS_ADDITION_ID IN (SELECT MASS_ADDITION_ID
WHERE LOCATION_ID = XXX))
Most likely the location is taken from the mass addition the cursor was on before the second search
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms