Search Results oks_serv_avail_excepts_n1

Overview

The OKS.OKS_SERV_AVAIL_EXCEPTS table stores exception records that define inclusion and exclusion rules for service availability within Oracle E-Business Suite. It is populated through the detail region of the Service Availability user interface, where users specify a party or product for which a service is either explicitly unavailable or exclusively available. The table works in tandem with OKS.OKS_SERV_AVAILS, which holds the broadly available services. When the two tables are combined, they yield the complete picture of which services, warranties, and extended warranties are available to a given party or product.

The Generally Available check box on the Service Availability form governs the semantics of each row. When selected, the service is generally available and the products and parties listed in this table are excluded from receiving it. When unselected, the service is not generally available and the listed products and parties are the only ones eligible to receive it. These inclusion and exclusion rules are honored downstream when services are sold through quoting, Order Management, and other upstream applications.

Based on the foreign key structure documented in the ETRM metadata, the heuristic Data Vault classification for this object is link. It behaves as an associative entity connecting a service availability record to a party or product object, rather than as a standalone hub or a descriptive satellite.

Key Information Stored

The table carries 33 documented columns. The most significant are:

• ID — Internal unique identifier and the surrogate primary key. It is also the column behind the unique index OKS_SERV_AVAIL_EXCEPTS_U1 (tablespace APPS_TS_TX_IDX), which the user searched for. In practice the U1 index enforces uniqueness on this surrogate key rather than on a composite business key.
• SAV_ID — Foreign key to the ID column of OKS_SERV_AVAILS, tying each exception back to its parent service availability record.
• OBJECT1_ID1 — Holds the Party or Customer ID; also indexed non-uniquely via OKS_SERV_AVAIL_EXCEPTS_N1.
• OBJECT1_ID2 — Documented as not used.
• JTOT_OBJECT1_CODE — Foreign key to JTF_OBJECTS_B; identifies the JTF object code and the source object, view, or table that contains the party or product reference.
• OBJECT_VERSION_NUMBER — Optimistic locking counter, initialized to 1.
• MANUFACTURING_ORG_ID — Organization context for the exception.
• REVISION_LOW / REVISION_HIGH — Effective revision range for the exception.
• START_DATE_ACTIVE / END_DATE_ACTIVE — Date range during which the exception is active.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS for multi-tenant security partitioning.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — DFF flexfield storage.

Common Use Cases and Queries

Typical usage centers on auditing which parties or products are excluded from, or uniquely entitled to, a service. A common join resolves exceptions to their parent availability record:

• Reports listing all exceptions for a specific service availability: SELECT ID, SAV_ID, OBJECT1_ID1, JTOT_OBJECT1_CODE FROM OKS.OKS_SERV_AVAIL_EXCEPTS WHERE SAV_ID = :sav_id.
• Entitlement validation joining parties to availability context: SELECT e.* FROM OKS.OKS_SERV_AVAIL_EXCEPTS e, OKS.OKS_SERV_AVAILS a WHERE e.SAV_ID = a.ID AND e.OBJECT1_ID1 = :party_id.
• Exclusion auditing by object type using JTOT_OBJECT1_CODE to distinguish product versus party rows.
• Date-range effective dating checks against START_DATE_ACTIVE and END_DATE_ACTIVE to confirm active exceptions.

Related Objects

• OKS.OKS_SERV_AVAILS — Parent table; joined via OKS_SERV_AVAIL_EXCEPTS.SAV_ID = OKS_SERV_AVAILS.ID.
• JTF.JTF_OBJECTS_B — Referenced through JTOT_OBJECT1_CODE to resolve the source object.
• FND.FND_SECURITY_GROUPS — Referenced through SECURITY_GROUP_ID.
• OKS_SERV_AVAIL_EXCEPTS_U1 — Unique index on ID in APPS_TS_TX_IDX.
• OKS_SERV_AVAIL_EXCEPTS_N1 — Non-unique index on OBJECT1_ID1.
• Service Availability UI, quoting, and Order Management — consumers that enforce the inclusion and exclusion rules defined here.