Search Results import_scope_code

Overview

MTL_EAM_ASSET_NUM_INTERFACE_V is an APPS-owned interface view in the Oracle E-Business Suite Inventory (INV) module, classified as the "Asset Number Interface View." It exposes the staged rows of the Enterprise Asset Management (EAM) asset number import process, denormalizing the raw interface table MTL_EAM_ASSET_NUM_INTERFACE and resolving internal identifiers into human-readable meanings and codes. The view is central to the EAM asset number import lifecycle: external systems, third-party maintenance applications, or data conversion scripts populate the underlying interface table, oracle's concurrent import program validates and processes those rows, and reporting and troubleshooting are performed against this view.

The view is valid in both 12.1.1 and 12.2.2. Its most notable characteristic is the dual-encoding of criticality: it exposes both the surrogate key ASSET_CRITICALITY_ID and a derived ASSET_CRITICALITY_CODE, which is the column most commonly searched by users working with asset imports. The view also carries error diagnostics (ERROR_CODE, ERROR_MESSAGE) so that failed interface rows can be identified without querying the base table directly.

Underlying Base Objects

Per the ETRM metadata, the view is defined over the following documented objects:

• MTL_EAM_ASSET_NUM_INTERFACE (synonym) — the primary driving interface table containing all staged asset number rows and the bulk of the exposed columns.
• MFG_LOOKUPS (view) — joined multiple times to translate lookup codes into meanings for PROCESS_FLAG, ASSET_CRITICALITY_CODE, IMPORT_MODE, and IMPORT_SCOPE.
• PN_LOCATIONS_ALL (synonym) — supplies PN_LOCATION_NAME (LOCATION_ALIAS) and PN_LOCATION_CODE for the property-management location.
• MTL_EAM_LOCATIONS (synonym) — supplies LOCATION_CODES when the EAM location is populated.
• MTL_PARAMETERS (synonym) — provides the default ORGANIZATION_CODE fallback for the current organization.
• BOM_DEPARTMENTS (synonym) — resolves OWNING_DEPARTMENT_ID to OWNING_DEPARTMENT_CODE.
• EAM_COMMON_UTILITIES_PVT (package) — utility package referenced in the view definition for EAM common processing logic.

The view therefore serves as a consolidated, decoded presentation layer sitting directly on top of the EAM asset number staging area.

Key Columns

• INTERFACE_GROUP_ID / INTERFACE_HEADER_ID / BATCH_ID / BATCH_NAME — identify the import batch and group context for each staged row.
• PROCESS_FLAG / PROCESS_FLAG_CODE — the staging status raw value paired with its lookup meaning (for example, pending, processed, or errored).
• INVENTORY_ITEM_ID / SERIAL_NUMBER / INSTANCE_NUMBER — the item and serial identity of the asset being imported.
• ASSET_CRITICALITY_ID / ASSET_CRITICALITY_CODE — the criticality key and its resolved meaning; the view DECODEs the code only when the ID is null, otherwise using the MFG_LOOKUPS meaning.
• PARENT_INVENTORY_ITEM_ID / PARENT_SERIAL_NUMBER / PARENT_INSTANCE_NUMBER — parent asset hierarchy for the imported asset.
• CURRENT_ORGANIZATION_ID / ORGANIZATION_CODE — owning inventory organization, falling back to MTL_PARAMETERS when the interface row carries no code.
• CURRENT_STATUS / MAINTAINABLE_FLAG / NETWORK_ASSET_FLAG / CHECKIN_STATUS / OPERATIONAL_LOG_FLAG — EAM asset attributes applied during import.
• EAM_LOCATION_ID / LOCATION_CODES / PN_LOCATION_ID / PN_LOCATION_NAME / PN_LOCATION_CODE — asset and property location information.
• FA_ASSET_ID / FA_ASSET_NUMBER — linkage to Oracle Assets for capitalized equipment.
• OWNING_DEPARTMENT_ID / OWNING_DEPARTMENT_CODE — department assignment resolved through BOM_DEPARTMENTS.
• IMPORT_MODE / IMPORT_SCOPE — raw values with IMPORT_MODE_CODE and IMPORT_SCOPE_CODE meanings controlling how the import behaves.
• ERROR_CODE / ERROR_MESSAGE — validation failure diagnostics for rejected rows.
• ACTIVE_START_DATE / ACTIVE_END_DATE / SUPPLIER_WARRANTY_EXP_DATE — asset lifecycle and warranty dates.

Common Use Cases and Queries

Typical uses include monitoring import batch progress, reconciling converted asset loads, and diagnosing rows rejected by validation, particularly around criticality values.

• List pending assets in a batch:

SELECT interface_header_id, serial_number, asset_criticality_code, process_flag_code
FROM   apps.mtl_eam_asset_num_interface_v
WHERE  batch_id = :batch_id
AND    process_flag_code = 'PENDING';

• Find rows with criticality populated:

SELECT interface_header_id, inventory_item_id, serial_number,
       asset_criticality_id, asset_criticality_code
FROM   apps.mtl_eam_asset_num_interface_v
WHERE  asset_criticality_code IS NOT NULL;

• Identify errored interface rows:

SELECT interface_header_id, serial_number, error_code, error_message
FROM   apps.mtl_eam_asset_num_interface_v
WHERE  error_code IS NOT NULL;

Because the view performs the lookup translations, queries against it are read-only and should not be used for updating interface rows; corrections are made against MTL_EAM_ASSET_NUM_INTERFACE before reprocessing.