EAR9.2: Wrong SetID Populated for 'Search Preference' Field in Item List Page (Doc ID 2010500.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Wrong SetID populated for 'search preference' field in Item List page

ACTUAL BEHAVIOR
---------------
Whenever the users update the item details in ‘Item List’ page simultaneously it tries to update the OPRID in the 1st row of SEARCH_PREFER table irrespective of the SetID.
So users are not able to update the item details simultaneously though they belong to different countries.

EXPECTED BEHAVIOR
---------------
Users should be able to update the item details in ‘Item List’ page simultaneously

ENVIRONMENT
---------------
Application & Version: 9.2
Bundle/Patch:
Environment: Production

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

  1. Go to the navigation Main Menu >Accounts Receivables > Customer Accounts > Item Information > Item List.
  2. Enter SetID, Unit and Customer in Item List tab and click the `Advanced Search' link.
  3. Search preference field is populated with the value `TEST' in SEARCH_PREFER table where the SetID equals to GRMNY which is 1st in alphabetical order but we have selected the SetID SHARE which does not have any row in SEARCH_PREFER table.
  4. Though the SetID does not appear in the prompt the 'search preference' field is populated with the value in 1st setid in alphabetical order in SEARCH_PREFER table.


BUSINESS IMPACT
-----------------------
Due to this issue, whenever the users update the item details in ‘Item List’ page simultaneously it tries to update the OPRID in the 1st row of SEARCH_PREFER table irrespective of the SetID. So users are not able to update the item details simultaneously though they belong to different countries.

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