Search Results okl_svc_uc1

Overview

OKL.OKL_SERVICES_B is a transactional table in the Oracle E-Business Suite Lease and Finance Management (OKL) schema. It stores header-level information about services quoted on a Lease Quote, serving as the parent record for the individual service lines that a leasing agent attaches to a quote during the quote-to-contract lifecycle. The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, and its indexes are held in APPS_TS_TX_IDX, reflecting a standard transactional data/index split used across ETRM.

Because the table carries an EFFECTIVE_FROM column and only minimal parent linkage, and because contact with OKL_LEASE_QUOTES_ALL_B occurs through a generic (code, identifier) pair rather than a strict foreign key constraint, the heuristic Data Vault classification for this object is standalone. In Data Vault modeling terms this suggests treating it as a satellite-like record tied to the lease quote hub through the PARENT_OBJECT_ID / PARENT_OBJECT_CODE pair, rather than as a fully normalized link. This classification is a modeling suggestion only; it should be validated against the actual ETRM logical model.

Key Information Stored

OKL_SERVICES_B is documented with 28 columns. Its most significant content is:

• ID — the surrogate primary key, enforced by the OKL_SVC_PK constraint. It is also the single column of the unique index OKL_SVC_UC1, so it functions both as the documented surrogate key and the only documented business-key candidate.
• OBJECT_VERSION_NUMBER — the optimistic locking column that EBS increments on each update to detect concurrent modifications to a service header.
• PARENT_OBJECT_ID and PARENT_OBJECT_CODE — the polymorphic reference back to the owning Lease Quote, with code identifying the source entity (documented as referring to OKL_LEASE_QUOTES_ALL_B). PARENT_OBJECT_ID is indexed non-uniquely by OKL_SVC_NC1.
• INV_ITEM_ID — the Inventory Item identifier, linking the quoted service to a defined item in MTL_SYSTEM_ITEMS.
• SUPPLIER_ID and EFFECTIVE_FROM — the supplier associated with the service and the date from which the service header is effective.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the descriptive flexfield columns, each VARCHAR2(450), used for client-specific extensions of service header data.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard WHO audit columns present on all EBS transactional tables.

Distinguishing surrogate from business key is straightforward here: OKL_SVC_UC1 confirms ID as the unique identifier, and no alternate unique candidate is documented among the remaining columns.

Common Use Cases and Queries

The table is queried primarily when reconstructing or auditing quoted services against their lease quotes, and when exporting service data for pricing, supplier analysis, or item-level reporting. Typical patterns include:

• Retrieving all service headers for a given lease quote: SELECT id, inv_item_id, supplier_id, effective_from FROM okl.okl_services_b WHERE parent_object_code = 'OKL_LEASE_QUOTES_ALL_B' AND parent_object_id = :quote_id;
• Joining to the lease quote to expose quote context: SELECT s.id, q.quote_number, s.inv_item_id FROM okl.okl_services_b s, okl.okl_lease_quotes_all_b q WHERE s.parent_object_id = q.id AND s.parent_object_code = 'OKL_LEASE_QUOTES_ALL_B';
• Resolving the referenced inventory item: joining INV_ITEM_ID to MTL_SYSTEM_ITEMS_B for item descriptions and segments.
• Supplier-level reporting, aggregating quoted services by SUPPLIER_ID, and compliance reporting that reads the ATTRIBUTE flexfield columns.

Because the parent linkage is generic, queries should always filter on both PARENT_OBJECT_CODE and PARENT_OBJECT_ID to avoid mixing service rows belonging to different parent entities.

Related Objects

The most significant objects related to OKL_SERVICES_B are:

• OKL.OKL_LEASE_QUOTES_ALL_B — the lease quote header referenced by PARENT_OBJECT_ID and PARENT_OBJECT_CODE; the effective logical parent of each service record.
• OKL.OKL_SERVICES_TL — the translation table that supplies language-specific descriptive text for service headers keyed by ID.
• OKL.OKL_SERVICE_LINES — the child detail table holding the individual line components of each quoted service, linked by the service header ID.
• OKL.OKL_SVC_PK and OKL.OKL_SVC_UC1 — the primary key constraint and unique index on ID, which govern row identity and access path.
• OKL.OKL_SVC_NC1 — the non-unique index on PARENT_OBJECT_ID supporting parent-to-child lookups.
• INV.MTL_SYSTEM_ITEMS_B — the inventory item master joined through INV_ITEM_ID.
• PO.PO_VENDORS and related supplier tables — resolved through SUPPLIER_ID for supplier attribution.

Because the documented relationship data classifies this object as standalone, no hard foreign key enforces the parent or supplier references; dependency integrity is maintained by the OKL application layer rather than by database constraints.