Search Results as_terr_seeded_qualifiers_all




Overview
Explore in AI Chat

Overview

The AS_TERR_SEEDED_QUALIFIERS_ALL table is a core metadata object within the Oracle E-Business Suite (EBS) Sales Foundation (AS) module, owned by the OSM schema. It defines the seeded qualifiers used within territory definitions, acting as the reference list of attributes or criteria against which territory assignments are evaluated. In EBS release 12.1.1 and 12.2.2, this table underpins the Territory Manager functionality by supplying the pre-defined qualification criteria—such as customer, product, or geographic attributes—that administrators select when building territory rules in the Oracle Territory Manager (ETRM) workbench. The _ALL suffix denotes that the table is multi-org enabled, with data segmented by ORG_ID to support operating unit isolation. Based on the heuristic Data Vault classification mined from the foreign key structure, this object is modeled as a standalone entity, meaning it does not participate in formal parent-child relationships within the documented schema and can be represented independently rather than as a hub, link, or satellite.

Key Information Stored

The table contains fourteen documented columns. The most significant are summarized below.

  • SEEDED_QUALIFIER_ID – The surrogate primary key identifying each seeded qualifier record.
  • ORG_ID – The operating unit identifier; combined with the qualifier ID, this forms the composite primary key (AS_TERR_SEED_QUALIFIERS_B_PK) and enforces multi-org partitioning.
  • NAME – The user-visible name of the qualifier, and the business-key candidate in unique index AS_TERR_SEED_QUALIFIERS_B_U2 (NAME, ORG_ID).
  • QUALIFIER_CODE – The internal code used to reference the qualifier programmatically.
  • TYPE – Defines the qualifier category, driving how the territory rule engine interprets it.
  • FORMAT – Specifies the data format expected for the qualifier value.
  • ENABLED_FLAG – Indicates whether the qualifier is active and available for selection in territory definitions.
  • ACCESS_TYPE – Controls the access or usage scope of the qualifier.
  • DESCRIPTION – Free-text explanation of the qualifier's purpose.
  • Audit columns – CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN provide standard EBS who-column auditing.

The surrogate key SEEDED_QUALIFIER_ID (with ORG_ID) is distinguished from the business-key candidates captured in unique indexes AS_TERR_SEED_QUALIFIERS_B_U1 and AS_TERR_SEED_QUALIFIERS_B_U2.

Common Use Cases and Queries

Typical reporting and administrative scenarios include listing all enabled qualifiers for a given operating unit, auditing seeded versus custom qualifiers, and joining qualifier metadata to territory rule setup tables. A representative query follows:

  • Enumerating active qualifiers: SELECT SEEDED_QUALIFIER_ID, NAME, QUALIFIER_CODE, TYPE FROM AS_TERR_SEEDED_QUALIFIERS_ALL WHERE ENABLED_FLAG = 'Y' AND ORG_ID = :p_org_id;
  • Validating business keys: SELECT NAME, COUNT(*) FROM AS_TERR_SEEDED_QUALIFIERS_ALL GROUP BY NAME, ORG_ID HAVING COUNT(*) > 1;
  • Audit trail reporting on recent changes tied to LAST_UPDATED_BY and LAST_UPDATE_DATE.

These queries support territory administration diagnostics, implementation validation, and data migration reconciliation.

Related Objects

The following objects are significant in the territory definition ecosystem. Because the documented schema classifies this table as standalone, several relationships are functional rather than enforced by foreign keys.

  • AS_TERR_SEEDED_QUALIFIERS_TL – Translation table providing language-specific NAME and DESCRIPTION values, joined on SEEDED_QUALIFIER_ID.
  • AS_TERRITORIES_ALL – Parent territory definitions that reference qualifiers when rules are constructed.
  • AS_TERR_QUALIFIERS – Instance-level qualifier values attached to specific territory definitions.
  • AS_TERR_DEFINITIONS_ALL – Stores the rule definitions that consume these seeded qualifiers.
  • AS_TERRITORY_ASSIGNMENTS_ALL – Assignment records generated when territory rules are evaluated.
  • FND_TERRITORIES – Reference geography master frequently associated with geographic qualifiers.
  • JTF_RS_* APIs – Resource and role-based qualifier sources integrated with territory rules.

Together these objects form the territory management data model that this seeded qualifier table feeds into.