Search Results cs_sr_load_balance_wt_u1

Overview

CS.CS_SR_LOAD_BALANCE_WT is a seed data table in the Customer Support (CS) schema of Oracle E-Business Suite, documented as VALID in ETRM for release 12.2.2 and equally present in 12.1.1. The table stores the weighting factors used by the Service Request assignment and load-balancing engine to rank and distribute incoming service requests across available agents, resource groups, and territories. Each row defines a weighting profile that is tied to a specific incident (service request) type and severity, and it dictates how strongly individual agent attributes — such as product skill, platform skill, problem code skill, last login time, open severity counts, and time zone difference — influence the routing score.

Physically the object resides in the APPS_TS_SEED tablespace with PCT Free 10, consistent with its role as a setup/seed entity rather than a high-volume transactional table. From a Data Vault modeling perspective, the mined relationship structure suggests a standalone classification, as no parent hub/link/satellite pattern is enforced. This should be treated as a modeling suggestion only; in practice the table behaves as a small reference/configuration entity keyed by a surrogate identifier.

Key Information Stored

The table carries 37 documented columns. The most operationally significant are listed below.

• WEIGHT_ID — Surrogate primary key (NUMBER) and the column behind the unique index CS_SR_LOAD_BALANCE_WT_U1. This is the business-key candidate used by all foreign key references.
• INCIDENT_TYPE_ID — Foreign key to CS.CS_INCIDENT_TYPES_B; identifies the service request type the weighting applies to.
• INCIDENT_SEVERITY_ID — Foreign key to CS.CS_INCIDENT_SEVERITIES_B; identifies the severity the weighting applies to.
• PRODUCT_SKILL_WT — Weight applied to an agent's product-level skill match.
• PLATFORM_SKILL_WT — Weight applied to platform-level skill match.
• PROB_CODE_SKILL_WT — Weight for problem-code skill alignment.
• CATEGORY_SKILL_WT — Weight for category skill alignment.
• LAST_LOGIN_TIME_WT — Weight favoring agents who have logged in recently.
• SEVERITY1_COUNT_WT through SEVERITY4_COUNT_WT — Weights reflecting the count of open service requests at each severity level, used to penalize overloaded agents.
• TIME_ZONE_DIFF_WT — Weight applied to time zone differences between agent and requester.
• START_DATE_ACTIVE / END_DATE_ACTIVE — Effective dating controlling when a weighting profile is in force.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard Who columns.
• ATTRIBUTE1 – ATTRIBUTE15, CONTEXT — Descriptive flexfield segments.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the OAF framework.

Common Use Cases and Queries

Administrators and developers query this table to audit or tune Service Request routing behavior. A typical lookup retrieves the active weight profile for a given type and severity:

• SELECT WEIGHT_ID, PRODUCT_SKILL_WT, PLATFORM_SKILL_WT, LAST_LOGIN_TIME_WT FROM CS.CS_SR_LOAD_BALANCE_WT WHERE INCIDENT_TYPE_ID = :type AND INCIDENT_SEVERITY_ID = :sev AND SYSDATE BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, SYSDATE+1);
• Reporting on the distribution of weighted scores typically joins to BIS_WEIGHTED_MEASURE_SCORES and BIS_WEIGHTED_MEASURE_WEIGHTS on WEIGHT_ID to reconcile assignment outcomes against configured weights.
• Configuration migration scripts (FNDLOAD or custom extract) frequently select all rows for a given WEIGHT_ID to move routing profiles between environments.

Related Objects

• CS.CS_INCIDENT_TYPES_B — parent lookup; joined on INCIDENT_TYPE_ID.
• CS.CS_INCIDENT_SEVERITIES_B — parent lookup; joined on INCIDENT_SEVERITY_ID.
• BIS.BIS_WEIGHTED_MEASURE_WEIGHTS — references WEIGHT_ID for weighted measure definitions.
• BIS.BIS_WEIGHTED_MEASURE_SCORES — references WEIGHT_ID for weighted measure scoring.
• CS_SR_LOAD_BALANCE_WT_U1 — unique index on WEIGHT_ID, enforcing surrogate key integrity.