Search Results pos_bus_class_attr_pk1

Overview

POS_BUS_CLASS_ATTR is a transactional table in the Oracle E-Business Suite iSupplier Portal (POS) product module that stores supplier business classification attributes. It records the diversity and business classification credentials that a supplier party has declared or been certified for, such as small business, minority-owned, woman-owned, or veteran-owned designations. The table resides in the POS schema and is documented as VALID in both release 12.1.1 and 12.2.2. Its role in EBS is to hold the classification detail used by supplier qualification, sourcing, and spend-analysis workflows within iSupplier Portal and related procurement functionality.

The ETRM metadata describes the physical schema with 25 columns and a heuristic Data Vault classification of satellite-leaning. In Data Vault terms, that classification suggests the table behaves as a descriptive satellite attached to a business key represented elsewhere — primarily the supplier party in HZ_PARTIES — rather than acting as an independent hub.

Key Information Stored

The primary key is the surrogate column CLASSIFICATION_ID, enforced through the unique index POS_BUS_CLASS_ATTR_PK1. A second unique index, POS_BUS_CLASS_ATTR_U1, also covers CLASSIFICATION_ID. The primary business-key candidate is captured by the composite functional index POS_BUS_CLASS_ATTR_U2, which concatenates PARTY_ID, PARTY_SITE_ID, VENDOR_SITE_ID, LOOKUP_TYPE, LOOKUP_CODE, and STATUS, with CLASSIFICATION_ID appended when STATUS is not 'A'. This indicates the natural business key of a supplier classification record is the party and site combination together with the classification lookup value and its active status.

• CLASSIFICATION_ID — surrogate primary key uniquely identifying each classification row.
• PARTY_ID — foreign key to HZ_PARTIES, identifying the supplier party that owns the classification.
• LOOKUP_TYPE and LOOKUP_CODE — the classification category and its specific value drawn from the lookup framework.
• STATUS and CLASS_STATUS — lifecycle indicators for the classification record (for example active versus inactive).
• START_DATE_ACTIVE, END_DATE_ACTIVE, and EXPIRATION_DATE — effective-dating and expiry controls for the classification.
• CERTIFICATE_NUMBER and CERTIFYING_AGENCY — the certification reference and the authority that issued it.
• PARTY_SITE_ID, VENDOR_SITE_ID, and VENDOR_ID — site- and vendor-level context linking the classification to specific supplier locations.
• EXT_ATTR_1 and ATTRIBUTE1 through ATTRIBUTE5 — descriptive flexfield and extension columns for customer-defined data.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — standard EBS audit columns.

Common Use Cases and Queries

Typical scenarios include identifying which suppliers hold a given classification, tracing certification expiry, and feeding diversity-spend reporting. The join to HZ_PARTIES supplies the party name and number for reporting.

SELECT bca.CLASSIFICATION_ID, bca.PARTY_ID, bca.LOOKUP_TYPE,
       bca.LOOKUP_CODE, bca.STATUS, bca.EXPIRATION_DATE
FROM   POS.POS_BUS_CLASS_ATTR bca
WHERE  bca.STATUS = 'A';

Expiry reporting filters on EXPIRATION_DATE, while classification histories are retrieved by joining POS_BUS_CLASS_REQS on CLASSIFICATION_ID. Reporting on active classifications can rely on the columns covered by POS_BUS_CLASS_ATTR_U2.

Related Objects

• HZ_PARTIES — referenced by PARTY_ID; supplies party-level supplier details.
• POS_BUS_CLASS_REQS — references this table through CLASSIFICATION_ID, linking classification requests to classification attributes.
• The POS iSupplier Portal supplier registration and profile pages that surface classification data.
• Lookup framework (FND_LOOKUPS) for resolving LOOKUP_TYPE and LOOKUP_CODE values.
• Supplier qualification and sourcing reports that consume classification attributes.