Results for “as_sales_groups”

50+ results




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

Overview

AS_SALES_GROUPS is a foundational reference table in the Oracle E-Business Suite AS - Sales Foundation product family, owned by the OSM schema. It defines sales groups, which represent organizational groupings used to categorize sales forces, territories, and quota-planning structures. Sales groups serve as an intermediate hierarchy between individual salespersons and higher-level sales organizations, and they are referenced throughout Sales Foundation and downstream modules such as Incentive Compensation to attribute revenue, assign managers, and drive compensation calculations.

The table is classified as VALID in the ETRM documentation for releases 12.1.1 and 12.2.2. The table carries a physical schema with 31 documented columns, a surrogate primary key constraint named AS_SALES_GROUPS_PK on SALES_GROUP_ID, and a business-key unique index AS_SALES_GROUPS_U1 also defined on SALES_GROUP_ID. From a Data Vault modeling perspective, the mined foreign-key structure suggests this object is hub-leaning: it holds a stable, slowly-changing business key (SALES_GROUP_ID) that other transactional or descriptive tables reference, making it a natural candidate hub in a dimensional or Data Vault warehouse design.

Key Information Stored

Each row in AS_SALES_GROUPS represents one sales group. The most significant columns include:

  • SALES_GROUP_ID — the surrogate primary key (AS_SALES_GROUPS_PK), also the unique business-key candidate (AS_SALES_GROUPS_U1). This is the value referenced and searched under the term "as_sales_groups_pk".
  • NAME — the user-facing sales group name.
  • DESCRIPTION — free-text description of the group's purpose.
  • START_DATE_ACTIVE and END_DATE_ACTIVE — effective-dating columns that define the active lifespan of the group.
  • ENABLED_FLAG — indicates whether the sales group is currently enabled for use.
  • PARENT_SALES_GROUP_ID — self-referencing parent link that supports a hierarchical sales group structure.
  • MANAGER_PERSON_ID and MANAGER_SALESFORCE_ID — identify the responsible manager and associated sales-force record.
  • ACCOUNTING_CODE — accounting classification used for financial posting and reporting.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard EBS audit columns.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the DFF (descriptive flexfield) columns used for client-specific extensions.

The distinction between the surrogate PK and business-key candidate matters: both AS_SALES_GROUPS_PK and AS_SALES_GROUPS_U1 are defined on SALES_GROUP_ID, indicating the identifier is both system-generated and unique at the business level.

Common Use Cases and Queries

Typical reporting and integration scenarios include listing active sales groups, reconstructing the parent-child hierarchy, and joining sales groups to sales-force assignments for commission analysis.

  • Lookup by primary key: SELECT * FROM OSM.AS_SALES_GROUPS WHERE SALES_GROUP_ID = :p_id;
  • List enabled groups: SELECT SALES_GROUP_ID, NAME FROM OSM.AS_SALES_GROUPS WHERE ENABLED_FLAG = 'Y' ORDER BY NAME;
  • Hierarchy traversal using the self-reference: join a child group to its parent via PARENT_SALES_GROUP_ID = parent.SALES_GROUP_ID.
  • Attribute sales forces to groups: SELECT sf.SALESFORCE_ID, sg.NAME FROM OSM.AS_SALESFORCE sf JOIN OSM.AS_SALES_GROUPS sg ON sf.SALES_GROUP_ID = sg.SALES_GROUP_ID;
  • Effective-dated reporting: filter using START_DATE_ACTIVE and END_DATE_ACTIVE relative to the reporting period.

Related Objects

The documented foreign-key relationship identifies AS_SALESFORCE as the primary referencing object: AS_SALESFORCE.SALES_GROUP_ID points to AS_SALES_GROUPS.SALES_GROUP_ID, meaning each sales-force record is assigned to exactly one sales group. Additional related objects implied by the sales-group manager and hierarchy model include AS_SALES_GROUP_MEMBERS (member assignment), AS_SALES_GROUP_QUOTAS (quota allocation), and personnel references such as PER_PEOPLE_F via MANAGER_PERSON_ID. DFF validation and lookup objects, along with standard EBS audit views, may also depend on this table. Together these establish AS_SALES_GROUPS as the hub reference for sales-force organization and incentive-compensation processing.