Search Results oks_cov_txn_groups_int_all

Overview

OKS_COV_TXN_GROUPS_INT_ALL is the Service Contracts (OKS) open interface table used to import business processes and their associated coverage, reaction, and resolution times that are attached to a contract line's coverage. The table sits in the OKS schema and, in Oracle EBS 12.1.1 and 12.2.2, acts as a staging area through which external systems, legacy migrations, or bulk data loads feed entitlement and service-level data into the Service Contracts module. Records staged here carry the working-day coverage windows, reaction commitments, and resolution commitments that define the level of service a customer has purchased for a given coverage line.

The table contains 69 documented columns and is classified heuristically as a standalone object in the Data Vault model derived from its foreign key structure. This classification is a modeling suggestion: the table has no dependent child tables and no enforced link to a satellite hierarchy, so it is best treated as an isolated staging interface rather than a conformed dimension or transactional hub. Because it is an interface (suffixed _INT_ALL), it is a transient object; rows are validated and processed into the production Service Contracts tables, after which the interface rows are generally purged or marked through the INTERFACED_STATUS_FLAG column.

Key Information Stored

The columns fall into several logical groups. The most important are the identifiers and timing attributes that define the entitlement being imported.

• COVERAGE_BUS_PROCESS_ID — the primary identifier for the coverage-to-business-process association being staged; the closest candidate to a surrogate key on the interface row.
• COVERAGE_ID — the business-key candidate linking the row to the parent coverage line in Service Contracts.
• BUSINESS_PROCESS_ID — foreign key to CS_BUSINESS_PROCESSES, identifying the business process (for example, incident, problem, or change) to which the coverage applies.
• OFFSET_DURATION and OFFSET_PERIOD — the lag or lead applied before coverage begins relative to the process trigger.
• START_DATE and END_DATE — the effective window during which the coverage is active.
• PRICE_LIST_ID and DISCOUNT_ID — pricing context; DISCOUNT_ID references SO_DISCOUNTS.
• COVERAGE_<DAY>_START_TIME and COVERAGE_<DAY>_END_TIME — the daily working-hours coverage windows for each day of the week (Monday through Sunday).
• TIME_ZONE_ID — the time zone in which the coverage windows are interpreted.
• REACTION_NAME, REACTION_DESCRIPTION, REACTION_TIME_ID, and REACTION_SEVERITY_CODE — descriptive and reference attributes for the reaction commitment.
• INCIDENT_SEVERITY_ID — foreign key to CS_INCIDENT_SEVERITIES_B, identifying the severity level tied to the reaction and resolution commitments.
• <DAY>_REACTION_TIMES and <DAY>_RESOLUTION_TIMES — per-day reaction and resolution time values driving SLA compliance.
• WORK_THROUGH_YN and ACTIVE_YN — flags controlling whether the process runs outside standard hours and whether the record is active.
• PREFERRED_RESOURCE_TYPE and PREFERRED_RESOURCE_ID — the preferred resource assignment for the process.
• INTERFACED_STATUS_FLAG — marks whether the row has been processed by the import concurrent program.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the standard Oracle flexfield descriptive columns.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns.

Common Use Cases and Queries

The primary use case is bulk import of contract coverage entitlements. A typical process loads interface rows, runs the Service Contracts import program, and then verifies the outcome. A validation query checking for unprocessed rows is a common operation:

• SELECT COVERAGE_ID, BUSINESS_PROCESS_ID, INCIDENT_SEVERITY_ID, INTERFACED_STATUS_FLAG FROM OKS.OKS_COV_TXN_GROUPS_INT_ALL WHERE INTERFACED_STATUS_FLAG IS NULL OR INTERFACED_STATUS_FLAG = 'N';
• Reporting on SLA commitments by severity and day: aggregate REACTION_TIME_ID and RESOLUTION times grouped by INCIDENT_SEVERITY_ID.
• Detecting coverage gaps by comparing COVERAGE_<DAY>_START_TIME and COVERAGE_<DAY>_END_TIME across days.
• Reconciliation of staged pricing by joining PRICE_LIST_ID and DISCOUNT_ID to the pricing and discount tables.
• Rejected-row analysis after import, filtering on INTERFACED_STATUS_FLAG to isolate records that failed validation.

Related Objects

The documented foreign keys define the principal reference dependencies:

• CS_BUSINESS_PROCESSES — joined on BUSINESS_PROCESS_ID to obtain the business process definition.
• SO_DISCOUNTS — joined on DISCOUNT_ID for discount qualification.
• CS_INCIDENT_SEVERITIES_B — joined on INCIDENT_SEVERITY_ID for severity definitions.
• The parent coverage line (via COVERAGE_ID) in the production Service Contracts coverage tables.
• The related time zone reference behind TIME_ZONE_ID and the resource reference behind PREFERRED_RESOURCE_ID.

Because the object is classified as standalone, no additional dependent tables are documented, and downstream processing is driven by the Service Contracts import program rather than by referential integrity within the interface table itself.