IBM Support

IJ06031: AUTONUMBERING IS SKIPPING NUMBERS IN MAXIMO WHEN RECEIVING ITEMS SEVERAL TIMES IN A ROW

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

  • PROBLEM DESCRIPTION :
    In the Receiving application, autonumbering is skipping numbers
    when they have an asset created by receiving items through the
    Receiving application (if the last one was KEO1261, the next i
    receive is KEO1263).
    If the user receives a quantity of more than one per line (same
    item #), then it produces continuous numbering (e.g if i have
    qty=4 of item number xyz, they would get KEO1261,
    KEO1262,KEO1263,KEO1264).
    The issue is that when they receive assets, the new asset
    number generated is not following the expected ASSETNUM if the
    asset is created through
    the receiving process in the Receiving app. However it works
    fine if you create the assets manually in Assets app.
    In Receiving app, if the latest created asset is for example
    1200, the next ones to be created by the receiving process will
    have the automatic generated autonumber as 1202, 1206, 1208,
    1215, etc... (without a pattern) even if you receive one asset
    per purchase order.
    In Assets app, if the latest created asset is for example 1200,
    the next ones to be created will have the automatic generated
    autonumber correctly as 1201, 1202, 1203, 1204, etc...
    STEPS TO REPRODUCE:
    Here are the steps to replicate it :
    1) Go to Organizations -> EAGLENA. Open Autonumber Setup ->
    Site Level.
    2) Add a new Autonumber for Bedford.
    - Autonumber Name: Assetnum
    - Seed: 1000
    - Prefix: KEO
    3) Go to Purchasing -> Purchase Orders. Create a PO.
    - Vendor: BEX
    4) Go to PO Lines tab. Add a new PO Line:
    - Item: Pump100
    - Quantity: 20
    - Storeroom: Central
    5) Approve PO.
    6) Go to Purchasing -> Receiving. Open PO from step 3/4.
    7) Click on Select Ordered Items. Check the box next to PO Line
    1, and
    change Quantity Due to 15. Press OK.
    8) Save the record.
    9) Click on Change Inspection Status.  Click the box next to PO
    Line 1.
    Press OK.
    10) Click on Receive Rotating Items.  Press Autonumber, and
    make note
    of the last assetnum displayed on the page, (IE, KE01015).
    Press OK.
    11) Click on Select Ordered Items.  Check the box next to PO
    Line 1.
    Quantity Due should be 5 (this is the remaining quantity due on
    the
    PO).  Press OK.
    12) Save the record.
    13) Click on Change Inspection Status.  Click the box next to
    PO Line
    1.  Press OK.
    14) Click on Receive Rotating Items.  Press Autonumber.  Notice
    that the assetnum autokey begins at a higher seed than expected.
        EXPECTED AUTOKEY VALUES: KEO1016-KEO1020
        ACTUAL AUTOKEY VALUES: KEO1031-KEO1036.
    RESULTS: It's clear above
    EXPECTED RESULTS:  Maximo should not be skipping numbers when
    the new asset records are being created.
    PRODUCT VERSION:
    Tivoli's process automation engine 7.6.0.7 Build 20170215-0100
    DB Build V7607-14
    LOCAL FIX :  N/A
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * MAXIMO users                                                 *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Keys are skipped when using autokey while receiving rotating *
    * assets on a single PO in separate receipt transactions.      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    STEPS TO REPRODUCE:
    
    Here are the steps to replicate it :
    
    1) Go to Organizations -> EAGLENA. Open Autonumber Setup ->
    
    Site Level.
    
    2) Add a new Autonumber for Bedford.
    
    - Autonumber Name: Assetnum
    
    - Seed: 1000
    
    - Prefix: FDT
    
    *Also make sure in Database Configuration that the default value
    for ASSET.ASSETNUM is set to &AUTOKEY& or this problem will not
    occur.
    
    3) Go to Purchasing -> Purchase Orders. Create a PO.
    
    - Vendor: BEX
    
    4) Go to PO Lines tab. Add a new PO Line:
    
    - Item: Pump100
    
    - Quantity: 20
    
    - Storeroom: Central
    
    5) Approve PO.
    
    6) Go to Purchasing -> Receiving. Open PO from step 3/4.
    
    7) Click on Select Ordered Items. Check the box next to PO Line
    
    1, and
    
    change Quantity Due to 15. Press OK.
    
    8) Save the record.
    
    9) Click on Change Inspection Status.  Click the box next to PO
    
    Line 1.
    
    Press OK.
    
    10) Click on Receive Rotating Items.  Press Autonumber, and
    
    make note
    
    of the last assetnum displayed on the page, (IE, FDT1015).
    
    Press OK.
    
    11) Click on Select Ordered Items.  Check the box next to PO
    
    Line 1.
    
    Quantity Due should be 5 (this is the remaining quantity due on
    
    the
    
    PO).  Press OK.
    
    12) Save the record.
    
    13) Click on Change Inspection Status.  Click the box next to
    
    PO Line
    
    1.  Press OK.
    
    14) Click on Receive Rotating Items.  Press Autonumber.  Notice
    
    that the assetnum autokey begins at a higher seed than expected.
    
        EXPECTED AUTOKEY VALUES: FDT1016-FDT1020
    
        ACTUAL AUTOKEY VALUES: FDT1031-FDT1036.
    
    RESULTS: It's clear above
    
    EXPECTED RESULTS:  Maximo should not be skipping numbers when
    the new asset records are being created.
    

Problem conclusion

  • Keys that are generated in the Receive Rotating Items dialog are
    still expended if the user chooses Cancel. These keys are not
    restored and this fix does not change that behavior.
    
    The fix for this APAR is contained in the following maintenance
    package:
    	| release\fix pack\interim fix for Release 7.6.1.0
    

Temporary fix

Comments

APAR Information

  • APAR number

    IJ06031

  • Reported component name

    ADMINISTRATION

  • Reported component ID

    5724R46A1

  • Reported release

    760

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-04-26

  • Closed date

    2018-05-18

  • Last modified date

    2018-05-18

  • 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

    ADMINISTRATION

  • Fixed component ID

    5724R46A1

Applicable component levels

  • R760 PSY

       UP



Document information

More support for: Maximo Asset Management
System Related

Software version: 760

Reference #: IJ06031

Modified date: 18 May 2018