IJ09150: ENTER DAILY TIME BY ENTER BY WORK ORDER OPTION

APAR status

• Closed as program error.

Error description

• In labor reporting, when trying to enter daily time by enter
  by
  work order option, using select value and select by labor on
  the labor field yields different labor default if the
  associated labor
  rate contract has different external administrators.
  
  PERFORMANCE ISSUE: NO
  
  STEPS TO REPRODUCE:
  Setting up the environment:
  
  DOMAIN
  1. Create new table domain
  a. Domain: NWRLRCEXTADM
  b. Object: MAXUSER
  c. Validation Where Clause: :userid in (select gu.userid from
  maxgroup mg, groupuser gu where mg.NWRAUTHLABORCONTRACT = 1 and
  gu.groupname = mg.groupname) and status = ACTIVE
  d. List Where Clause: userid in (select gu.userid from maxgroup
  mg, groupuser gu where mg.NWRAUTHLABORCONTRACT = 1 and
  gu.groupname = mg.groupname) and status = ACTIVE
  
  DATABASE CONFIGURATION
  1. Go to MAXGROUP object > add new attribute
   Attribute: NWRAUTHLABORCONTRACT
   Type: YORN
   Alias: NWRAUTHLABORCONTRACT
   Entity: MAXGROUP
   Column: NWRAUTHLABORCONTRACT
   Search Type: EXACT
   Persistent: checked
   Save
   Create new object
   Object: NWRLRCEXTADM
   Description: Labor Rate Contract External Administrators
   Service: CONTRACT
   Level: SYSTEM
   Save
  2. Add new attributes for object created in step 3
  CONTRACTNUM
   Description: Contractnum
   Type: UPPER
  . Length 8
   Title: Contract Number
   Same as object: CONTRACT
   Same as Attribute: CONTRACTNUM
   Search Type: WILDCARD
   Persistent: checked
  b. NWRLRCEXTADMID
  Description: Nwrlrcextadmid
   Type: BIGINT
   Length: 19
   Title: Nwrlrcextadmid
  Search Type: EXACT
   Persistent: checked
  c. USERID
  Description: Userid
   Type: UPPER
  Length: 30
  Title: User
  Domain: NWRLRCEXTADM
  Same as Object: PERSON
  Same as Attribute: PERSONID
  Search Type: WILDCARD
  Persistent: checked
  d.Save
  5. Go to LABORVIEW object, add new relationship
  Relationship: NWRLRCEXTADM
  Where Clause: CONTRACTNUM = :CONTRACTNUM
  Child Object: NWRLRCEXTADM
  Save, turn Admin Mode On, apply configurations
  
  APPLICATION DESIGNER
  1. CONTLABOR application, add External Administration Section
  in Associated Labor tab.
  
  a. Attached is the XML for the modified CONTLABOR app
  2. SECURGROUP app > Labor tab > Add new Restrict Labor
  Entry to specified Labor Rate Contracts checkbox
  
  a. Attached is the XML for the modified SECUGROUP app
  
  
  CONDITIONAL EXPRESSION
  1. Create a new conditional expressions
  2. NWREXTADM
  a. Type: Expression
  b. Expression: exists (select 1 from NWRLRCEXTADM where userid
  = :&USERNAME& and contractnum = :contractnum)
  c. Always Evaluate?: unchecked
  3. Save
  
  SECURITY GROUPS
  1. Create new security group
  a. Group tab:
   Group: APP_EXTADMIN
  b. Sites tab:
   Grant Authorize Group for All Sites
  c. Applications tab:
   Labor Reporting: Grant Read and Save access
   Enter By Crew
   Enter By Labor
   Enter By Work Order
   More Search Fields
  d. Labor tab:
   Grant Authorize Group for All Labor
   Grant Restrict Labor Entry to specified Labor Rate
  Contracts (new checkbox added)
  Data Restrictions tab:
  Object Restriction > Add New
  1. Object: LABORCRAFTRATE
  2. Type: QUALIFIED
  3. Reevaluate?: checked
  4. Condition: NWREXTADM
  
  USERS
  1. Create 2 new users
  2. LABCONADMIN1_MAXTST
  a. User: LABCONADMIN1_MAXTST
  b. User Name: LABCONADMIN1_MAXTST
  c. Person: LABCONADMIN1_MAXTST
  d. Display name: LABCONADMIN1_MAXTST
  e. Default Insert Site: BEFORD
  
  3. LABCONADMIN2_MAXTST
  User: LABCONADMIN2_MAXTST
  User Name: LABCONADMIN2_MAXTST
  Person: LABCONADMIN2_MAXTST
  Display name: LABCONADMIN2_MAXTST
  Default Insert Site: BEFORD
  
  4. Add both users to APP_EXTADMIN security group
  5. Save
  
  Replicating the issue
  
  1. Go to Labor Rate Contracts > Duplicate Contract 1008 (New
  contract created - 1052)
  a. Change status to Approved
  b. Click on Associated Labor tab
  c. Add HUNTER as Associated Labor
  d. Add LABCONADMIN1_MAXTST as External Administrator and 1052
  as Contractnum.
  e. Save
  
  2. Duplicate Contract 1009 (New contract created - 1053
  a. Change status to Approved
  b. Click on Associated Labor tab
  c. Add HUNTER as Associated Labor
  d. Add LABCONADMIN2_MAXTST as External Administrator and 1053
  as Contractnum.
  e. Save
  
  3. Go to Administration > Resources > Labor
  a. Filter and select HUNTER
  b. Click on Crafts tab
  c. Ensure Contract 1052 is set as Default
  
  d. Save
  4. Sign into Maximo as LABCONADMIN1_MAXTST
  5. Go to Work Order - Labor Reporting > Click on Enter By Work
  Order icon on top tool bar
  a. Choose work order 1013 e.g.
  b. Under Daily Time - New Row
  c. On Labor field, if you click Select Value, notice only
  Contract 1052 appears.
  This is correct as LABCONADMIN1_MAXTST is the administrator for
  this contract. Click Cancel.
  
  CURRENT ERRONEOUS RESULT:
  
  5. Delete the daile Time row created in step 4.b. and save
  record.
  a. Go to Work Order - Labor Reporting - Click on Enter By Work
  Order icon on top tool bar
  b. Choose again work order 1013 e.g.
  b. Under Daily Time - New Row
  c. On Labor field, click Select By Labor, filter and select
  HUNTER, notice it shows Contract 1053 which is incorrect.
  
  Note - On Client old version 7608. Prior to applying IFIX003,
  the Craft field remains blank until we manually pick it,
  which then auto-populates Vendor and Contract. But since
  IFIX003, it is auto populating it with the wrong contract.
  
  The same issue remains in 7609 latest IFIX.
  It seems to be looking at the associated labor Default contract
  instead of checking for what the external administrator has
  access to.
  
  EXPECTED RESULT:
  When Select By Labor, filter and select HUNTER, it would to
  shows the same contract that in select Value opton.
  
  ENVIRONMENT:
  Tivolis process automation engine 7.6.0.9-IFIX20180420-1312
  Build 20171127-0100 DB Build V7609-45 HFDB Build HF7609-04
  

Local fix

• NA
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * MAXIMO                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * ENTER DAILY TIME BY ENTER BY WORK ORDER OPTION               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  package:
  	 | release\fix pack | Interim Fix for Release 7.6.1.1 Product
  

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

  WORK ORDERS

• Fixed component ID

  5724R46WO

Applicable component levels

• R760 PSY

     UP