Search Results ego_aml_intf




Overview
Explore in AI Chat

Overview

EGO_AML_INTF is a table in the EGO schema (Advanced Product Catalog module) of Oracle E-Business Suite. It serves as a staging and interface table for AML (Approved Manufacturer List) records. In EBS, AML functionality associates approved manufacturers and their part numbers with inventory items, supporting procurement, sourcing, and item definition processes. This interface table is the transient landing area where AML data from external sources or feeder processes is collected before validation and import into the base AML tables.

From a Data Vault modeling perspective, the heuristic classification of this object is standalone. Mined from its foreign key structure, the table is not tightly bound to a parent hub through a single mandatory FK chain; it references MTL_MANUFACTURERS via MANUFACTURER_ID but otherwise operates as an independent staging entity. This classification should be treated as a modeling suggestion rather than a definitive construct, since interface tables frequently blend hub-like key references with satellite-like descriptive attributes.

Key Information Stored

The table contains 55 documented columns in ETRM 12.2.2. The most operationally significant columns are:

Common Use Cases and Queries

Typical usage centers on monitoring, troubleshooting, and reconciling AML loads. Analysts query pending records before the import program runs, and audit records after a failure.

To inspect rows awaiting processing for a given request:

  • SELECT transaction_id, item_number, manufacturer_name, mfg_part_num, process_flag FROM ego.ego_aml_intf WHERE request_id = :req AND process_flag IS NULL;

To trace a specific item's AML staging data:

  • SELECT transaction_id, organization_code, inventory_item_id, manufacturer_id, approval_status FROM ego.ego_aml_intf WHERE inventory_item_id = :item_id;

To reconcile interface rows against the base manufacturer table by join key:

  • SELECT i.transaction_id, i.manufacturer_id, m.manufacturer_name FROM ego.ego_aml_intf i, mtl_manufacturers m WHERE i.manufacturer_id = m.manufacturer_id;

Related Objects

The documented FK structure ties EGO_AML_INTF directly to a small set of masters. The most significant related objects include:

  • MTL_MANUFACTURERS — Referenced via MANUFACTURER_ID; the primary manufacturer master validating AML entries.
  • EGO_AML_INTF_U1 — Unique index on TRANSACTION_ID ensuring transaction uniqueness.
  • MTL_SYSTEM_ITEMS_B — Provides INVENTORY_ITEM_ID and ITEM_NUMBER context for the target item.
  • MTL_PARAMETERS / ORG_ORGANIZATION_DEFINITIONS — Supply ORGANIZATION_ID and ORGANIZATION_CODE resolution.
  • EGO_ITEM_AML_INTF / AML import concurrent programs — Consume interface rows and load validated records into the base AML tables.
  • FND_CONCURRENT_REQUESTS — Joined on REQUEST_ID to associate rows with the driving concurrent request.

Because the table is transient by design, its row population is typically purged after successful import, making it most relevant to integration, migration, and diagnostic reporting scenarios.