Search Results as_sales_grp_admin




Overview
Explore in AI Chat

Overview

The AS_SALES_GRP_ADMIN table is a Sales Foundation (product code AS) object owned by the OSM schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to define administrators for sales groups, establishing an assignment of administrative responsibility over a sales group to a specific person. In the Oracle EBS Sales Foundation model, sales groups organize salesforce members and drive territory-style visibility and reporting; the administrator records in this table determine who may maintain the membership, structure, and associated attributes of those groups. The table is a core reference object queried by sales group maintenance forms, concurrent programs, and access-control logic, and it is exposed to reporting through standard EBS data extraction and BI Publisher mechanisms.

Under the heuristic Data Vault classification mined from the foreign key structure, AS_SALES_GRP_ADMIN is characterized as a standalone object. In Data Vault modelling terms this suggests the table behaves primarily as a hub-like registry of administrator assignments keyed by sales group, though because the mined structure shows no inbound dependent objects and only one outbound reference, it should be treated as a low-connectivity reference entity rather than a fully modelled hub. This classification is a modelling suggestion only and does not alter the physical implementation.

Key Information Stored

The table contains 24 documented physical columns. The documented primary key constraint is AS_SALES_GROUP_ADMINS_PK, defined on SALES_GROUP_ID. The documented unique index AS_SALES_GROUP_ADMINS_U1, spanning SALES_GROUP_ID and PERSON_ID, is the strongest business-key candidate, since it prevents duplicate assignment of the same person as administrator for the same sales group. SALESFORCE_ID is a foreign key referencing AS_SALESFORCE, tying the administrator assignment to a specific salesforce context.

  • SALES_GROUP_ID — identifies the sales group being administered; documented primary key column.
  • PERSON_ID — the party/person record of the individual assigned as administrator; combined with SALES_GROUP_ID in the unique index.
  • SALESFORCE_ID — foreign key to AS_SALESFORCE, scoping the administrator to a salesforce.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit (WHO) columns capturing record provenance and change history.
  • ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard flexible descriptive flexfield (DFF) columns available for customer-specific extension of administrator records.

Because the administrator is stored as a PERSON_ID rather than an application user ID, the table defines organizational responsibility independent of login identity.

Common Use Cases and Queries

Typical usage includes identifying the administrator population for a sales group, auditing sales group ownership, and driving security or workflow routing. A representative join pattern is:

  • List administrators for a given sales group: SELECT PERSON_ID FROM AS_SALES_GRP_ADMIN WHERE SALES_GROUP_ID = :group_id.
  • Resolve administrator identities by joining PERSON_ID to PER_ALL_PEOPLE_F for name and email.
  • Audit recently changed assignments using LAST_UPDATE_DATE and LAST_UPDATED_BY.
  • Validate uniqueness by querying SALES_GROUP_ID and PERSON_ID together, mirroring AS_SALES_GROUP_ADMINS_U1.

These queries support operational reporting, access reviews, and integration extracts.

Related Objects

  • AS_SALESFORCE — joined via AS_SALES_GRP_ADMIN.SALESFORCE_ID = AS_SALESFORCE.SALESFORCE_ID.
  • AS_SALES_GROUP — parent sales group joined via SALES_GROUP_ID.
  • PER_ALL_PEOPLE_F — administrator identity via PERSON_ID.
  • AS_SALES_GRP_MEMBER — membership counterpart for the same sales group.
  • FND_USER — cross-reference when administrators are also application users.