IBM Support

IJ10605: INEFFICIENT CONTRACT QUERY AND DATA INACCURACY IN CONTRACT CLASS REVISECONTRACT FUNCTION

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

  • DESCRIPTION:
    Revise Blanket Contract warning message may be incorrect and
    may cause latency in the revision process if the contract has
    many revisions, lines,  and release POs with revisions.
    
    This scenario is apparent when there are a high number of POs
    against a contract upon contract revision. Analysis shows that
    some of the queries which get executed during the contract
    revision action may cause an incomplete dataset to be presented
    to the User, as well as a latency in completing the action.
    
    STEPS TO REPRODUCE:
    Step 1:
    -Go To Contracts | Purchase Contracts
    -Common Actions | New Purchase Contract
    -In the Contract field enter "BL-1"
    -In the Description field enter "Blanket Contract 1"
    -In the Type field | Select Value | click BLANKET
    -In the End Date field click the Select Date button
    -Click on the date that is one year from today
    -In the Company field enter "almar" and tab out
    -Save the record
    -On the Contract Lines tab click the New Row button
    -In the Item field enter "0-0031" and tab out
    -In the Quantity field enter 24 and tab out
    -In the Order Unit field enter "each" and tab out
    -In the Unit Cost field enter 2.50 and tab out
    -Click the New Row button
    -In the Item field enter "0-0048" and tab out
    -In the Quantity field enter 24 and tab out
    -In the Order Unit field enter "each" and tab out
    -In the Unit Cost field enter 2.50 and tab out
    -Click the New Row button
    -In the Item field enter "0-0514" and tab out
    -In the Quantity field enter 24 and tab out
    -In the Order Unit field enter "each" and tab out
    -In the Unit Cost field enter 2.50 and tab out
    -Click the New Row button
    -In the Item field enter "0-7205" and tab out
    -In the Quantity field enter 24 and tab out
    -In the Order Unit field enter "each" and tab out
    -In the Unit Cost field enter 2.50 and tab out
    -Save the record
    -More Actions | Authorize Sites
    -Click the Select Sites button
    -Click the checkboxes for BEDFORD and NASHUA
    -Click OK
    -Common Actions | Change Status
    -In the New Status field use the drop-down arrow and click
    Approved
    -Click OK
    
    Step 2:
    -Profile Information
    -In the Default Insert Site field | Select Value
    -Click NASHUA then click OK
    -Go To Purchasing | Purchase Orders
    -Common Actions | New Purchase Order
    Enter 4000 as PO number.
    -In the Description field enter "Nashua non-contract PO"
    -In the Company field enter "almar" and tab out
    -On the PO Lines tab click the New Row button
    -In the Item field | Detail Menu | Select Value
    -Click 1002
    -In the Order Unit field enter "each" and tab out
    -In the Conversion Factor field enter 1 and tab out
    -In the Unit Cost field enter 2.50 and tab out
    -In the Storeroom field enter "central" and tab out
    -Save the record
    -Common Actions | Approve Purchase Order
    -Click OK
    
    Step 3:
    -Profile Information
    -In the Default Insert Site field | Select Value
    -Click BEDFORD then click OK
    -Go To Contracts | Purchasing Contracts
    -In the Contract field enter "BL-1" and press Enter
    -Click BL-1
    -More Actions | Create Release PO
    Enter 4000 as PO number
    -Click the checkbox for Line 1
    -In the Conversion Factor field enter 1
    -Click OK
    
    Step 4:
    -Go To Purchasing | Purchase Orders
    -In the PO field enter "4000" and press Enter
    -Click 4000
    -On the PO Lines tab expand the details for the PO Line
    -In the Storeroom field enter "central" and tab out
    -Save the record
    -Common Actions | Approve Purchase Order
    -Click OK
    
    Step 5:
    -Repeat the steps (step 3 and 4) to create and approve 3 more
    Release POs (PO 4001, PO 4002, PO 4003) on the contract, one
    for each of the other 3 items
    (For example, PO 4001 has Contract Line 2. PO 4002 has Contract
    line 3. PO 4003 has Contract line 3. All 3 POs are approved.)
    
    Step 6:
    -Go To Purchasing | Purchase Orders
    -Bring up PO 4000.
    -Action Revise PO. Enter something in Revised Description.
    Click OK. (Very important step to reproduce this use case)
    PO 4000 Revision 1 PNDREV status will be created. Approve PO
    4000 Revision 1.
    
    Step 7:
    -When there are 4 approved POs for the contract, Go To
    Contracts | Purchasing Contracts
    -In the Contract field enter "BL-1" and press Enter
    -Click BL-1
    -More Actions | Revise Contract
    -In the Description field enter "Remove Line 2"
    -Click OK at the System Message
    
    RESULTS:
    System Message appears:
    BMXAA6146W - This contract revision is currently referenced on
    one or more open purchasing documents.
    Documents PO 4000, PO 4000, PO 4001, PO 4002, PO 4003, PO 4000,
    PO 4000, PO 4000, PO 4000 currently reference this contract
    revision.
    Do you want to proceed?
    
    EXPECTED RESULTS:
    System Message appears:
    BMXAA6146W - This contract revision is currently referenced on
    one or more open purchasing documents.
    Documents PO 4000, PO 4000, PO 4001, PO 4002, PO 4003 currently
    reference this contract revision.
    Do you want to proceed?
    
    PRODUCT VERSION:
    7.6.0.9 Build 20171127-0100
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * MAXIMO                                                       *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * INEFFICIENT CONTRACT QUERY AND DATA INACCURACY IN CONTRACT   *
    * REVISE CONTRACT FUNCTION                                     *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

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

Temporary fix

Comments

APAR Information

  • APAR number

    IJ10605

  • Reported component name

    CONTRACTS

  • Reported component ID

    5724R46CN

  • Reported release

    760

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-10-18

  • Closed date

    2018-11-02

  • Last modified date

    2018-11-02

  • 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

    CONTRACTS

  • Fixed component ID

    5724R46CN

Applicable component levels

  • R760 PSY

       UP



Document information

More support for: Maximo Asset Management

Software version: 760

Reference #: IJ10605

Modified date: 02 November 2018