Receive Item Service

This service is in the WmOAMFG1227 package and has the following fully-qualified service name: inventory1227.intoOA.item:receiveItem.

This service imports items from external sources into Oracle Applications. You can also use this service to import item category assignments and item revisions simultaneously.

Features of this service include the following:

Items can be assigned to a master organization or a child organization. When you assign an item to a child organization, all item-level attributes default down from the master organization only if the attribute column is null. The only exceptions are attributes under status control.
Revisions always exist at the item organization-level. You need revision data for each item organization you update. If you choose not to use revisions table, do not include revisions in the biz doc. The item interface import assigns each item a beginning revision, using the default specified in the organization parameters.

Database Scripts

This service uses the following database scripts:

Script	Description
wm_install_into_invitem.sql	Runs the scripts listed below, except the uninstall script.
wm_into_invitem_pkg.sql	Installs WM_INV_ITEM_IMP_HANDLER_PKG. WM_HANDLE_INV_ITEM, which calls the WM_CONC_REQUEST. WM_REQUEST_SUBMIT procedure to submit the Item Import process.
wm_into_invitem_seq.sql	Creates the following component: WM_MTL_SYSTEM_ITEMS_SETS_S, which creates the SET_PROCESS_ID.
wm_drop_into_invitem.sql	Uninstalls all components created by wm_install_into_invitem.sql.

For more information about using database scripts, see Database Scripts.

Supporting Transaction Definitions

This service was built from the configured services defined in the following transaction definitions:

setItemTxn1227.txp
ItemTxn1227.txp

For information about using the transaction definition files to customize this service, see Transaction Definitions.

Flow Control

This service uses the following flow steps to import items:

specifyDefaultSettings specifies the default parameter settings required for service execution. You should change these settings accordingly.
specifyConcProgParams specifies the default parameter settings required for concurrent program execution. You should change these settings accordingly.
bizDocMapping maps the incoming business document structure to the required Oracle Applications data structures (the interface tables).
- getCoverageScheduleId is a transformer that gets COVERAGE_SCHEDULE_ID querying Oracle Applications database using COVERAGE_SCHEDULE_NAME. This service also checks the null condition for queryParams (same as all other services which are being used in transformers). In case of null value passed to queryParams, this service exits.
- getFACategoryId is a transformer for mapping the business document that takes the ASSET_CATEGORY as input, and returns CATEGORY_ID.
- getFNDLookUpCode converts the incoming Lookup type to LOOKUP_CODE required by Oracle Applications database.
- getHazardClassId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes HAZARD_CLASS as the input parameter, and gets the HAZARD_CLASS_ID querying Oracle Applications database.
- getItemGroupId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes DESCRIPTION as input to get the corresponding ITEM_CATALOG_GROUP_ID querying Oracle Applications database.
- getLookUpCode is a transformer for the business document IData structure to the interface table IData structure. It takes LOOKUP_TYPE and MEANING as input parameters, and queries the table MFG_LOOKUPS to get the LOOKUP_CODE corresponding to the MEANING and TYPE.
- getPOVendorId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes VENDOR_NAME as the input parameter, and queries the table AP_SUPPLIERS to get the VENDOR_ID corresponding to the VENDOR_NAME.
- getPaymentTermId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes PAYMENT_TERM_NAME as the input parameter, and queries the table RA_TERMS_B to get the TERM_ID corresponding to the PAYMENT_TERM_NAME.
- getRoutingHeaderId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes ROUTING_NAME as the input parameter, and queries the table RCV_ROUTING_HEADERS to get the ROUTING_HEADER_ID corresponding to the ROUTING_NAME
- getRuleId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes RULE_NAME as the input parameter, and queries the table RA_RULES to get the RULE_ID corresponding to the input parameters.
- getServiceableItemClassId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes SERVICEABLE_ITEM_CLASS_NAME as the input parameter, and queries the table CS_SERVICEABLE_ITEM_CLASSES to get the SERVICEABLE_ITEM_CLASS_ID corresponding to the SERVICEABLE_ITEM_CLASS_NAME.
- getTransactionSourceId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes TRANSACTION_SOURCE_TYPE_NAME as the input parameter, and queries the table MTL_TXN_SOURCE_TYPES to get the TRANSACTION_SOURCE_TYPE_NAME corresponding to the name.
- getProcessId is a transformer for mapping the business document IData structure to the interface table IData structure. There are two types of transactions: CREATE or UPDATE. Based on the transaction type used as an input parameter to this service, the service returns the associated process ID, and sets a flag to indicate whether the transaction is an insertion or an update.
- getOrgId takes ORGANIZATION_NAME as the input parameter, and queries the table ORG_ORGANIZATION_DEFINITIONS to get the ORGANIZATION_ID corresponding to the ORGANIZATION_NAME.
- getOracleAppsUserId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes ORACLE_APPS_USER_NAME as the input parameter from the business document, and queries the table FND_USER to get the USER_ID. The USER_ID information is required for insertion into the interface tables.
- getOASystemDateObject returns the Oracle Applications system date as a date object.
- getInventoryItemId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes ITEM_CODE as the input parameter, and queries the table MTL_SYSTEM_ITEMS_B_KFV to get the INVENTORY_ITEM_ID corresponding to the current ORGANIZATION_NAME.
- getCodeCombinationId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes CONCATENATED_SEGMENTS as the input parameter, and queries the table GL_CODE_COMBINATIONS_KFV to get the CODE_COMBINATION_ID corresponding to the passed code.
- convertToDateObject gets the date string as input, and converts it to a date object.
- pickSequence gets the sequence name as an input, and picks up the next sequence for that particular one.
- getLocatorId is a transformer for mapping the business document IData structure to the interface table IData structure. It takes LOCATOR and ORGANIZATION_NAME as the input parameter, and queries the view MTL_ITEM_LOCATIONS_KFV and the table ORG_ORGANIZATION_DEFINITIONS to get the INVENTORY_LOCATION_ID corresponding to the LOCATOR and ORGANIZATION_NAME.
- getEmplIdFromFullName converts the input of BUYER_FULL_NAME to a BUYER_ID.
setItemTxn inserts data into the interface table. It extracts data from the IData structure that results from the bizDocMapping service, and puts the data into the Oracle Applications Item Import interface.
importItem imports data to the production table from the interface table. It calls the services execItemConcProg, checkItemImportStatus, and getItemImport_ERR to execute the corresponding concurrent program that inserts data into the production table, and to generate the error/acknowledgement message. If the status of the execution is SUCCESS (returned by the service execItemConcProg), it checks for records in the interface table. If records are found, it then indicates an error during import. In this case, this service calls getItemImport_ERR to retrieve the errors. If no records are found, it comes out of the flow, indicating success of the data import process. If the status of the execution is FAILED, it comes out of execution. There can be two types of action on the record that must be imported: update and insert. This flow checks for the mode of action, and calls the appropriate import program.
- execItemConcProg invokes the stored procedure WM_INV_ITEM_IMP_HANDLER_PKG.WM_HANDLE_INV_ITEM. The procedure calls the corresponding concurrent subroutine to execute the data import process for the Item into Oracle Applications. This service returns Status ID, Request ID, Execution Status Message (for normal concurrent program completion), and database Stored Procedure error message (if an exception occurs in Stored Procedure execution).
- checkItemImportStatus checks the status of the execution by checking the Interface Table for any rejected records corresponding to the current REQUEST_ID. If the query does not return rows, it indicates a successful import. If the query returns rows, it indicates that the concurrent program could not import data successfully in the production tables of Oracle Applications.
- getItemImport_ERR service gets the error message that occurs during the data import to the production table from interface table. Based on the parameter REQUEST_ID, it scans the table MTL_TRANSACTIONS_INTERFACE to get the corresponding message.

