Results for “ak_unique_key_columns_v”
22 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
The AK_UNIQUE_KEY_COLUMNS_V view is a reporting construct in the APPS schema within Oracle E-Business Suite, belonging to the AK (Common Modules-AK) product family. Its documented role in ETRM is a narrow one: it is flagged as 10sc only, indicating that it was designed to support the alternate unique-key and attribute-key infrastructure associated with Oracle's multi-organization supply chain (10sc / MSC) footprint rather than general-purpose application use. The view presents a denormalized, human-readable projection of the unique-key column definitions held in the underlying AK tables, decorating each record with the owning application name and the translatable attribute name so that developers, support analysts, and integration points can identify key structures without manually joining the AK attribute and application tables.
Because the view supplies the descriptive metadata surrounding key column ordering, it is primarily a diagnostic and reference object rather than a transactional one. It exposes key membership and column sequence information that application and integration teams inspect when validating how a logical key is assembled for a business entity.
Underlying Base Objects
The view is defined over the following documented base objects:
AK_UNIQUE_KEY_COLUMNS(SYNONYM) — the driving table, aliased AUKC, supplying the unique key name, key sequence, attribute code, attribute application, and the twelve generic ATTRIBUTEn columns.AK_ATTRIBUTES_TL(SYNONYM) — aliased AAT, the translatable attributes table joined on attribute application and attribute code, filtered toAAT.LANGUAGE = USERENV('LANG')so attribute names resolve in the session language.FND_APPLICATION_VL(VIEW) — aliased FAV, joined onAPPLICATION_ID = ATTRIBUTE_APPLICATION_IDto resolve the owning application name.
The join is an inner join across all three objects, so an attribute whose translation row or application row is missing will not appear in the view. The view also exposes ROWID as ROW_ID, which is a characteristic of an updatable-style view built directly over a single base table with materialized outer joins.
Key Columns
UNIQUE_KEY_NAMEandUNIQUE_KEY_SEQUENCE— the name of the unique key and the ordinal position of the column within that key. This pair is the central identifier: together they define the ordered composition of each unique key.ATTRIBUTE_CODEandATTRIBUTE_APPLICATION_ID— the attribute that participates in the key, together with its owning application.ATTRIBUTE_NAMEandAPPLICATION_NAME— translatable, user-facing descriptions resolved fromAK_ATTRIBUTES_TLandFND_APPLICATION_VLrespectively.ATTRIBUTE_CATEGORYandATTRIBUTE1throughATTRIBUTE15— descriptive flexfield context and segment values carried on the key column definition.CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY, andLAST_UPDATE_LOGIN— standard EBS who-columns for audit tracing.
Common Use Cases and Queries
Typical usage centers on discovering which attribute columns make up a named unique key and in what order. A representative query lists all columns of a given key in sequence:
SELECT unique_key_name, unique_key_sequence, attribute_code, attribute_name, application_name FROM apps.ak_unique_key_columns_v WHERE unique_key_name = :key_name ORDER BY unique_key_sequence;
The unique_key_sequence column is frequently the search anchor for such lookups, since it establishes the deterministic ordering of the key. A second common pattern joins the view to application attribute registrations to reconcile configurator or attribute-based key definitions across environments. Because of the "10sc only" scope and the inner joins to translation and application tables, results should always be interpreted alongside the current session language and confirmed against AK_UNIQUE_KEY_COLUMNS when completeness is required. The view remains a valid, query-only reference object in both 12.1.1 and 12.2.2.
-
10sc only
APPS.AK_UNIQUE_KEY_COLUMNS_V·↳ AK_ATTRIBUTES_TL·↳ AK_UNIQUE_KEY_COLUMNS·↳ FND_APPLICATION_VL·Explore AK module →
-
10sc only
APPS.AK_UNIQUE_KEY_COLUMNS_V·↳ AK_ATTRIBUTES_TL·↳ AK_UNIQUE_KEY_COLUMNS·↳ FND_APPLICATION_VL·Explore AK module →
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
eTRM - AK Tables and Views 12.2.2
-
eTRM - AK Tables and Views 12.1.1
-
12.2.2 DBA Data 12.2.2
-
eTRM - AK Tables and Views 12.1.1
-
eTRM - AK Tables and Views 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - FND Tables and Views 12.1.1
No longer used
-
eTRM - FND Tables and Views 12.1.1
No longer used