Search Results wip_eam_parameters

Overview

The WIP_EAM_PARAMETERS table is a core configuration table within the Oracle E-Business Suite (EBS) Work in Process (WIP) module. It serves as the primary repository for organization-level parameters that govern the integration and behavior of Enterprise Asset Management (EAM) functionality within a manufacturing or maintenance organization. When an organization is enabled for EAM operations, this table stores the critical setup defaults that control how work orders for maintenance and asset repair are processed, costed, and managed. Its existence and configuration are fundamental for organizations utilizing EAM work orders, distinguishing their operational rules from those of standard discrete or repetitive manufacturing.

Key Information Stored

The table's primary key is the ORGANIZATION_ID, establishing a one-to-one relationship with each EAM-enabled organization. While the full column list is not detailed in the provided metadata, the documented foreign key relationships reveal two of the most significant columns. The ORGANIZATION_ID itself links to MTL_PARAMETERS, anchoring the EAM parameters to a specific inventory organization. The DEF_EAM_COST_ELEMENT_ID column is a crucial configuration point; it stores a foreign key reference to the CST_EAM_COST_ELEMENTS table, defining the default cost element (such as labor, material, or overhead) to be applied in EAM costing transactions. Other typical columns in this table, based on its purpose, would likely include flags and defaults for work order completion, material issue policies, and charge department assignments specific to asset maintenance workflows.

Common Use Cases and Queries

This table is primarily referenced during the setup of an EAM organization and at runtime when system defaults are required for transaction processing. A common use case is validating or reporting on EAM organization setups. For instance, a query to list all EAM-enabled organizations and their default cost element would join these core tables:

• SELECT wep.organization_id, mp.organization_code, cece.cost_element FROM wip_eam_parameters wep, mtl_parameters mp, cst_eam_cost_elements cece WHERE wep.organization_id = mp.organization_id AND wep.def_eam_cost_element_id = cece.cost_element_id;

Technical consultants and DBAs may query this table to troubleshoot issues where EAM work orders are failing due to missing cost elements or incorrect organization parameter settings. The data is typically maintained via the Oracle EBS application forms for "Organization Parameters" under the EAM or WIP responsibilities, not via direct SQL manipulation.

Related Objects

The WIP_EAM_PARAMETERS table sits at the intersection of WIP, Inventory, and Costing modules, as evidenced by its documented foreign key relationships:

• MTL_PARAMETERS: Joined via WIP_EAM_PARAMETERS.ORGANIZATION_ID. This links the EAM-specific parameters to the general inventory organization definition.
• CST_EAM_COST_ELEMENTS: Joined via WIP_EAM_PARAMETERS.DEF_EAM_COST_ELEMENT_ID. This relationship establishes the default costing rule for EAM work order transactions, a critical integration point for accurate asset maintenance accounting.

As a configuration table, it is also referenced by various EAM and WIP APIs and business logic packages that require the organization's default settings when creating or processing maintenance work orders and their associated material and cost transactions.