For more details on receive transactions, see Overview of Receive Service Transaction Processing.

Business Document Structure

This service uses the business document itemBizDoc. Its structure is as follows:

1.0. MTL_SYSTEM_ITEMS
- 1.1. MTL_ITEM_CATEGORIES
  - 1.2. MTL_ITEM_REVISIONS

1.0 MTL_SYSTEM_ITEMS (Maps to MTL_SYSTEM_ITEMS_INTERFACE)

Field Name	Maps to Column	Description
ITEM_NUMBER	ITEM_NUMBER	Segmented item number.
ORGANIZATION_NAME	ORGANIZATION_ID	Derives ORGANIZATION_ID from ORG_ORGANIZATION_ DEFINITIONS.
SUMMARY_FLAG	SUMMARY_FLAG	Required. Flexfield summary flag.
ENABLED_FLAG	ENABLED_FLAG
START_DATE_ACTIVE	START_DATE_ ACTIVE	Flexfield segment start date.
END_DATE_ACTIVE	END_DATE_ ACTIVE	Flexfield segment end date.
DESCRIPTION	DESCRIPTION	Item description.
BUYER_FULL_NAME	BUYER_ID	Derived AGENT_ID from PO_AGENTS and PER_ALL_PEOPLE_F, where PO_AGENTS.AGENT_ID = PER_ALL_PEOPLE_F. PERSON_ID.
ACCOUNTING_RULE_NAME	ACCOUNTING_ RULE_ID	Derives the RULE_ID from RA_RULES.
INVOICING_RULE_NAME	INVOICING_ RULE_ID	Derives the RULE_ID from RA_RULES.
PURCHASING_ITEM_FLAG	PURCHASING_ ITEM_FLAG
SHIPPABLE_ITEM_FLAG	SHIPPABLE_ ITEM_FLAG	Indicates whether the item can be shipped (Y/N).
CUSTOMER_ORDER_FLAG	CUSTOMER_ ORDER_FLAG
INTERNAL_ORDER_FLAG	INTERNAL_ ORDER_FLAG
SERVICE_ITEM_FLAG	SERVICE_ ITEM_FLAG
INVENTORY_ITEM_FLAG	INVENTORY_ ITEM_FLAG
ENG_ITEM_FLAG	ENG_ITEM_FLAG	Indicates engineering item (Y/N).
INVENTORY_ASSET_FLAG	INVENTORY_ ASSET_FLAG
PURCHASING_ENABLED_ FLAG	PURCHASING_ ENABLED_FLAG	Indicates whether item can be purchased (Y/N).
CUSTOMER_ORDER_ ENABLED_FLAG	CUSTOMER_ ORDER_ ENABLED_FLAG	Indicates whether item can be customer ordered (Y/N).
INTERNAL_ORDER_ ENABLED_FLAG	INTERNAL_ ORDER_ ENABLED_FLAG	Indicates whether item can be internally ordered (Y/N).
SO_TRANSACTIONS_FLAG	SO_ TRANSACTIONS_ FLAG	Sales order transaction (Y/N).
MTL_TRANSACTIONS_ ENABLED_FLAG	MTL_TRANSACTIONS_ ENABLED_FLAG	Indicates whether item is transactable (Y/N).
STOCK_ENABLED_FLAG	STOCK_ENABLED_FLAG	Indicates item can be stocked (Y/N).
BOM_ENABLED_FLAG	BOM_ENABLED_FLAG	Indicates whether item can appear on a Bill of Materials.
BUILD_IN_WIP_FLAG	BUILD_IN_WIP_FLAG	Indicates whether item can be built in WIP.
REVISION_QTY_CONTROL	REVISION_QTY_ CONTROL_CODE	Derived LOOKUP_CODE from MFG_LOOKUPS where LOOKUP_TYPE is MTL_ENG_QUANTITY for meaning column.
CATALOG_GROUP_ DESCRIPTION	ITEM_CATALOG_ GROUP_ID	Derives ITEM_CATALOG_GROUP_ID from MTL_ITEM_CATALOG_GROUPS.
CATALOG_STATUS_FLAG	CATALOG_ STATUS_FLAG	Indicates whether item is catalog complete (Y/N).
RETURNABLE_FLAG	RETURNABLE_FLAG	Indicates whether item can be returned (Y/N).
DEFAULT_SHIPPING_ ORGANIZATION_NAME	DEFAULT_ SHIPPING_ORG	Derives ORGANIZATION_ID from ORG_ORGANIZATION_ DEFINITIONS.
COLLATERAL_FLAG	COLLATERAL_FLAG	Indicates whether the item is a collateral item (Y/N).
TAXABLE_FLAG	TAXABLE_FLAG	Indicates whether item is taxable (Y/N).
QTY_RCV_EXCEPTION_ CODE	QTY_RCV_ EXCEPTION_CODE	Use: NONE for no receiving control enforced. REJECT for preventing receipt of goods or services. WARNING for displaying warning message.
ALLOW_ITEM_DESC_ UPDATE_FLAG	ALLOW_ ITEM_DESC_ UPDATE_FLAG	Indicates whether to allow item description updates on purchase order lines (Y/N).
INSPECTION_ REQUIRED_FLAG	INSPECTION_FLAG	Indicates whether inspection is required (Y/N).
RECEIPT_REQUIRED_FLAG	RECEIPT_FLAG	Indicates whether supplier receipt is required (Y/N).
MARKET_PRICE	MARKET_PRICE	Purchasing market price.
HAZARD_CLASS	HAZARD_CLASS_ID	Derives the HAZARD_CLASS_ID from PO_HAZARD_ CLASSES_B.
RFQ_REQUIRED_FLAG	RFQ_REQUIRED_FLAG	Indicates whether RFQ is required (Y/N).
QTY_RCV_TOLERANCE	QTY_RCV_ TOLERANCE	Maximum permissible over receipt percentage.
LIST_PRICE_PER_UNIT	LIST_PRICE_PER_UNIT
UN_NUMBER_ID	UN_NUMBER_ID	UN purchasing number.
PRICE_TOLERANCE_ PERCENT	PRICE_TOLERANCE_ PERCENT	Price tolerance percentage.
ASSET_CATEGORY	ASSET_CATEGORY_ID	Derives the ASSET_CATEGORY_ID from FA_CATEGORIES_ B_KFV for the concatenated segment.
ROUNDING_FACTOR	ROUNDING_FACTOR	Determines order quantity.
UNIT_OF_ISSUE	UNIT_OF_ISSUE
ENFORCE_SHIP_TO_ LOCATION_CODE	ENFORCE_ SHIP_TO_ LOCATION_CODE	Requires receipt location to match ship to location.
ALLOW_SUBSTITUTE_ RECEIPTS_FLAG	ALLOW_ SUBSTITUTE_ RECEIPTS_FLAG	Indicates whether substitute receipts are allowed (Y/N).
ALLOW_UNORDERED_ RECEIPTS_FLAG	ALLOW_ UNORDERED_ RECEIPTS_FLAG	Indicates whether to allow unordered receipts (Y/N).
ALLOW_EXPRESS_ DELIVERY_FLAG	ALLOW_ EXPRESS_ DELIVERY_FLAG	Indicates whether to allow express delivery (Y/N).
DAYS_EARLY_RECEIPT_ ALLOWED	DAYS_EARLY_ RECEIPT_ALLOWED
DAYS_LATE_RECEIPT_ ALLOWED	DAYS_LATE_ RECEIPT_ALLOWED
RECEIPT_DAYS_EXCEPTION_ CODE	RECEIPT_DAYS_ EXCEPTION_CODE	Use: NONE for no receiving control enforced. REJECT for preventing receipt of goods or services. WARNING for displaying warning message.
RECEIVING_ROUTING_NAME	RECEIVING_ ROUTING_ID	Derives ROUTING_HEADER_ID from RCV_ROUTING_HEADERS.
INVOICE_CLOSE_ TOLERANCE	INVOICE_ CLOSE_ TOLERANCE
RECEIVE_CLOSE_ TOLERANCE	RECEIVE_ CLOSE_ TOLERANCE
AUTO_LOT_ALPHA_PREFIX	AUTO_LOT_ ALPHA_PREFIX	Lot prefix for lot number controlled item.
START_AUTO_LOT_NUMBER	START_AUTO_ LOT_NUMBER
LOT_CONTROL	LOT_ CONTROL_CODE	Derived from MFG_LOOKUPS, where LOOKUP_TYPE = MTL_LOT_CONTROL for the meaning column. Use: 1 for No lot control. 2 for Full lot control.
SHELF_LIFE	SHELF_LIFE_CODE	Derived from MFG_LOOKUPS, where LOOKUP_TYPE = MTL_SHELF_LIFE for the meaning column. Use: 1 for No shelf life control. 2 for Item shelf life days. 4 for User-defined expiration date.
SHELF_LIFE_DAYS	SHELF_LIFE_DAYS
SERIAL_NUMBER_ CONTROL_CODE	SERIAL_NUMBER_ CONTROL_CODE	Derived from MFG_LOOKUPS, where LOOKUP_TYPE = MTL_SERIAL_NUMBER for the meaning column. Use: 1 for No serial number control, 2 for Predefined serial numbers, 5 for Dynamic entry at inventory receipt, 6 for Dynamic entry at sales order issue.
START_AUTO_SERIAL_ NUMBER	START_AUTO_ SERIAL_NUMBER	Start auto serial number.
AUTO_SERIAL_ALPHA_ PREFIX	AUTO_SERIAL_ ALPHA_PREFIX	Serial number prefix.
SOURCE_TYPE	SOURCE_TYPE	Use either Inventory or Supplier. Derived from MFG_LOOKUPS, where LOOKUP_TYPE = MTL_SOURCE_TYPES for the meaning column.
SOURCE_ORGANIZATION_ NAME	SOURCE_ ORGANIZATION_ID	Derives ORGANIZATION_ID from ORG_ORGANIZATION_ DEFINITIONS.
SOURCE_SUBINVENTORY	SOURCE_ SUBINVENTORY
EXPENSE_ACCOUNT	EXPENSE_ ACCOUNT	Derives CODE_COMBINATION_ID from GL_CODE_ COMBINATIONS_KFV.
ENCUMBRANCE_ACCOUNT	ENCUMBRANCE_ ACCOUNT	Derives CODE_COMBINATION_ID from GL_CODE_ COMBINATIONS_KFV.
RESTRICT_SUBINVENTORIES	RESTRICT_ SUBINVENTORIES_ CODE	Derived from MFG_LOOKUPS, where LOOKUP_TYPE = MTL_SUBINVENTORY_ RESTRICTIONS for the meaning column. Use: 1 for Subinventories restricted to predefined list. 2 for Subinventories not restricted to predefined list.
UNIT_WEIGHT	UNIT_WEIGHT
WEIGHT_UOM_CODE	WEIGHT_ UOM_CODE	Weight unit of measure code.
VOLUME_UOM_CODE	VOLUME_ UOM_CODE	Volume unit of measure code.
UNIT_VOLUME	UNIT_VOLUME
RESTRICT_LOCATORS	RESTRICT_ LOCATORS_ CODE	Derived from MFG_LOOKUPS, where LOOKUP_TYPE = MTL_LOCATOR_ RESTRICTIONS for the meaning column. Use: 1 for Locators restricted to predefined list, or 2 for Locators not restricted to predefined list.
LOCATION_CONTROL	LOCATION_ CONTROL_ CODE	Derived from MFG_LOOKUPS, where LOOKUP_TYPE = MTL_LOCATION_ CONTROL for the meaning column. Use: 1 for No locator control. 2 for Previously specified locator control. 3 for Dynamic entry locator control. 4 for Locator control determined at subinventory level. 5 for Locator control determined at item level.
SHINKRAGE_RATE	SHINKRAGE_ RATE	Planned shrinkage rate.
ACCEPTABLE_EARLY_DAYS	ACCEPTABLE_ EARLY_DAYS	Days an order may be early before rescheduling is recommended.
PLANNING_TIME_FENCE	PLANNING_ TIME_ FENCE_CODE	Derived from MFG_LOOKUPS, where LOOKUP_TYPE = MTL_TIME_FENCE for the meaning column. Use: 1 for Cumulative total lead time, 2 for Cumulative manufacturing lead time. 3 for Total lead time. 4 for User-defined time fence.
DEMAND_TIME_FENCE	DEMAND_TIME_ FENCE_CODE	Derived from MFG_LOOKUPS, where LOOKUP_TYPE = MTL_TIME_FENCE for the meaning column. Use: 1 for Cumulative total lead time. 2 for Cumulative manufacturing lead time. 3 for Total lead time. 4 for User-defined time fence.
LEAD_TIME_LOT_SIZE	LEAD_TIME_LOT_SIZE	Lead time lot size.
STD_LOT_SIZE	STD_LOT_SIZE	Standard lot size.
CUM_MANUFACTURING_ LEAD_TIME	CUM_ MANUFACTURING_ LEAD_TIME	Cumulative lead time.
OVERRUN_PERCENTAGE	OVERRUN_ PERCENTAGE	MRP repetitive overrun rate.
MRP_CALCULATE_ATP_FLAG	MRP_CALCULATE_ ATP_FLAG
ACCEPTABLE_RATE_INCREASE	ACCEPTABLE_ RATE_INCREASE	MRP repetitive acceptable rate increase.
ACCEPTABLE_RATE_DECREASE	ACCEPTABLE_ RATE_DECREASE	MRP repetitive acceptable rate decrease.
CUMULATIVE_TOTAL_LEAD_TIME	CUMULATIVE_ TOTAL_LEAD_ TIME
PLANNING_TIME_FENCE_DAYS	PLANNING_TIME_ FENCE_DAYS
DEMAND_TIME_FENCE_DAYS	DEMAND_TIME_ FENCE_DAYS
END_ASSEMBLY_PEGGING_ FLAG	END_ASSEMBLY_ PEGGING_FLAG
REPETITIVE_PLANNING_ FLAG	REPETITIVE_ PLANNING_FLAG
PLANNING_EXCEPTION_SET	PLANNING_ EXCEPTION_SET	Exception control set.
BOM_ITEM_TYPE	BOM_ITEM_TYPE	Derived from MFG_LOOKUPS, where LOOKUP_TYPE is BOM_ITEM_TYPE for meaning column.
PICK_COMPONENTS_FLAG	PICK_ COMPONENTS_ FLAG
REPLENISH_TO_ORDER_FLAG	REPLENISH_TO_ ORDER_FLAG
BASE_ITEM	BASE_ITEM_ID	Derives ITEM_ID from MTL_SYSTEM_ITEMS_B_KFV for the ITEM and Organization.
ATP_COMPONENTS_FLAG	ATP_ COMPONENTS_ FLAG	Required.
ATP_FLAG	ATP_FLAG	Required. Indicates whether ATP must be checked when ordering the item.
FIXED_LEAD_TIME	FIXED_LEAD_TIME	Fixed portion of the assembly lead time.
VARIABLE_LEAD_TIME	VARIABLE_ LEAD_TIME	Variable lead time.
WIP_SUPPLY_LOCATOR	WIP_SUPPLY_ LOCATOR_ID	Derives LOCATION_ID from MTL_ITEM_LOCATIONS_KFV for the concatenated segment.
WIP_SUPPLY_TYPE	WIP_SUPPLY_TYPE	Derived from MFG_LOOKUPS for LOOKUP_TYPE.WIP_SUPPLY.
WIP_SUPPLY_SUBINVENTORY	WIP_SUPPLY_ SUBINVENTORY
PRIMARY_UOM_CODE	PRIMARY_ UOM_CODE	Primary unit of measure code.
ALLOWED_UNITS_LOOKUP	ALLOWED_UNITS_ LOOKUP_CODE	Derived from MFG_LOOKUPS, where LOOKUP_TYPE = MTL_CONVERSION_TYPE for the meaning column’s Allowed Units Lookup Code.
COST_OF_SALES_ACCOUNT	COST_OF_ SALES_ACCOUNT	Derives ACCOUNT_ID from GL_CODE_COMBINATIONS_KFV for the concatenated segment.
SALES_ACCOUNT	SALES_ACCOUNT	Derives ACCOUNT_ID from GL_CODE_COMBINATIONS_ KFV for the concatenated segment.
DEFAULT_INCLUDE_IN_ ROLLUP_FLAG	DEFAULT_ INCLUDE_IN_ ROLLUP_FLAG	Indicates whether to include default value in cost rollup (Y/N).
INVENTORY_ITEM_ STATUS_CODE	INVENTORY_ ITEM_STATUS_ CODE
INVENTORY_PLANNING	INVENTORY_ PLANNING_ CODE	Derives LOOKUP_CODE from MFG_LOOKUPS, where LOOKUP_TYPE = MTL_MATERIAL_PLANNING Inventory Planning Code.
PLANNER_CODE	PLANNER_CODE
PLANNING_MAKE_BUY	PLANNING_ MAKE_BUY_CODE	Indicates whether item is planned as manufactured or purchased. Derives LOOKUP_CODE from MFG_LOOKUPS, where LOOKUP_TYPE = MTL_PLANNING_MAKE_BUY.
FIXED_LOT_MULTIPLIER	FIXED_LOT_ MULTIPLIER
ROUNDING_CONTROL_TYPE	ROUNDING_ CONTROL_TYPE	Derived from MFG_LOOKUPS, where LOOKUP_TYPE = MTL_ROUNDING for the meaning column.
CARRYING_COST	CARRYING_COST	Annual carrying cost.
POSTPROCESSING_LEAD_ TIME	POSTPROCESSING_ LEAD_TIME
PREPROCESSING_LEAD_ TIME	PREPROCESSING_ LEAD_TIME
FULL_LEAD_TIME	FULL_LEAD_ TIME
ORDER_COST	ORDER_COST
MRP_SAFETY_STOCK_PERCENT	MRP_SAFETY_ STOCK_PERCENT
MRP_SAFETY_STOCK	MRP_SAFETY_ STOCK_CODE	Derives the LOOKUP_CODE from MFG_LOOKUPS for LOOKUP_TYPE. MTL_SAFETY_STOCK_TYPE.
MIN_MINMAX_QUANTITY	MIN_MINMAX_ QUANTITY	Minimum minmax quantity.
MAX_MINMAX_QUANTITY	MAX_MINMAX_ QUANTITY	Maximum minmax quantity.
MINIMUM_ORDER_QUANTITY	MINIMUM_ ORDER_QUANTITY
FIXED_ORDER_QUANTITY	FIXED_ ORDER_QUANTITY
FIXED_DAYS_SUPPLY	FIXED_ DAYS_SUPPLY
MAXIMUM_ORDER_QUANTITY	MAXIMUM_ ORDER_QUANTITY
ATP_RULE_NAME	ATP_RULE_ID	Derives RULE_ID from MTL_ATP_RULES for the RULE_NAME.
PICKING_RULE_NAME	PICKING_RULE_ID	Derives PICKING_RULE_ID from MTL_PICKING_RULES.
RESERVABLE_TYPE	RESERVABLE_ TYPE	Derives the LOOKUP_CODE from MFG_LOOKUPS for LOOKUP_TYPE. MTL_RESERVATION_CONTROL.
POSITIVE_MEASUREMENT_ ERROR	POSITIVE_ MEASUREMENT_ ERROR	Percent error above measured quantity.
NEGATIVE_MEASUREMENT_ ERROR	NEGATIVE_ MEASUREMENT_ ERROR	Percent error below measured quantity.
ENGINEERING_ECN_CODE	ENGINEERING_ ECN_CODE	Engineering Change code.
ENGINEERING_ITEM	ENGINEERING_ ITEM_ID	Derives ITEM_ID from MTL_SYSTEM_ITEMS_B_KFV for the concatenated segment.
ENGINEERING_DATE	ENGINEERING_ DATE
SERVICE_STARTING_DATE	SERVICE_ START_DATE	For inbound transactions only.
SERVICE_STARTING_DELAY	SERVICE_ STARTING_ DELAY	Days after shipment that service begins.
VENDOR_WARRANTY_FLAG	VENDOR_ WARRANTY_ FLAG
SERVICEABLE_COMPONENT_ FLAG	SERVICEABLE_ COMPONENT_ FLAG	*
SERVICEABLE_PRODUCT_ FLAG	SERVICEABLE_ PRODUCT_FLAG
BASE_WARRANTY_SERVICE_ ITEM	BASE_ WARRANTY_ SERVICE_ID	Derives ITEM_ID from MTL_SYSTEM_ITEMS_B_KFV for the concatenated segment and organization.
PAYMENT_TERMS_NAME	PAYMENT_ TERM_ID	Derives PAYMENT_TERM_ID from RA_TERMS_B.
PREVENTATIVE_ MAINTENANCE_FLAG	PREVENTATIVE_ MAINTENANCE_ FLAG
PRIMARY_SPECIALIST_ FULL_NAME	PRIMARY_ SPECIALIST_ID	Derives PERSON_ID from PER_ALL_PEOPLE_F for the active record.
SECONDARY_SPECIALIST_ FULL_NAME	SECONDARY_ SPECIALIST_ID	Derives PERSON_ID from PER_ALL_PEOPLE_F for the active record.
SERVICEABLE_ITEM_CLASS_ NAME	SERVICEABLE_ ITEM_CLASS_ID	Derives SERVICEABLE_ITEM_CLASS_ID from CS_SERVICEABLE_ITEM_CLASSES for the Class Name.
TIME_BILLABLE_FLAG	TIME_ BILLABLE_FLAG	Indicates whether service hours are billable.
MATERIAL_BILLABLE_FLAG	MATERIAL_ BILLABLE_FLAG	Indicates whether service items are billable.
EXPENSE_BILLABLE_FLAG	EXPENSE_ BILLABLE_FLAG	Indicates whether service expenses are billable.
PRORATE_SERVICE_FLAG	PRORATE_ SERVICE_FLAG	Indicates whether cost of service may be prorated.
COVERAGE_SCHEDULE_NAME	COVERAGE_ SCHEDULE_ID	Derives COVERAGE_SCHEDULE_ID from CS_COVERAGE_SCHEDULES for the Name.
SERVICE_DURATION_PERIOD_ CODE	SERVICE_ DURATION_ PERIOD_CODE
SERVICE_DURATION	SERVICE_ DURATION	Default service duration.
WARRANTY_VENDOR_NAME	WARRANTY_ VENDOR_ID	Derives VENDOR_ID from AP_SUPPLIERS for the Vendor Name.
MAX_WARRANTY_AMOUNT	MAX_WARRANTY_ AMOUNT	Maximum warranty amount.
RESPONSE_TIME_PERIOD_ CODE	RESPONSE_ TIME_PERIOD_ CODE
RESPONSE_TIME_VALUE	RESPONSE_ TIME_VALUE
NEW_REVISION_CODE	NEW_ REVISION_ CODE	Indicates how to inform customers in case of revisions.
INVOICEABLE_ITEM_FLAG	INVOICEABLE_ ITEM_FLAG	Required.
INVOICE_ENABLED_FLAG	INVOICE_ ENABLED_FLAG	Required.
MUST_USE_APPROVED_ VENDOR_FLAG	MUST_USE_ APPROVED_ VENDOR_FLAG	Required. Indicates whether purchases are restricted to approved supplier.
OUTSIDE_OPERATION_FLAG	OUTSIDE_ OPERATION_ FLAG	Required.
OUTSIDE_OPERATION_ UOM_TYPE	OUTSIDE_ OPERATION_ UOM_TYPE	Outside operation unit of measure.
SAFETY_STOCK_BUCKET_DAYS	SAFETY_ STOCK_BUCKET_ DAYS
AUTO_REDUCE_MPS	AUTO_ REDUCE_MPS	Automatically deletes MPS entries in a period.
COSTING_ENABLED_FLAG	COSTING_ ENABLED_ FLAG	Required.
CYCLE_COUNT_ENABLED_ FLAG	CYCLE_COUNT_ ENABLED_FLAG	Required. Indicates whether item may be cycle counted.
DEMAND_SOURCE_LINE	DEMAND_ SOURCE_LINE	For inbound transactions only.
COPY_ITEM_NUMBER	COPY_ITEM_ID	Derives ITEM_ID from MTL_SYSTEM_ITEMS_B_KFV for the concatenated segment. For inbound transactions only.
SET_ID	SET_ID	Set identifier used for ATO. For inbound transactions only.
REVISION	REVISION	Item revision.
AUTO_CREATED_CONFIG_ FLAG	AUTO_CREATED_ CONFIG_FLAG	Required. Indicates whether configuration item is automatically created.
ITEM_TYPE	ITEM_TYPE	User-defined item type. Derives LOOKUP_CODE from FND_COMMON_LOOKUPS where LOOKUP_TYPE = ITEM_TYPE for the meaning.
MODEL_CONFIG_CLAUSE_ NAME	MODEL_CONFIG_ CLAUSE_NAME	Model configuration clause name.
SHIP_MODEL_COMPLETE_ FLAG	SHIP_MODEL_ COMPLETE_FLAG	Indicates whether model must be complete to ship.
MRP_PLANNING	MRP_ PLANNING_ CODE	Derived from MFG_LOOKUPS where LOOKUP_TYPE = MRP_PLANNING_CODE for the meaning column.
RETURN_INSPECTION_ REQUIREMENT	RETURN_ INSPECTION_ REQUIREMENT	RMA inspection requirement. Derived from MFG_LOOKUPS where LOOKUP_TYPE = MTL_RETURN_INSPECTION.
DEMAND_SOURCE_TYPE	DEMAND_ SOURCE_TYPE	Derives TRANSACTION_ SOURCE_TYPE_ID from MTL_TXN_ SOURCE_TYPES for TRANSACTION_ SOURCE_TYPE_NAME. For inbound transactions only.
DEMAND_SOURCE_HEADER_ ID	DEMAND_ SOURCE_ HEADER_ID
TEMPLATE_NAME	TEMPLATE_NAME	Item template name. For inbound transactions only.
COPY_ORGANIZATION_NAME	COPY_ ORGANIZATION_ ID	Derives ORGANIZATION_ID from ORG_ORGANIZATION_ DEFINITIONS. For inbound transactions only.
ATO_FORECAST_CONTROL	ATO_ FORECAST_ CONTROL	Type of forecast control for ATO. Derived from MFG_LOOKUPS where LOOKUP_TYPE = MRP_ATO_ FORECAST_CONTROL for the meaning column.
TRANSACTION_TYPE	TRANSACTION_TYPE	Either CREATE or UPDATE. Item cost cannot be updated using the UPDATE mode in this interface. For inbound transactions only.
MATERIAL_COST	MATERIAL_COST	For inbound transactions only.
MATERIAL_SUB_ELEMENT	MATERIAL_ SUB_ELEMENT	For inbound transactions only.
MATERIAL_OH_RATE	MATERIAL_ OH_RATE	Material overhead rate. For inbound transaction only.
MATERIAL_OH_SUB_ELEMENT	MATERIAL_ OH_SUB_ ELEMENT	Material overhead sub element. For inbound transaction only.
CONTAINER_ITEM_FLAG	CONTAINER_ ITEM_FLAG	Indicates whether the item is a container. For shipping sales orders.
VEHICLE_ITEM_FLAG	VEHICLE_ ITEM_FLAG	Indicates whether the item is a vehicle. For shipping sales orders.
MAXIMUM_LOAD_WEIGHT	MAXIMUM_ LOAD_WEIGHT	Maximum load weight of a container or a vehicle that can be used for shipping sales orders.
MINIMUM_FILL_PERCENT	MINIMUM_ FILL_PERCENT	Minimum fill condition under which the container or vehicle should be used.
CONTAINER_TYPE_CODE	CONTAINER_ TYPE_CODE	User-defined container type code for container items.
INTERNAL_VOLUME	INTERNAL_VOLUME	Internal volume for container items used by shipping to calculate container capacity restrictions.
CHECK_SHORTAGES_FLAG	CHECK_ SHORTAGES_ FLAG	Indicates whether material shortages should be checked (Y/N).
RELEASE_TIME_FENCE_CODE	RELEASE_ TIME_ FENCE_CODE	Indicates whether this item is auto releasable by MRP. Derives LOOKUP_CODE from MFG_LOOKUPS where LOOKUP_TYPE is MTL_RELEASE_TIME_FENCE.
RELEASE_TIME_FENCE_DAYS	RELEASE_ TIME_ FENCE_DAYS	Number of days that this item should be automatically released.
WH_UPDATE_DATE	WH_UPDATE_DATE	Warehouse update date for tracking changes relevant to data collected in the data warehouse.
PRODUCT_FAMILY_ITEM	PRODUCT_ FAMILY_ ITEM_ID	Derives ITEM_ID from MTL_SYSTEM_ ITEMS_B_KFV for the concatenated segment.
PURCHASING_TAX_CODE	PURCHASING_ TAX_CODE
OVERCOMPLETION_TOLER ANCE_TYPE	OVERCOMPLETION_ TOLERANCE_ TYPE	Derives LOOKUP_CODE from MFG_LOOKUPS, where LOOKUP_TYPE is WIP_TOLERANCE_TYPE.
OVERCOMPLETION_TOLER ANCE_VALUE	OVERCOMPLETION_ TOLERANCE_ VALUE
EFFECTIVITY_CONTROL	EFFECTIVITY_ CONTROL	Derives LOOKUP_CODE from MFG_LOOKUPS, where LOOKUP_TYPE is MTL_EFFECTIVITY_CONTROL.
OVER_SHIPMENT_ TOLERANCE	OVER_ SHIPMENT_ TOLERANCE
UNDER_SHIPMENT_ TOLERANCE	UNDER_ SHIPMENT_ TOLERANCE
OVER_RETURN_TOLERANCE	OVER_RETURN_ TOLERANCE
UNDER_RETURN_TOLERANCE	UNDER_RETURN_ TOLERANCE
EQUIPMENT_TYPE	EQUIPMENT_ TYPE	Use: 1 for Yes. 2 for No.
RECOVERED_PART_DISP_CODE	RECOVERED_ PART_DISP_ CODE	Indicates that return is required for recovered parts, scrap in field, which is used for spare Parts.
DEFECT_TRACKING_ON_FLAG	DEFECT_ TRACKING_ ON_FLAG	Indicates whether a defect or bug can be filed against the product.
USAGE_ITEM_FLAG	USAGE_ITEM_FLAG
EVENT_FLAG	EVENT_FLAG	Indicates whether item is to be treated as an event.
ELECTRONIC_FLAG	ELECTRONIC_ FLAG	Indicates whether an item exists only in electronic format.
DOWNLOADABLE_FLAG	DOWNLOADABLE_ FLAG
VOL_DISCOUNT_EXEMPT_ FLAG	VOL_DISCOUNT_ EXEMPT_FLAG	Indicates whether an item does not contribute to volume discount for any order.
COUPON_EXEMPT_FLAG	COUPON_EXEMPT_ FLAG	Indicates whether an item is excluded from coupons.
COMMS_NL_TRACKABLE_ FLAG	COMMS_NL_ TRACKABLE_FLAG	Indicates whether network logistics can be tracked.
ASSET_CREATION_CODE	ASSET_CREATION_ CODE
COMMS_ACTIVATION_REQD_ FLAG	COMMS_ ACTIVATION_ REQD_FLAG	Indicates whether network activation is required.
ORDERABLE_ON_WEB_FLAG	ORDERABLE_ ON_WEB_FLAG
BACK_ORDERABLE_FLAG	BACK_ ORDERABLE_ FLAG	If ATP failed, can item be back ordered.
WEB_STATUS	WEB_STATUS
INDIVISIBLE_FLAG	INDIVISIBLE_FLAG	Item cannot be separated.
DIMENSION_UOM_CODE	DIMENSION_ UOM_CODE	Dimension unit of measure code.
UNIT_LENGTH	UNIT_LENGTH
UNIT_WIDTH	UNIT_WIDTH
UNIT_HEIGHT	UNIT_HEIGHT
BULK_PICKED_FLAG	BULK_PICKED_FLAG
LOT_STATUS_ENABLED	LOT_STATUS_ ENABLED
LOT_TRANSLATE_ENABLED	LOT_TRANSLATE_ ENABLED	Indicates whether Lot Translate is enabled. (This can be enabled only if LOT_CONTROL is Full lot control.)
DEFAULT_SO_SOURCE_TYPE	DEFAULT_SO_ SOURCE_TYPE	Default Sales Order source type. (External/ Internal) If an item is not purchasable, this field cannot be External. Set PURCHASING_ITEM_FLAG and PURCHASING_ENABLED_FLAG to Y for this field to be External.
CREATE_SUPPLY_FLAG	CREATE_SUPPLY_ FLAG	Create supply flag.
SUBSTITUTION_WINDOW_ CODE	SUBSTITUTION_ WINDOW_CODE	Substitution window code. Use: 1 for Cumulative Total Lead Time. 2 for Cumulative Mfg Lead Time. 3 for Total Lead Time. 4 for User Defined.
SUBSTITUTION_WINDOW_ DAYS	SUBSTITUTION_ WINDOW_DAYS	Substitution window days.
CONFIG_MODEL_TYPE	CONFIG_MODEL_ TYPE	Configurator model type. Use: N for Container. Null for Standard. This field can be non- standard only if: BOM_ITEM_TYPE is Model and Orderable flag (CUSTOMER_ORDERED and CUSTOMER_ORDERS_ ENABLED flags in Order Management Tab) is Yes, and PICK_COMPONENTS_FLAG is Yes.
LOT_SUBSTITUTION_FLAG	LOT_ SUBSTITUTION_ FLAG	Lot substitution flag. This field can be enabled only if LOT_CONTROL is Full lot control.
MINIMUM_LICENSE_ QUANTITY	MINIMUM_ LICENSE_ QUANTITY	Minimum license quantity.

