Results for “op_slsr_cls”

21 results




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

Overview

OP_SLSR_CLS is a reference (setup) table in the Oracle E-Business Suite Process Manufacturing Logistics module (GML), owned by the GML schema. It stores sales representative classes — the categories used to group and classify sales representatives maintained within the Process Manufacturing sales and order capture flow. Because sales representative assignment drives commission, order ownership, and territory reporting in process manufacturing environments, this table functions as the classification backbone for the OP_SLSR_MST sales representative master.

In Oracle EBS 12.1.1 and 12.2.2 the object is documented as VALID and carries a small, stable column set (10 columns) typical of a lookup/setup entity. The heuristic Data Vault classification inferred from the foreign key structure is satellite-leaning. In modeling terms this suggests treating OP_SLSR_CLS as a descriptive satellite attached to the sales representative hub rather than as a standalone hub or a link table. The table exists purely to describe and categorize, not to resolve many-to-many relationships or represent an independent business entity.

Key Information Stored

The table's documented physical schema contains ten columns. The most important are:

  • SLSREP_CLASS — The primary key column and the sole unique business-key candidate, backed by the OP_SLSR_CLS_PK unique index. It holds the short class code that identifies a sales representative class.
  • SLSREP_CLASS_DESC — The descriptive name or long text for the class code, used for display and reporting.
  • TEXT_CODE — A foreign key to OP_TEXT_HDR, linking the class to the shared Oracle text/description framework so that multi-language or standardized description text is stored centrally rather than duplicated here.
  • TRANS_CNT — A transaction count column maintained by Oracle's concurrency control mechanism, incremented on each committed update to protect against lost updates.
  • DELETE_MARK — The standard Oracle soft-delete indicator; a value of 1 marks the row logically deleted without physical removal.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — The standard Oracle Applications WHO columns providing audit and row-level traceability, recording when and by whom the class was defined and last modified.

Notably, there is no independent surrogate key beyond SLSREP_CLASS; the class code itself serves as both the primary key and the business key, which is characteristic of a setup/reference table.

Common Use Cases and Queries

Typical usage centers on validation and lookup during sales representative maintenance and reporting.

  • Populating a class list of values: SELECT SLSREP_CLASS, SLSREP_CLASS_DESC FROM OP_SLSR_CLS WHERE DELETE_MARK = 0 ORDER BY SLSREP_CLASS;
  • Joining classes to representatives: SELECT m.SLSREP_CLASS, c.SLSREP_CLASS_DESC, m.* FROM OP_SLSR_MST m, OP_SLSR_CLS c WHERE m.SLSREP_CLASS = c.SLSREP_CLASS AND c.DELETE_MARK = 0;
  • Resolving description text: join TEXT_CODE to OP_TEXT_HDR to retrieve the standardized description via the text framework rather than the local description column.
  • Reporting: grouping sales orders or commission data by sales representative class to analyze performance across categories.

All extraction queries should filter on DELETE_MARK = 0 to exclude logically deleted classes.

Related Objects

  • OP_SLSR_MST — The sales representative master. Its SLSREP_CLASS column is a foreign key into OP_SLSR_CLS, making this the primary dependent table.
  • OP_TEXT_HDR — The shared text header table referenced by OP_SLSR_CLS.TEXT_CODE for standardized descriptions.
  • OP_SLSR_CLS_PK — The unique index enforcing the primary key on SLSREP_CLASS.

Broader GML objects that consume sales representative classes — such as order capture and commission setup tables — depend on OP_SLSR_MST rather than on OP_SLSR_CLS directly, so this table's direct dependency footprint is intentionally narrow, consistent with its satellite role.