Creation of material issues

When creating a material issue in the Oracle E-Business Suite, enter the following information in the Demand Source field:

Table 1. Needed information for material issues
Destination Demand source value
Work order WO:<work order number>
Reservation MISC:<Asset management system request number>

Rotating items

The following considerations apply to the issue and return of rotating items.

Oracle users can assign multiple serial numbers on a single material issue transaction, while Maximo® Manage users can enter only one issue transaction per rotating item. A material issue or return that is created in the Oracle E-Business Suite contains a quantity that is greater than one and multiple serial numbers. Then, the integration framework creates an inbound issue transaction with a quantity of one for each serial number.

You create an Oracle Miscellaneous Receipt to return an item under serial control to the storeroom. Then, you must assign the item a serial number that is issued out of the storeroom. Otherwise, an error occurs in Maximo Manage since the serial number does not exist as an asset number in Maximo Manage.

Maximo Manage requires a location when a rotating item is issued. You can create a reservation against a rotating item in Maximo Manage without referencing a work order. However, if you create the corresponding issue transaction in the Oracle E-Business Suite, an error occurs when the integration record does not contain a location, since Maximo Manage requires a location. You can write a user exit procedure or use processing rules to assign a default location.

Filter

The integration framework transfers material issues from the Oracle E-Business Suite when the following conditions are met:

  • The value of the Oracle integration control ISUIN is 1.
  • The issue is a material issue or a receipt.

Integration controls

The material issue integration uses the following Maximo Manage and Oracle integration controls.

Table 2. Material issue integration controls
Control Description System
GENSTORE Dummy identifier for masking storeroom in outbound transactions. Maximo Manage
GENUSR Dummy identifier for masking user ID in outbound transactions. Maximo Manage
ISUIN Send the Oracle E-Business Suite material issue data to Maximo Manage. Oracle E-Business Suite
SITEXREF Cross‐reference the Maximo Manage site ID and the Oracle E-Business Suite operating unit. Maximo Manage
SUBLOCDEL Delimiter between subinventory code and locator ID in the Maximo Manage bin number. Maximo Manage