Second Search in Prepare Mass Additions, Without Closing the Form, Gives Different Results (Doc ID 1961564.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Assets - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

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
                                    FROM FA_MASSADD_DISTRIBUTIONS
                                   WHERE LOCATION_ID = XXX))
Most likely the location is taken from the mass addition the cursor was on before the second search

Cause

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