IV79186: ADVANCED SEARCH BILLBATCHNUMBER RESULTSET EMPTY IN PLUSPWO APP

APAR status

• Closed as user error.

Error description

• Title:
  Advanced Search billbatchnumber resultset empty in
  PLUSPWO APP
  
  Problem Description:
  Search for workorders that are on a specific billbatch.
  Use Advanced Search and enter the billbatchnumber
  The resultset is empty.
  The automatically generated query (look at the where clause) is:
  
  '(siteid like '%219%') and (exists (select 1 from
  maximo.pluspbillbatch
  where ((billbatchnum like '%1507%')) and (exists (select 1 from
  pluspbillline where pluspbilllineid = (select
  max(pluspbilllineid) from
  pluspbillline where exists (select 1 from workorder where
  wogroup=workorder.wonum and siteid=workorder.siteid and
  pluspbillline.
  refwo=wonum and pluspbillline.siteid=siteid)) and
  orgid=pluspbillbatch.
  orgid and billbatchnum=pluspbillbatch.billbatchnum))))'
  
  This auto-generated where clause is INCORRECT
  
  
  Steps to Replicate
  1.Go to System Configiuration > Platform Configuration >
  Application designer
  Application field: PLUSPWO press enter
  
  2.On the Open the Dialogox editor and select ?searchmore?Add
  additional fields using the standard relationship:
  PLUSPBILLBATCH.BILLBATCHNUM
  The default relation between WORKORDER and PLUSPBILLBATCH is
  
  exists (select 1 from pluspbillline where pluspbilllineid =
  (select max(pluspbilllineid) from pluspbillline where exists
  (select 1 from workorder where wogroup=:wonum and siteid=:siteid
  and pluspbillline.refwo=wonum and pluspbillline.siteid=siteid))
  and orgid=pluspbillbatch.orgid and
  billbatchnum=pluspbillbatch.billbatchnum)
  
  System Information:
  Asset Management for IBM SmartCloud Control Desk 7.5.1.1 Build
  201309181921 DB Build V7511-12
  Asset Management for IBM SmartCloud Control Desk for Service
  Providers 7.5.1.1 Build 201309181921 DB Build V7511-00
  Configuration items for IBM SmartCloud Control Desk 7.5.1.1
  Build 201309181719 DB Build V7511-09 Configuration items for IBM
  SmartCloud Control Desk for Service Providers 7.5.1.1 Build
  201309181719 DB Build V7511-00 SLA Hold for IBM SmartCloud
  Control Desk 7.5.1.1 Build 201309181719M DB Build V7511-00
  Advanced Workflow Components for IBM SmartCloud Control Desk
  7.5.1.1 Build 201309181719 DB Build V7511-00 Data Integration
  and Context Menu Service Configuration 7.5.0.0 Build 20090911D2
  DB Build V7117-07 Oracle Adapter custom classes 7.5.0.0 Build
  20110805-1549 DB Build V7500-04
  

Local fix

• N/A
  

Problem summary

Problem conclusion

Temporary fix

Comments

• It can only search for Work Orders with a specific Bill Batch if
  the work order has a line and it was copied in the Bill Batch.
  So, the relationship PLUSPBILLBATCH.BILLBATCHNUM is correct, it
  verifies if the Bill Batch has a line copied, then if the Bill
  Batch doesn't have any lines, the work order was not copied, so
  the Work Order isn't in a Bill Batch, and the search will not
  find the Work Order.
  
  In short, you need to create lines to Work Order and copy it
  into Bill Batch, then the search will work fine.
  

APAR Information

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

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

Fix information

Applicable component levels