IJ17946: INCORRECT PLUSCDSINSTR TABLE ORG VALUE WHEN YOU DUPLICATE A DATA SHEET AND CHANGE ORGID VALUE FROM ORIGINAL DATA SHEET

APAR status

• Closed as program error.

Error description

• When you duplicate a datasheet that has the Organization and
  Site values set but you change BOTH the Organization AND Site
  values on the duplicated record before saving, after save if you
  query the database the ORGID still holds the value from the
  original record.
  
  Pre-requisite
  log in as user WILSON
  Go to Profile DEFAULT Information
  Default Insert Site=BEDFORD
  
  Steps to Replicate
  Log into maximo
  Go to Dataheet Template application and insert New Record
  Organization=EAGLENA, Site=BEDFORD
  Scroll down to Asset Functions data area, click New Row
  Asset Function=1, Type=DISCRETE
  Go to sub-tab Calibration Points, click New Row
  Calibration Point=1, Description= Peak 1
  Save Record
  Go to More Actions: Duplicate Data Sheet
  Data Sheet=NEWNAME, Organization=EAGLESA, Site=CONCSITE
  NOTE: MUST change the Organization value from the value in
  original record
  Save record
  Connect to the database use a query tool
  run the following SLQ
  
  select * from PLUSCDSINSTR where DSPLANNUM='NEWNAME'
  
  Result: The ORGID is EAGLENA which is wrong, SITEID is CORRECT
  
  Expected Result: ORGID should be EAGLESA
  
  
  Application:
  Data sheet template
  
  Industry Solution:
  Calibration
  
  
  REPORTED IN VERSION:
  
  Tivoli's process automation engine 7.6.0.6 Build 20161019-0100
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * MAXIMO                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * INCORRECT PLUSCDSINSTR TABLE ORG VALUE WHEN YOU DUPLICATE A  *
  * DATA SHEET AND CHANGE ORGID VALUE FROM ORIGINAL DATA SHEET   *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  package:
  		 | Release 7.6.1.2 of Base Services
  

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

  MAXIMO CALIBRAT

• Fixed component ID

  5724R5700

Applicable component levels