Inventory item business object

The sample Item business object for the connector populates data directly into the MTL_SYSTEM_ITEM base table. The sample Item business object, which is hierarchical, uses the Item Interface tables. The following three tables must be populated in the Item Interface:

After data has been inserted into the Item Interface tables, the Item Interface concurrent program must be run to import the data into the application tables. Three options are available for running the Item Interface concurrent program:

The interface table MTL_INTERFACE_ERRORS stores any error messages that are generated when the Item concurrent program runs. When an error occurs, the application administrator must correct the error and remove the error record from the MTL_INTERFACE_ERRORS table before restarting the concurrent program.

Note:
Because the concurrent program is used to import data in to the HZ tables, key values are not returned.

The Item Interface tables support Create and Update operations only. Create and Update operations both use the Create verb. Retrieve operations must use either the base tables or a view defined on the base tables. The sample business object Item_BO supports Retrieve and Delete operations based on the interface tables. An Item can be deleted only if it is not used in any transactions. Otherwise, you must perform a logical delete by setting the status of the item to "Inactive".

Copyright IBM Corp. 1997, 2004