Search Results pon_auc_attributes_interface

Overview

The PON_AUC_ATTRIBUTES_INTERFACE table is a temporary staging table within the Oracle E-Business Suite Sourcing (PON) module. Its documented purpose is to hold attribute details that have been imported from, or exported to, Microsoft Excel during auction and sourcing event configuration. In EBS 12.1.1 and 12.2.2, this table functions as an intermediate buffer between the file-based spreadsheet interface used by sourcing managers and the application's transactional attribute structures, allowing bulk upload and download of line-level attribute definitions, response types, scoring parameters, and grouping information.

Because the table is a transient interface construct rather than a permanent business entity, the Data Vault classification mined from its foreign key structure is standalone. This suggests modeling the object as an isolated staging artifact rather than integrating it into a hub, link, or satellite pattern in a data warehouse. Its single documented foreign key—AUCTION_HEADER_ID referencing PON_AUCTION_HEADERS_ALL—anchors each interface row to a specific auction, but the table itself carries no downstream dependents.

Key Information Stored

The table is documented with 28 columns. The most significant are:

INTERFACE_LINE_ID — the surrogate primary key uniquely identifying each interface row.
AUCTION_HEADER_ID — the foreign key linking the record to its parent auction in PON_AUCTION_HEADERS_ALL; a primary business-key candidate.
AUCTION_LINE_NUMBER and SEQUENCE_NUMBER — business identifiers locating the attribute within the auction's line structure.
ATTRIBUTE_NAME — the descriptive name of the sourcing attribute being imported or exported.
DATATYPE and RESPONSE_TYPE/RESPONSE_TYPE_NAME — define the expected data format and supplier response mechanism.
MANDATORY_FLAG, DISPLAY_ONLY_FLAG, DISPLAY_TARGET_FLAG — control visibility and required-entry behavior.
VALUE — the actual attribute value carried through the interface.
GROUP_CODE and GROUP_NAME — organize attributes into logical scoring or display groups.
SCORING_TYPE, SCORING_METHOD, WEIGHT, ATTR_MAX_SCORE, KNOCKOUT_SCORE — govern how the attribute contributes to auction evaluation.
ACTION — indicates the operation (insert, update, delete) to apply during import.
INTERFACE_HEADER_ID and BATCH_ID#1 — group rows into an interface batch for coordinated processing.

Common Use Cases and Queries

Typical scenarios include validating an Excel upload before committing it to the auction, auditing what was exported, and troubleshooting import failures. A representative query identifies attributes staged for a given auction:

SELECT attribute_name, datatype, response_type, mandatory_flag, value FROM pon_auc_attributes_interface WHERE auction_header_id = :auction_id ORDER BY sequence_number;
SELECT action, COUNT(*) FROM pon_auc_attributes_interface WHERE batch_id#1 = :batch_id GROUP BY action; — summarizes pending operations within a batch.
Joining to PON_AUCTION_HEADERS_ALL confirms the parent auction context for reconciliation reporting.

Because the table is temporary, rows are typically consumed by concurrent Sourcing programs and purged afterward; reporting should therefore target it only during active interface processing.

Related Objects

PON_AUCTION_HEADERS_ALL — parent auction table, joined via AUCTION_HEADER_ID.
PON_AUCTION_LINES_ALL — auction lines that interface attributes ultimately populate.
PON_AUC_ATTRIBUTES / attribute base tables — permanent attribute definitions receiving imported rows.
PON_AUC_ITEM_ATTRIBUTES — item-level attribute assignments derived from the interface.
PON_AUC_ATTRIBUTES_INTERFACE is written and read by the Sourcing auction attribute import/export concurrent programs, which drive the ACTION column processing.

