Results for “as_sales_group_admins_pk”

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

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.