Inventory component

The inventory component provides for the bidirectional synchronization of inventory (item‐storeroom) data.

Table 1. Inventory component

Name

Description

Object Structure

MXINVENTORY

Interface Table

MXINVENTORY_IFACE

Integration Controls
  • CATEGORYXREF
  • GENSTORE
  • LANGXREF
  • ORGXREF
  • SITEXREF

Outbound Implementation Details

Table 2. Outbound implementation details
Name Description

Publish Channel

MXINVENTORY_TOOA12

Java Process

inventory\MoutInvProcess

Processing Class

InventoryOutExt

PL/SQL Stored Procedure

MXE_INV_SP

PL/SQL User Exit Procedure

MXE_USR_INV_SP

Oracle Interface Tables

MTL_SYSTEM_ITEMS_INTERFACE

Filtering

None

Inbound Implementation Details

Table 3. Inbound implementation details
Name Description

Synchronization Script

syncitm.sql

Oracle Integration Control

ITEMIN

Triggering Tables
  • MTL_SYSTEM_ITEMS
  • MTL_MATERIAL_TRANSACTIONS

PL/SQL Stored Procedure

api_inv_sp

PL/SQL User Exit Procedure

MOF_USR_INV_SP

Enterprise Service

MXINVENTORY_FROA12

Concurrent job request set

<MAXORA_schema_name>:Maximo Item & Inventory Master Data

Processing Class

InventoryInExt

Java Process

None

Filtering

Bypass if the value of the ITEMIN integration control is 0.