Results for “as_imp_lines_interface_pk”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AS_IMP_LINES_INTERFACE is a Sales Foundation (AS) interface table owned by the OSM schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It serves as the staging area for lead line information awaiting import into the Oracle Sales and Telesales application. Two-tier import architectures are common in EBS: a header-level staging record is created first in AS_IMPORT_INTERFACE, and the corresponding line-level detail is written to AS_IMP_LINES_INTERFACE. This table therefore holds the granular product, interest, quantity, and promotional attributes of each lead line before a concurrent program validates and promotes the data into the permanent lead tables.

The table is registered as VALID with a documented physical schema of 23 columns. Its primary key is AS_IMP_LINES_INTERFACE_PK, defined on the surrogate column IMP_LINES_INTERFACE_ID, which is reinforced by the unique index AS_IMP_LINES_INTERFACE_U1. From a Data Vault modeling perspective, the metadata classifies this object as satellite-leaning: it carries descriptive, versionable attributes keyed by the parent import header, rather than acting as a pure hub or link. The relationship to AS_IMPORT_INTERFACE through IMPORT_INTERFACE_ID supports this interpretation.

Key Information Stored

The most significant columns fall into four groups.

• Primary key: IMP_LINES_INTERFACE_ID is the surrogate identifier that uniquely identifies each staged lead line and is the column referenced by the unique index AS_IMP_LINES_INTERFACE_U1.
• Parent reference: IMPORT_INTERFACE_ID is the foreign key to AS_IMPORT_INTERFACE, associating each line with its import header record.
• Business attributes: INTEREST_TYPE_ID, PRIMARY_INTEREST_CODE_ID, and SECONDARY_INTEREST_CODE_ID capture the prospect's expressed interest classifications. INVENTORY_ITEM_ID, ORGANIZATION_ID, UOM_CODE, and QUANTITY describe the product or item of interest at the line level. BUDGET_AMOUNT records the anticipated spend. SOURCE_PROMOTION_ID, OFFER_ID, and CATEGORY_ID link the line to marketing and categorization context.
• Audit and concurrency columns: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN follow the standard EBS WHO column convention, while REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE identify the concurrent request that populated the row. SECURITY_GROUP_ID supports multi-org data isolation.

Common Use Cases and Queries

The primary use case is monitoring and troubleshooting the lead import process. Support and technical teams query this table to confirm that lines were staged correctly before the import concurrent program runs, and to diagnose rows that failed validation.

• Count staged lines per import header: SELECT IMPORT_INTERFACE_ID, COUNT(*) FROM AS_IMP_LINES_INTERFACE GROUP BY IMPORT_INTERFACE_ID;
• Retrieve line detail for a specific import: SELECT * FROM AS_IMP_LINES_INTERFACE WHERE IMPORT_INTERFACE_ID = :p_import_id;
• Trace the loading program: SELECT IMP_LINES_INTERFACE_ID, REQUEST_ID, PROGRAM_ID, LAST_UPDATE_DATE FROM AS_IMP_LINES_INTERFACE WHERE REQUEST_ID = :p_request_id;
• Join to the header for reporting: SELECT l.IMP_LINES_INTERFACE_ID, h.IMPORT_INTERFACE_ID FROM AS_IMP_LINES_INTERFACE l, AS_IMPORT_INTERFACE h WHERE l.IMPORT_INTERFACE_ID = h.IMPORT_INTERFACE_ID;

Reporting use cases include reconciliation of imported lead volumes by promotion or offer, analysis of budgeted amounts by interest type, and auditing which concurrent request created or modified each line.

Related Objects

• AS_IMPORT_INTERFACE — parent header table; joined via AS_IMP_LINES_INTERFACE.IMPORT_INTERFACE_ID = AS_IMPORT_INTERFACE.IMPORT_INTERFACE_ID.
• AS_INTEREST_TYPES_B — reference table for interest types; joined via INTEREST_TYPE_ID.
• FND_SECURITY_GROUPS — security group reference; joined via SECURITY_GROUP_ID.
• AS_IMP_LINES_INTERFACE_PK / AS_IMP_LINES_INTERFACE_U1 — the primary key constraint and unique index on IMP_LINES_INTERFACE_ID.
• Lead import concurrent programs — the programs identified by PROGRAM_ID load and consume rows in this table.