IBM Support

IJ09150: ENTER DAILY TIME BY ENTER BY WORK ORDER OPTION

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

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 number

    IJ09150

  • Reported component name

    WORK ORDERS

  • Reported component ID

    5724R46WO

  • Reported release

    760

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-09-14

  • Closed date

    2018-11-08

  • Last modified date

    2018-11-08

  • 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



Document information

More support for: Maximo Asset Management
Work Order Tracking

Software version: 760

Reference #: IJ09150

Modified date: 08 November 2018