Search Results pos_bus_class_reqs




Overview
Explore in AI Chat

Overview

POS_BUS_CLASS_REQS is a transactional table in the POS (iSupplier Portal) product module of Oracle E-Business Suite, documented as valid in releases 12.1.1 and 12.2.2. It stores business classification requests submitted by or on behalf of suppliers, capturing the classification attributes, certifications, and approval status that define a supplier's business designation within the iSupplier Portal framework. The table sits at the intersection of supplier registration data and classification reference data, acting as the operational record of each classification request lifecycle.

From a Data Vault modeling perspective, the metadata's heuristic classification identifies this object as a link. This is a modeling suggestion rather than a native EBS construct: the table's foreign keys associate a supplier mapping (POS_SUPPLIER_MAPPINGS) with a classification definition (POS_BUS_CLASS_ATTR), and the request record itself resolves that many-to-many style relationship while carrying descriptive attributes such as status, lookup values, and certification details. A Data Vault implementation would typically split the identifiers into the link and push the descriptive columns into an adjoining satellite.

Key Information Stored

The table exposes 16 documented columns. The most significant are:

Common Use Cases and Queries

Typical reporting centers on supplier classification approval pipelines, certification expiry tracking, and audit of who submitted or changed a request. A common pattern joins classification reference data to enrich each request:

  • Identify pending requests by status: SELECT BUS_CLASS_REQUEST_ID, MAPPING_ID, REQUEST_STATUS FROM POS_BUS_CLASS_REQS WHERE REQUEST_STATUS = 'PENDING';
  • Track certifications nearing expiry: SELECT MAPPING_ID, CERTIFICATION_NO, EXPIRATION_DATE FROM POS_BUS_CLASS_REQS WHERE EXPIRATION_DATE < SYSDATE + 30;
  • Join to classification definitions: SELECT r.BUS_CLASS_REQUEST_ID, a.* FROM POS_BUS_CLASS_REQS r, POS_BUS_CLASS_ATTR a WHERE r.CLASSIFICATION_ID = a.CLASSIFICATION_ID;

These queries support procurement compliance dashboards, supplier onboarding reports, and reconciliation against the supplier mapping master.

Related Objects

The FK relationships documented in the ETRM metadata anchor the following dependencies:

  • POS_SUPPLIER_MAPPINGS — referenced via POS_BUS_CLASS_REQS.MAPPING_ID; the parent supplier mapping record.
  • POS_BUS_CLASS_ATTR — referenced via POS_BUS_CLASS_REQS.CLASSIFICATION_ID; the classification attribute definition.
  • POS_BUS_CLASS_REQUEST_PK — the primary key constraint on BUS_CLASS_REQUEST_ID.
  • POS_BUS_CLASS_REQUEST_U1 — the unique index on BUS_CLASS_REQUEST_ID.

Downstream, iSupplier Portal responsibilities and supplier registration workflows consume these records through the POS schema; report and concurrent program logic typically reads the table alongside POS_SUPPLIER_MAPPINGS and POS_BUS_CLASS_ATTR to produce classification and certification summaries.