IV55466: CANNOT SET THE SERVICE PROVIDER BILLING OPTION FOR WORK ORDERS

APAR status

• Closed as program error.

Error description

• Environment:
  Service Providers 7.5.2.0
  
  Concerns/Problem:
  Cannot set the Service Provider Billing Option for Work Orders
  In the Organisation (SP) module, Select Action > Service
  Provider Options > Billing Options, we cannot set a Work Order
  status - the value list returns nothing.  I believe this is
  because the value list code is not expecting the domain to have
  organisation (or even customer) specific values. Our WOSTATUS
  domain has domain values by ORGID.  The other status settings
  all work, and their domains all have values without any ORGIDs.
  The work around is to insert a value in the system variable in
  behind this PLUSPBILLSTATWO - this has been a problem in
  SP7.1.1.10, SP7. 5.1.2, and SP7.5.2 which we are on now.  But
  SP7.1.1.10 would respect the PLUSPBILLSTATWO system variable
  when you had inserted something into it via SQL.  But
  SP7.5.1.2, and SP7.5.2 will add WOs to the bill for any synonym
  of COMP and CLOSE, whereas it should add the bill just for the
  status set in the Org application.
  So two problems - cannot set the WO status to be used for
  billing, and when you do it via the back end, the copy WO
  action onto the bill ignores it anyway.
  
  The value we are trying to use is 'BILL' which has an internal
  value of 'COMP'
  There is an issue when setting this through the options, it
  looks like it does not pick up the value when the status value
  has an Organization associated with it., as if I add a 'BILL'
  entry with no organization I can see it in the look-up.
  
  The main cause of the issue, looks to be change in the code.
  The code has changed in getBillableStatusWhereClause within the
  class PlusPBillBatch.
  
  It was -
  
  private String getBillableStatusWhereClause(String
  paramString1, String paramString2, String paramString3)
  throws RemoteException, MXException
  {
  String str1 = getTranslator().toInternalString(paramString1,
  paramString2);
  
  String str2 = " status in (select value from synonymdomain
  where domainid = '" + paramString1 + "' and maxvalue = '" +
  paramString3 + "') ";
  if (!str1.equalsIgnoreCase(paramString3))
  {
  str2 = " (" + str2 + " OR status in ('" +
  SqlFormat.getSQLString(paramString2) + "') ) ";
  }
  
  return str2;
  }
  
  And so this would find all CLOSE statuses (via STR2 and the
  BILL status in paramString2
  
  but now it is -
  
  private String getBillableStatusWhereClause(String
  paramString1, String paramString2, String paramString3)
  throws RemoteException, MXException
  {
  String str1 = "";
  
  String str2 = getTranslator().toExternalList(paramString1,
  paramString3, this);
  
  String str3 = null;
  String str4 = getTranslator().toInternalString(paramString1,
  paramString2);
  if (!str4.equals(paramString3))
  {
  str3 = getTranslator().toExternalList(paramString1, str4, this);
  }
  
  if ((str2 != null) || (str3 != null)) {
  str1 = " status in (" + (str2 != null ? str2 + "," : "") +
  (str3 != null ? str3 + "," : "");
  if (str1.endsWith(","))
  str1 = str1.substring(0, str1.length() - 1);
  str1 = str1 + ") ";
  }
  
  which creates list of all synonyms for CLOSE (param3) and all
  synonyms of COMP via a lookup of BILL (param2) to get the
  internal value then find all synonyms for that internal value.
  
  return str1;
  }
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Maximo for Service Provider 7.5.2.0                          *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * CANNOT SET THE SERVICE PROVIDER BILLING OPTION FOR WORK      *
  * ORDERS                                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * No                                                           *
  ****************************************************************
  

Problem conclusion

• No
  

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:

Fix information

• Fixed component name

  SERVICE PROVIDE

• Fixed component ID

  5724R46SV

Applicable component levels

• R752 PSY

     UP