Search Results mtl_cross_references
The MTL_CROSS_REFERENCES table in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 is a critical inventory and item master repository that stores cross-referencing information between internal item identifiers and external reference data. This table facilitates seamless integration with third-party systems, trading partners, and legacy applications by maintaining mappings between Oracle Inventory item codes and external identifiers such as customer part numbers, supplier part numbers, or industry-standard codes (e.g., UPC, EAN). Below is a detailed technical and functional analysis of this table.
1. Purpose and Functional Role
The MTL_CROSS_REFERENCES table serves as a bridge between Oracle Inventory items and external systems. Key use cases include:- Customer/Supplier Item Mapping: Links Oracle items to customer-specific or supplier-specific part numbers, enabling streamlined procurement and order fulfillment.
- Legacy System Integration: Maintains compatibility with pre-existing identifiers during ERP migrations.
- Regulatory Compliance: Stores industry-standard identifiers (e.g., GTIN, ISBN) for compliance with labeling or reporting requirements.
2. Key Columns and Structure
The table's schema includes the following critical columns:- CROSS_REFERENCE_ID: Primary key, uniquely identifying each cross-reference record.
- INVENTORY_ITEM_ID: Foreign key to MTL_SYSTEM_ITEMS_B, linking to the Oracle item.
- ORGANIZATION_ID: Specifies the inventory organization context.
- CROSS_REFERENCE_TYPE: Categorizes the reference (e.g., 'CUSTOMER', 'SUPPLIER', 'UPC').
- CROSS_REFERENCE: The external identifier (e.g., customer part number).
- STATUS: Indicates record validity (e.g., 'ACTIVE', 'INACTIVE').
3. Integration Points
The table interacts with multiple EBS modules:- Order Management (OM): Auto-resolves customer items to Oracle items during sales order entry.
- Purchasing (PO): Maps supplier part numbers to internal items for purchase orders.
- Advanced Pricing: Supports price adjustments based on customer-specific item codes.
4. Technical Considerations
- Indexes: Key indexes include MTL_CROSS_REFERENCES_U1 (primary key) and MTL_CROSS_REFERENCES_N1 (on INVENTORY_ITEM_ID, ORGANIZATION_ID).
- APIs: The INV_ITEM_CROSS_REFERENCE_PUB package provides CRUD operations for programmatic access.
- Performance: High-volume environments may require partitioning or periodic archiving of obsolete records.
5. Customization and Extensions
Common enhancements include:- Adding custom cross-reference types via lookup INV_CROSS_REFERENCE_TYPES.
- Implementing triggers to synchronize changes with external systems.
- Extending the table via descriptive flexfields (DFFs) for additional attributes.
6. Data Flow Example
A typical workflow involves:- A customer submits an order with their part number (CROSS_REFERENCE).
- Oracle queries MTL_CROSS_REFERENCES to resolve the part number to an INVENTORY_ITEM_ID.
- The system processes the order using the internal item code.
7. Version-Specific Notes
Differences between 12.1.1 and 12.2.2 are minimal, though 12.2.2 may offer improved indexing strategies and tighter integration with Oracle Fusion Middleware for real-time cross-reference validation.Conclusion
The MTL_CROSS_REFERENCES table is a linchpin in Oracle EBS for multi-identifier management, ensuring interoperability across supply chains. Proper configuration and maintenance of this table are essential for accurate order processing, procurement, and compliance in global deployments.-
Table: MTL_CROSS_REFERENCES
12.1.1
product: INV - Inventory , description: Assign cross references to items , implementation_dba_data: Not implemented in this database ,
-
Table: MTL_CROSS_REFERENCES
12.2.2
product: INV - Inventory , description: Assign cross references to items , implementation_dba_data: Not implemented in this database ,
-
APPS.OE_OE_FORM_LINE dependencies on MTL_CROSS_REFERENCES
12.1.1
-
APPS.ONT_OEXCRDIS_XMLP_PKG dependencies on MTL_CROSS_REFERENCES
12.1.1
-
APPS.INV_UI_RCV_LOVS dependencies on MTL_CROSS_REFERENCES
12.1.1
-
APPS.ONT_OEXIODIS_XMLP_PKG dependencies on MTL_CROSS_REFERENCES
12.1.1
-
APPS.GMI_MSCA_PUB dependencies on MTL_CROSS_REFERENCES
12.1.1
-
APPS.WMS_RFID_DEVICE_PUB dependencies on MTL_CROSS_REFERENCES
12.1.1
-
APPS.OE_ORDER_IMPORT_SPECIFIC_PVT dependencies on MTL_CROSS_REFERENCES
12.1.1
-
APPS.WMS_TASK_DISPATCH_LOV dependencies on MTL_CROSS_REFERENCES
12.1.1
-
APPS.EGO_ITEM_WS_PVT dependencies on MTL_CROSS_REFERENCES
12.2.2
-
APPS.GME_MOBILE_LOVS dependencies on MTL_CROSS_REFERENCES
12.2.2
-
APPS.WMS_UCC_128_PVT dependencies on MTL_CROSS_REFERENCES
12.2.2
-
APPS.ONT_OEXOEIOD_XMLP_PKG dependencies on MTL_CROSS_REFERENCES
12.2.2
-
APPS.OE_ORDER_IMPORT_SPECIFIC_PVT dependencies on MTL_CROSS_REFERENCES
12.2.2
-
APPS.OE_BLANKET_UTIL dependencies on MTL_CROSS_REFERENCES
12.2.2
-
APPS.OE_CNCL_VALIDATE_LINE dependencies on MTL_CROSS_REFERENCES
12.2.2
-
APPS.ONT_OEXOEORR_XMLP_PKG dependencies on MTL_CROSS_REFERENCES
12.2.2
-
APPS.ONT_OEXOEOCR_XMLP_PKG dependencies on MTL_CROSS_REFERENCES
12.2.2
-
APPS.INV_UI_ITEM_LOVS dependencies on MTL_CROSS_REFERENCES
12.2.2
-
APPS.WMS_PICK_DROP_PVT dependencies on MTL_CROSS_REFERENCES
12.1.1
-
APPS.JMF_GTA_ARTRX_PROC dependencies on MTL_CROSS_REFERENCES
12.1.1
-
APPS.OE_INVOICE_PUB dependencies on MTL_CROSS_REFERENCES
12.1.1
-
APPS.GML_MOBILE_SHIP_CONFIRM dependencies on MTL_CROSS_REFERENCES
12.1.1
-
APPS.JMF_GTA_TXT_OPERATOR_PROC dependencies on MTL_CROSS_REFERENCES
12.1.1
-
APPS.EGO_IMPORT_PVT dependencies on MTL_CROSS_REFERENCES
12.1.1
-
APPS.ONT_OEXOEORD_XMLP_PKG dependencies on MTL_CROSS_REFERENCES
12.1.1
-
APPS.ONT_OEXOECOD_XMLP_PKG dependencies on MTL_CROSS_REFERENCES
12.1.1
-
APPS.MSC_X_VMI_POREQ dependencies on MTL_CROSS_REFERENCES
12.1.1
-
APPS.GML_MOBILE_RECEIPT dependencies on MTL_CROSS_REFERENCES
12.1.1
-
APPS.ECEPOI dependencies on MTL_CROSS_REFERENCES
12.2.2
-
APPS.INV_LABEL dependencies on MTL_CROSS_REFERENCES
12.2.2
-
APPS.ONT_OEXOECCL_XMLP_PKG dependencies on MTL_CROSS_REFERENCES
12.2.2
-
APPS.WMS_PICK_DROP_PVT dependencies on MTL_CROSS_REFERENCES
12.2.2
-
APPS.ONT_OEXOEOCS_XMLP_PKG dependencies on MTL_CROSS_REFERENCES
12.2.2
-
APPS.WMS_RFID_DEVICE_PUB dependencies on MTL_CROSS_REFERENCES
12.2.2
-
APPS.WMS_TASK_DISPATCH_LOV dependencies on MTL_CROSS_REFERENCES
12.2.2
-
APPS.ONT_OEXOHOHS_XMLP_PKG dependencies on MTL_CROSS_REFERENCES
12.2.2
-
APPS.MSC_X_VMI_POREQ dependencies on MTL_CROSS_REFERENCES
12.2.2
-
APPS.ONT_OEXPRPRD_XMLP_PKG dependencies on MTL_CROSS_REFERENCES
12.2.2
-
APPS.OE_ID_TO_VALUE dependencies on MTL_CROSS_REFERENCES
12.1.1
-
APPS.OE_BULK_PROCESS_LINE dependencies on MTL_CROSS_REFERENCES
12.1.1
-
APPS.ONT_OEXOEORR_XMLP_PKG dependencies on MTL_CROSS_REFERENCES
12.1.1
-
APPS.GME_MOBILE_LOVS dependencies on MTL_CROSS_REFERENCES
12.1.1
-
APPS.ONT_OEXOEOCS_XMLP_PKG dependencies on MTL_CROSS_REFERENCES
12.1.1
-
APPS.INV_RCV_COMMON_APIS dependencies on MTL_CROSS_REFERENCES
12.1.1
-
APPS.ONT_OEXOEIOD_XMLP_PKG dependencies on MTL_CROSS_REFERENCES
12.1.1
-
APPS.WSH_ECE_VIEWS_DEF dependencies on MTL_CROSS_REFERENCES
12.1.1
-
APPS.EGO_GTIN_PVT dependencies on MTL_CROSS_REFERENCES
12.1.1
-
APPS.INVPPRCI dependencies on MTL_CROSS_REFERENCES
12.1.1