IZ92548: BMXAA4210E - DATABASE ERROR NUMBER {0} HAS OCCURRED. FOR INPUT STRING: "994,843"

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When interfacing Maximo 7.1 with Oracle Applications 12, you may
    encounter this error when sending Inventory Reservation to the
    Oracle Applications.  The error occurs when the ExternalRefID
    value for an Inventory item is a value that will contain a
    Thousands separator. The error indicates a Mismatch of the
    EXTERNALREFID value which is a maxtype of ALN or Oracle type of
    Varchar2, that is being placed into the field OA_ITEM_ID which
    has a maxtype of INTEGER or an Oracle type of number.  The
    Oracle Adapter is unable to place the Alpha Numeric value into
    the Numeric field in the associated Interface table for the
    Inventory Reservation Transaction.
    

Local fix

  • None Available
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Thousand separator in ExternalRefId field.   *
    ****************************************************************
    * PROBLEM DESCRIPTION: When interfacing Maximo 7.1 with Oracle *
    *                      Applications 12, you may                *
    *                                                              *
    *                      encounter this error when sending       *
    *                      Inventory Reservation to the            *
    *                                                              *
    *                      Oracle Applications.  The error occurs  *
    *                      when the ExternalRefID                  *
    *                                                              *
    *                      value for an Inventory item is a value  *
    *                      that will contain a                     *
    *                                                              *
    *                      Thousands separator. The error          *
    *                      indicates a Mismatch of the             *
    *                                                              *
    *                      EXTERNALREFID value which is a maxtype  *
    *                      of ALN or Oracle type of                *
    *                                                              *
    *                      Varchar2, that is being placed into the *
    *                      field OA_ITEM_ID which                  *
    *                                                              *
    *                      has a maxtype of INTEGER or an Oracle   *
    *                      type of number.  The                    *
    *                                                              *
    *                      Oracle Adapter is unable to place the   *
    *                      Alpha Numeric value into                *
    *                                                              *
    *                      the Numeric field in the associated     *
    *                      Interface table for the                 *
    *                                                              *
    *                      Inventory Reservation Transaction.      *
    *                                                              *
    *                      LOCAL FIX:                              *
    *                                                              *
    *                      None Available                          *
    *                                                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    *                                                              *
    *                                                              *
    *                                                              *
    ****************************************************************
    BMXAA4210E - DATABASE ERROR NUMBER  0  HAS OCCURRED. FOR INPUT
    STRING: "994,843"
    

Problem conclusion

  • Class InvResOutExt.java changed.
    
    
    
    
    
    The fix for this APAR is contained in the following maintenance
    package:
    
      | release\fix pack | REL 7.1.0.0 - BS
    
      | release\fix pack | REL 7.1.1.7 - BS
    
      | release\fix pack | REL 7.5.0.0 OR
    

Temporary fix

Comments

APAR Information

  • APAR number

    IZ92548

  • Reported component name

    MAXIMO UTILITIE

  • Reported component ID

    5724R5600

  • Reported release

    710

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-01-19

  • Closed date

    2011-02-17

  • Last modified date

    2011-02-17

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Modules/Macros

  •    MAXIMO
    

Fix information

  • Fixed component name

    MEA FOR ORACLE

  • Fixed component ID

    5724R50OR

Applicable component levels

  • R710 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

IBM Maximo Enterprise Adapter

Software version:

710

Reference #:

IZ92548

Modified date:

2011-02-17

Translate my page

Machine Translation

Content navigation