Search Results default_department_id

Overview

APPS.WIP_EAM_PARAMETERS_V is a reporting and integration view in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 that exposes the Enterprise Asset Management (EAM) setup parameters defined for each maintenance organization. The view is owned by the APPS schema and is defined over WIP_EAM_PARAMETERS together with several descriptive lookup and reference tables, so that consumers receive human-readable values instead of raw coded identifiers. This makes it suitable for operational reporting, configuration auditing, and integration endpoints that must surface organization-level EAM defaults without joining multiple tables.

Practically, the view answers the question: "How is EAM configured for this organization?" It returns one row per organization that has EAM parameters defined. Because it resolves lookup meanings, cost element names, accounting class descriptions, and department codes, it is commonly used in reports and interfaces that need to display or validate EAM defaults. The columns relating to work request approval, work order numbering, cost categories, and department assignment are directly relevant to the setup of maintenance work execution.

Underlying Base Objects

Per the ETRM metadata for 12.2.2, the view is defined over five referenced base objects: WIP_EAM_PARAMETERS, BOM_DEPARTMENTS, CST_EAM_COST_ELEMENTS, MFG_LOOKUPS, and WIP_ACCOUNTING_CLASSES. All are referenced through APPS synonyms or views.

The primary driving table is WIP_EAM_PARAMETERS (aliased e1), which stores the EAM parameters by organization_id. The remaining objects are joined to resolve descriptive attributes:

• BOM_DEPARTMENTS (aliased bd) is outer-joined on department_id = default_department_id to supply department_code.
• CST_EAM_COST_ELEMENTS (aliased c1) is outer-joined on eam_cost_element_id = def_eam_cost_element_id to supply the default cost element name.
• MFG_LOOKUPS (aliased b1) provides the meaning for the BOM_EAM_COST_CATEGORY lookup type, joined on def_maint_cost_category.
• WIP_ACCOUNTING_CLASSES (aliased w1) is outer-joined on class_code and organization_id to supply the EAM class description.

Because the descriptive joins are largely outer joins (denoted with the (+) operator), the view preserves parameter rows even when a referenced department, cost element, or accounting class is not yet defined or has been disabled.

Key Columns

The view exposes both raw codes and resolved descriptions. Key columns include:

• organization_id – Organization owning the EAM parameters; the primary filter key.
• default_department_id – The department defaulted on maintenance work orders, as requested in the user's search. It is the foreign key to BOM_DEPARTMENTS and is exposed alongside the resolved default_department (department_code).
• def_maint_cost_category and meaning – Maintenance cost category code and its lookup meaning.
• def_eam_cost_element_id and eam_cost_element – Default cost element identifier and name.
• default_eam_class and description – Default EAM accounting class.
• auto_approve_enabled_flag (work_request_auto_approve) – Whether work requests are auto-approved.
• work_order_prefix / easy_work_order_prefix – Numbering prefixes for work orders.
• serial_number_enabled, auto_firm_flag, auto_firm_on_create – Work order behavior flags.
• material_issue_by_mo, invoice_billable_items_only, default_asset_flag – EAM-specific operational controls.
• Standard WHO columns: creation_date, created_by, last_update_date, last_updated_by, last_update_login.

Common Use Cases and Queries

Typical uses include configuration reports, validation of EAM defaults before data migration, and integration queries that need the department and cost element defaults. To retrieve the default department for all organizations:

SELECT organization_id, default_department_id, default_department FROM apps.wip_eam_parameters_v ORDER BY organization_id;

To find organizations where no default department is assigned (default_department is null because the outer join found no matching BOM_DEPARTMENTS row):

SELECT organization_id FROM apps.wip_eam_parameters_v WHERE default_department_id IS NULL;

To compare work request approval settings and cost categories per organization:

SELECT organization_id, auto_approve_enabled_flag, meaning, work_order_prefix FROM apps.wip_eam_parameters_v WHERE auto_approve_enabled_flag = 'Y';

Because the view is read-only and consolidated, it is well suited for report registration and BI Publisher data models, while updates must target WIP_EAM_PARAMETERS directly.