IV73778: DESKTOP REQUISITION SEARCH FOR REQUISITIONS DOES NOT RETURN RESULTS

APAR status

• Closed as program error.

Error description

• Desktop Requisitions - View Requisitions result set of
  43 items, When enter anything in the search fields
  above the result set no  results returned.
  
  Issues exists from 7.5.0.0 through to 7.5.0.8 and 7.6X versions
  
  
  Tested MAM 7.5.0.7 and was able to reproduce the reported issue,
  overrode the Application Restricition which will allow the
  logged in
  user to see all DR's created for site even with no relation to
  the user
  that created the DR.
  
  Steps to Reproduce:
  1) log in as maxadmin/maxadmin
  2)Self Service > Desktop Requisition > View Requisition
  3) Requisitions section take note of a Requistion #  from the
  results
  set, example Requisition #1002
  This Requisition created by Maxadmin
  To Allow Wilson or any other user to see Maxadmin creted DR
  #1002 the
  Application Restriction will need to be overridden.
  
  Override App Restriction:
  This rule can be overridden in the application restriction,
  using any where clause to get the required DeskTop Requisitions.
  Steps to make change where application restriction
  4)Application Designer
  5)select App ViewDR
  6)Workspace tab -scroll to bottom hightlight Requisistions
  Header
  7)click on Control Properties menu button to bring up the Table
  Properties dialog box.
  8)click on Advnace Tab
  9)Application Restrictions field -alter the query caluse to
  return the requisitions for both the personid and the userid
  10) log out
  11) log back in as wilson/wilson
  12) Self Service > Desktop Requisition > View Requisition
  13) Requisition Results set will now contain all DR's for the
  site ,
  even DR's created by users that have no relations to wilson
  14) Requisistion Results set> select DR #1002 from step #3 (DR
  created
  by maxadmin)
  15) Search for Requisitions> enter DR #1002 in the Requisition
  field,
  click  "find" button.
  16) Requisitions Result should  display DR #1002 , problem no
  results
  found even though  DR #1002 displays when user wilson enters the
  View
  Requisitions result set there are no results returned when user
  wilson
  does and actual speicific search.
  
  This is incorrect: expected behaviour with the application
  restriction
  overridden user should be able to search for specific DR's using
  the
  Seard for Requisitions , and populating any of the specific
  search
  fields.
  
  
  MRSet method needs to be fixed/should be like:
  
  public void findAllMRsForPersonCode(String personCode) throws
  MXException, RemoteException
      {
          String[] type = {"STANDARD"};
          String[] status = {"APPR"};
        String where = "type in
  ("+getTranslator().toExternalList("MRTYPE", type)+")" +
               " and ((historyflag = :NO and status in
  ("+getTranslator().toExternalList("MRSTATUS", status)+")))";
  
        setWhere(where);
        this.setOrderBy("mrdate desc");
        reset();
      }
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Maximo Users on 75 using Desktop Requisition Application     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * DESKTOP REQUISITION SEARCH FOR REQUISITIONS DOES NOT RETURN  *
  * RESULTS                                                      *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply Release 7.5.0.9 of Base Services                       *
  ****************************************************************
  

Problem conclusion

• Changed a logic to fix the defect.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• MAXIMO
  

Fix information

• Fixed component name

  PURCHASING

• Fixed component ID

  5724R46PU

Applicable component levels

• R750 PSY

     UP