Search Results default_department_id

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

Overview

WIP_EAM_PARAMETERS is the organization-level setup table that governs Enterprise Asset Management (EAM) behavior within Oracle Work in Process. It stores the operational defaults, numbering rules, cost element assignments, and workflow switches that determine how work requests, work orders, and maintenance activities are created and processed in an EAM-enabled inventory organization. Because EAM work orders are executed through WIP, this table bridges the asset-centric maintenance domain and the discrete manufacturing execution domain, supplying the parameters that drive work order generation, cost collection, and billing treatment.

In Oracle EBS 12.1.1 and 12.2.2 the table resides in the WIP schema and is documented as VALID. The heuristic Data Vault classification mined from the foreign key structure is link. From a dimensional modeling perspective, this classification is appropriate: WIP_EAM_PARAMETERS functions as an association between an inventory organization (MTL_PARAMETERS) and a default EAM cost element (CST_EAM_COST_ELEMENTS), carrying descriptive settings that describe the relationship and its operating rules.

Key Information Stored

The physical schema documents 34 columns. The single-column primary key, enforced through WIP_EAM_PARAMETERS_PK, is ORGANIZATION_ID. A unique index, WIP_EAM_PARAMETERS_U1, also covers ORGANIZATION_ID, confirming a strict one-row-per-organization model. ORGANIZATION_ID is simultaneously the foreign key to MTL_PARAMETERS, so the surrogate identifier and the business key coincide in this table.

The most consequential columns include:

• DEF_EAM_COST_ELEMENT_ID — foreign key to CST_EAM_COST_ELEMENTS, defining the default cost element for EAM cost collection.
• DEF_MAINT_COST_CATEGORY — default maintenance cost category applied to EAM transactions.
• DEFAULT_EAM_CLASS — the default WIP class used when creating EAM work orders.
• DEFAULT_DEPARTMENT_ID — default department for EAM operations and routings.
• WORK_ORDER_PREFIX and WORK_REQUEST_PREFIX — numbering prefixes for EAM work orders and work requests; PM_WORK_ORDER_PREFIX and EASY_WORK_ORDER_PREFIX extend this to preventive maintenance and easy work orders.
• WORK_REQUEST_AUTO_APPROVE and AUTO_FIRM_FLAG / AUTO_FIRM_ON_CREATE — control automatic approval and firming of work requests and work orders.
• WIP_EAM_REQUEST_TYPE — default work request type used on creation.
• SERIAL_NUMBER_ENABLED and DEFAULT_ASSET_FLAG — determine serial and asset tracking defaults.
• MATERIAL_ISSUE_BY_MO, ISSUE_ZERO_COST_FLAG, INTERMEDIATE_SUBINVENTORY, INTERMEDIATE_LOCATOR — govern material issue behavior for maintenance work orders.
• BILLING_BASIS, BILLING_METHOD, INVOICE_BILLABLE_ITEMS_ONLY, OVERRIDE_BILL_AMOUNT, DYNAMIC_BILLING_ACTIVITY — control maintenance billing to customers.
• EAM_WO_WORKFLOW_ENABLED and EAM_SAFETY_WORKFLOW_ENABLED — activate workflow-driven processing and safety plans.

Common Use Cases and Queries

Typical reporting and configuration queries retrieve EAM parameters for a specific organization or compare settings across organizations. For example:

• Retrieving defaults: SELECT organization_id, default_eam_class, def_eam_cost_element_id, billing_method FROM wip_eam_parameters WHERE organization_id = :org_id;
• Identifying organizations with workflow disabled: SELECT organization_id FROM wip_eam_parameters WHERE eam_wo_workflow_enabled = 'N';
• Joining to inventory parameters for a consolidated setup report: SELECT p.organization_id, m.organization_code, p.work_order_prefix, p.def_maint_cost_category FROM wip_eam_parameters p, mtl_parameters m WHERE p.organization_id = m.organization_id;

These queries support implementation audits, multi-org rollout validation, and post-clone configuration verification.

Related Objects

• MTL_PARAMETERS — joined via MTL_PARAMETERS.ORGANIZATION_ID = WIP_EAM_PARAMETERS.ORGANIZATION_ID; confirms the organization is EAM-enabled.
• CST_EAM_COST_ELEMENTS — joined via DEF_EAM_COST_ELEMENT_ID; supplies the default cost element.
• WIP_DISCRETE_JOBS and WIP_ENTITIES — consume the numbering, class, and firming defaults when EAM work orders are created.
• WIP_EAM_WORK_REQUESTS — uses request type, approval, and asset number requirement settings.
• BOM_DEPARTMENTS — referenced indirectly through DEFAULT_DEPARTMENT_ID.

Because the table is thin and configuration-oriented, no public APIs write to it directly; setup is maintained through the EAM organization parameters forms, which persist rows keyed entirely by ORGANIZATION_ID.