Results for “wip_parameters”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

WIP_PARAMETERS is the organization-level configuration table for Oracle Work in Process, owned by the WIP schema and valid in both EBS 12.1.1 and 12.2.2. It holds the WIP-specific parameter settings that govern discrete, repetitive, and process manufacturing behavior within a given inventory organization. Because Oracle EBS stores WIP parameters per organization, WIP_PARAMETERS acts as the master control record that downstream WIP entities reference for organizational context, defaulting rules, and shop floor behavior. The table contains 89 documented columns and is uniquely keyed by ORGANIZATION_ID.

From a Data Vault modeling perspective, WIP_PARAMETERS is heuristic-classified as hub-leaning. ORGANIZATION_ID functions as the natural business key, and the table is referenced by many child tables via that same column, which is characteristic of a hub anchor surrounded by descriptive satellite columns.

Key Information Stored

The primary key is WIP_PARAMETERS_PK, defined on ORGANIZATION_ID. The unique index WIP_PARAMETERS_U1 (ORGANIZATION_ID) confirms ORGANIZATION_ID as the sole business-key candidate, meaning there is exactly one parameter row per inventory organization. Notable columns include:

• ORGANIZATION_ID — business key and PK; identifies the inventory organization whose WIP parameters are stored.
• DEFAULT_PULL_SUPPLY_SUBINV and DEFAULT_PULL_SUPPLY_LOCATOR_ID — default subinventory and locator used for pull supply; FK to MTL_SECONDARY_INVENTORIES and MTL_ITEM_LOCATIONS respectively.
• DEFAULT_DISCRETE_CLASS — default WIP accounting class for discrete jobs; FK to WIP_ACCOUNTING_CLASSES.
• COST_TYPE_ID — default cost type used by WIP; FK to CST_COST_TYPES.
• SYSTEM_OPTION_ID — reference to the associated system option record; FK to CS_SYSTEM_OPTIONS.
• COMPONENT_ATP_RULE_ID — ATP rule applied to component availability checks.
• BACKFLUSH_LOT_ENTRY_TYPE and LOT_NUMBER_DEFAULT_TYPE — control lot entry and defaulting behavior during backflush.
• AUTORELEASE_DAYS — number of days before jobs are automatically released.
• OSP_SHOP_FLOOR_STATUS — shop floor status applied to outside processing operations.
• COMPLETION_COST_SOURCE — determines the source of completion cost information.
• Multiple ATTRIBUTE1–15 and GLOBAL_ATTRIBUTE1–20 columns for extensibility.

Common Use Cases and Queries

Typical use cases include retrieving default discrete class and pull supply subinventory for a given organization, auditing organization-level WIP configuration across a multi-org deployment, and joining parameters to jobs or entities for reporting. A representative query:

• SELECT wp.organization_id, wp.default_discrete_class, wp.default_pull_supply_subinventory, wp.autorelease_days FROM wip_parameters wp WHERE wp.organization_id = :org_id;
• Multi-org comparison: SELECT wp.organization_id, wp.cost_type_id, wp.component_atp_rule_id FROM wip_parameters wp ORDER BY wp.organization_id;
• Joining to accounting classes: SELECT wp.organization_id, wac.class_code FROM wip_parameters wp, wip_accounting_classes wac WHERE wp.organization_id = wac.organization_id AND wp.default_discrete_class = wac.class_code;

Related Objects

WIP_PARAMETERS is referenced by numerous WIP interface and transaction tables through ORGANIZATION_ID, and it in turn references several setup tables. The most significant related objects include:

• MTL_SECONDARY_INVENTORIES — joined via WIP_PARAMETERS.DEFAULT_PULL_SUPPLY_SUBINV.
• MTL_ITEM_LOCATIONS — joined via WIP_PARAMETERS.DEFAULT_PULL_SUPPLY_LOCATOR_ID.
• WIP_ACCOUNTING_CLASSES — joined via ORGANIZATION_ID and DEFAULT_DISCRETE_CLASS.
• CST_COST_TYPES — joined via COST_TYPE_ID.
• CS_SYSTEM_OPTIONS — joined via SYSTEM_OPTION_ID.
• WIP_ENTITIES, WIP_LINES, and WIP_MOVE_TXN_INTERFACE — all reference ORGANIZATION_ID to WIP_PARAMETERS.
• WIP_COST_TXN_INTERFACE, WIP_JOB_SCHEDULE_INTERFACE, WIP_EMPLOYEE_LABOR_RATES, WIP_SHOP_FLOOR_STATUS_CODES, and WIP_VALID_INTRAOPERATION_STEPS — each carries ORGANIZATION_ID as a foreign key to WIP_PARAMETERS.