1.1 MTL_ITEM_CATEGORIES (Maps to MTL_ITEM_CATEGORIES_INTERFACE)

Field Name	Maps to Column	Description
CATEGORY_SET_NAME	CATEGORY_SET_NAME
CATEGORY_NAME	CATEGORY_NAME	Required. Concatenated Category Name.
TRANSACTION_TYPE	TRANSACTION_TYPE	Use CREATE or DELETE. If you select DELETE, you must also CREATE. For inbound transactions only.

1.2 MTL_ITEM_REVISIONS (Maps to MTL_ITEM_REVISIONS_INTERFACE)

Field Name	Maps to Column	Description
REVISION	REVISION	Item revision code.
TRANSACTION_TYPE	TRANSACTION_TYPE	Must be CREATE. For inbound transactions only.
CHANGE_NOTICE	CHANGE_NOTICE
ECN_INITIATION_DATE	ECN_INITIATION_DATE	Engineering Change Initiation Date.
IMPLEMENTATION_DATE	IMPLEMENTATION_DATE
IMPLEMENTED_ SERIAL_NUMBER	IMPLEMENTED_ SERIAL_NUMBER
EFFECTIVITY_DATE	EFFECTIVITY_DATE
REVISED_ITEM_ SEQUENCE_ID	REVISED_ITEM_ SEQUENCE_ID	Identifies multiple occurrences of the same item on an engineering change order.
DESCRIPTION	DESCRIPTION	Item revision description.