Table: PON_AUC_ATTRIBUTES_INTERFACE 12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_AUC_ATTRIBUTES_INTERFACE, object_name:PON_AUC_ATTRIBUTES_INTERFACE, status:VALID, product: PON - Sourcing , description: Temporary table that contains the attribute details that have been imported or exported to to excel. , implementation_dba_data: PON.PON_AUC_ATTRIBUTES_INTERFACE ,
Table: PON_AUC_ATTRIBUTES_INTERFACE 12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_AUC_ATTRIBUTES_INTERFACE, object_name:PON_AUC_ATTRIBUTES_INTERFACE, status:VALID, product: PON - Sourcing , description: Temporary table that contains the attribute details that have been imported or exported to to excel. , implementation_dba_data: PON.PON_AUC_ATTRIBUTES_INTERFACE ,
APPS.PON_AUC_INTERFACE_TABLE_PKG SQL Statements 12.2.2
APPS.PON_AUC_INTERFACE_TABLE_PKG SQL Statements 12.1.1
PACKAGE BODY: APPS.PON_AUC_INTERFACE_TABLE_PKG 12.2.2
SYNONYM: APPS.PON_AUC_ATTRIBUTES_INTERFACE 12.2.2
owner:APPS, object_type:SYNONYM, object_name:PON_AUC_ATTRIBUTES_INTERFACE, status:VALID,
PACKAGE BODY: APPS.PON_AUC_INTERFACE_TABLE_PKG 12.1.1
SYNONYM: APPS.PON_AUC_ATTRIBUTES_INTERFACE 12.1.1
owner:APPS, object_type:SYNONYM, object_name:PON_AUC_ATTRIBUTES_INTERFACE, status:VALID,
VIEW: PON.PON_AUC_ATTRIBUTES_INTERFACE# 12.2.2
owner:PON, object_type:VIEW, object_name:PON_AUC_ATTRIBUTES_INTERFACE#, status:VALID,
VIEW: PON.PON_AUC_ATTRIBUTES_INTERFACE# 12.2.2
TABLE: PON.PON_AUC_ATTRIBUTES_INTERFACE 12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_AUC_ATTRIBUTES_INTERFACE, object_name:PON_AUC_ATTRIBUTES_INTERFACE, status:VALID,
TABLE: PON.PON_AUC_ATTRIBUTES_INTERFACE 12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_AUC_ATTRIBUTES_INTERFACE, object_name:PON_AUC_ATTRIBUTES_INTERFACE, status:VALID,
PACKAGE: APPS.PON_AUC_INTERFACE_TABLE_PKG 12.2.2
owner:APPS, object_type:PACKAGE, object_name:PON_AUC_INTERFACE_TABLE_PKG, status:VALID,
PACKAGE: APPS.PON_OPEN_INTERFACE_PVT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:PON_OPEN_INTERFACE_PVT, status:VALID,
PACKAGE BODY: APPS.PON_AUC_INTERFACE_TABLE_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PON_AUC_INTERFACE_TABLE_PKG, status:VALID,
12.1.1 DBA Data 12.1.1
PACKAGE BODY: APPS.PON_AUC_INTERFACE_TABLE_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PON_AUC_INTERFACE_TABLE_PKG, status:VALID,
PACKAGE BODY: APPS.ICX_CAT_SCHEMA_UPLOAD_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:ICX_CAT_SCHEMA_UPLOAD_PVT, status:VALID,
12.1.1 DBA Data 12.1.1
PACKAGE BODY: APPS.ICX_CAT_SCHEMA_UPLOAD_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:ICX_CAT_SCHEMA_UPLOAD_PVT, status:VALID,
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.PON_CP_INTRFAC_TO_TRANSACTION 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PON_CP_INTRFAC_TO_TRANSACTION, status:VALID,
12.2.2 FND Design Data 12.2.2
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 FND Design Data 12.1.1
12.1.1 DBA Data 12.1.1
PACKAGE BODY: APPS.PON_CP_INTRFAC_TO_TRANSACTION 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PON_CP_INTRFAC_TO_TRANSACTION, status:VALID,
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.PON_OPEN_INTERFACE_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PON_OPEN_INTERFACE_PVT, status:VALID,
APPS.PON_CP_INTRFAC_TO_TRANSACTION SQL Statements 12.1.1
APPS.PON_CP_INTRFAC_TO_TRANSACTION SQL Statements 12.2.2
APPS.PON_OPEN_INTERFACE_PVT SQL Statements 12.2.2
PACKAGE BODY: APPS.PON_CP_INTRFAC_TO_TRANSACTION 12.1.1
PACKAGE BODY: APPS.PON_CP_INTRFAC_TO_TRANSACTION 12.2.2
APPS.PON_CP_INTRFAC_TO_TRANSACTION dependencies on PON_AUC_ATTRIBUTES_INTERFACE 12.1.1
APPS.ICX_CAT_SCHEMA_UPLOAD_PVT dependencies on PON_AUC_ATTRIBUTES_INTERFACE 12.1.1
APPS.PON_CP_INTRFAC_TO_TRANSACTION dependencies on PON_AUC_ATTRIBUTES_INTERFACE 12.2.2
APPS.PON_AUC_INTERFACE_TABLE_PKG dependencies on PON_AUC_ATTRIBUTES_INTERFACE 12.2.2
APPS.ICX_CAT_SCHEMA_UPLOAD_PVT dependencies on PON_AUC_ATTRIBUTES_INTERFACE 12.2.2
APPS.PON_OPEN_INTERFACE_PVT dependencies on PON_AUC_ATTRIBUTES_INTERFACE 12.2.2
APPS.PON_AUC_INTERFACE_TABLE_PKG dependencies on PON_AUC_ATTRIBUTES_INTERFACE 12.2.2
APPS.PON_OPEN_INTERFACE_PVT dependencies on PON_AUC_ATTRIBUTES_INTERFACE 12.2.2
APPS.PON_AUC_INTERFACE_TABLE_PKG dependencies on PON_AUC_ATTRIBUTES_INTERFACE 12.1.1
PACKAGE BODY: APPS.PON_OPEN_INTERFACE_PVT 12.2.2
APPS.PON_AUC_INTERFACE_TABLE_PKG dependencies on FND_MESSAGE 12.2.2
APPS.PON_AUC_INTERFACE_TABLE_PKG dependencies on FND_MESSAGE 12.1.1
APPS.PON_OPEN_INTERFACE_PVT dependencies on PON_AUCTION_ATTRIBUTES 12.2.2
APPS.PON_AUC_INTERFACE_TABLE_PKG dependencies on FND_LOOKUP_VALUES 12.2.2