Search Results wip_preference_levels_n1

Overview

WIP.WIP_PREFERENCE_LEVELS is a Work in Process (WIP) configuration table in Oracle E-Business Suite that stores the preference level definitions used by Oracle's preference and profiling framework within manufacturing and shop floor execution. Each row represents a distinct preference level that governs how WIP preferences are resolved and applied at specific scoping dimensions, such as organization or department, and in the context of a particular responsibility or module. The table is owned by the WIP schema, resides in the APPS_TS_TX_DATA tablespace, and is designated VALID in the ETRM 12.2.2 documentation. Oracle classifies the object as Internal Use Only; direct DML access is not supported, and data should be manipulated only through standard Oracle Applications programs.

From a data modeling perspective, the supplied metadata identifies WIP_PREFERENCE_LEVELS as a standalone object with no downstream dependents, and its heuristic Data Vault classification is a hub: LEVEL_ID serves as the durable business key that anchors the preference levels, with descriptive context distributed across the surrounding attributes. This classification is a modeling suggestion rather than a physical design statement. Foreign key relationships confirm that LEVEL_ID references MSD_LEVELS and that DEPARTMENT_ID references BOM_DEPARTMENTS, embedding the table within the Oracle preference framework and the shop floor department hierarchy.

Key Information Stored

• LEVEL_ID — Numeric level identifier; the surrogate primary key and the column behind the unique index WIP_PREFERENCE_LEVELS_U1 (documented in 12.2.2 as the composite LEVEL_ID, ZD_EDITION_NAME).
• LEVEL_CODE — Numeric code that classifies the preference level; indexed by the nonunique WIP_PREFERENCE_LEVELS_N2 index.
• RESP_KEY — Responsibility key (VARCHAR2(30)) that scopes the preference level to a specific application responsibility; part of the WIP_PREFERENCE_LEVELS_N1 composite index.
• ORGANIZATION_ID — Organization identifier that scopes the preference level to an inventory or manufacturing organization; indexed alongside RESP_KEY and DEPARTMENT_ID in WIP_PREFERENCE_LEVELS_N1.
• DEPARTMENT_ID — Department identifier that scopes the level to a shop floor department; foreign key to BOM_DEPARTMENTS and member of WIP_PREFERENCE_LEVELS_N1.
• MODULE_ID — Module identifier that determines which Oracle module the preference level applies to.
• Standard Who columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN provide the audit trail.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the Oracle Applications framework to detect concurrent updates.
• ZD_EDITION_NAME — Editioning column documented in the 12.2.2 physical schema, supporting online patching under the AD/TXK editioning model.

Common Use Cases and Queries

Typical usage centers on diagnosing why a WIP preference resolved to a particular value, verifying that a preference level exists for a given responsibility, organization, or department, and auditing the configuration after an upgrade or patch. The uniqueness of the business key explains why the index named in the user search, WIP_PREFERENCE_LEVELS_U1, is the natural join and lookup path: queries that filter by LEVEL_ID or LEVEL_CODE benefit from it directly, while responsibility- and organization-based filtering uses WIP_PREFERENCE_LEVELS_N1.

A representative lookup resolves a preference level against its scope:

• SELECT level_id, level_code, resp_key, organization_id, department_id FROM wip.wip_preference_levels WHERE organization_id = :org_id AND department_id = :dept_id;
• SELECT level_id, module_id FROM wip.wip_preference_levels WHERE resp_key = :resp_key AND level_code = :level_code;
• Reporting joins to MSD_LEVELS and BOM_DEPARTMENTS enrich the scope with descriptive names for configuration audit reports.

Related Objects

• MSD_LEVELS — Referenced by LEVEL_ID; supplies the master definition of the level.
• BOM_DEPARTMENTS — Referenced by DEPARTMENT_ID; provides the department context.
• APPS.WIP_PREFERENCE_LEVELS — The APPS-layer synonym or view through which the table is normally accessed.
• WIP_PREFERENCES — The preference value table whose entries are scoped by the levels defined here.
• FND_RESPONSIBILITY — Source of RESP_KEY values used to scope preference levels by responsibility.
• WIP_PARAMETERS and WIP_DEFAULT_PARAMETERS — Consume preference level definitions during WIP transaction processing.
• WIP_ENTITIES and WIP_DISCRETE_JOBS — Shop floor execution entities affected when preferences resolve through these levels.