Results for “wip_eam_parameters_u1”

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

Overview

WIP.WIP_EAM_PARAMETERS is an Oracle E-Business Suite (EBS) configuration table in the Work in Process (WIP) schema that stores organization-level parameters specific to Enterprise Asset Management (EAM) functionality. The table is defined with FND Design Data WIP.WIP_EAM_PARAMETERS and holds a status of VALID in both Release 12.1.1 and 12.2.2. It exists in the APPS_TS_TX_DATA tablespace with a PCT Free of 10.

The table functions as the central repository for defaults used throughout the EAM module. Whenever an organization-level default is required, the various EAM components retrieve it from this table through the view WIP_EAM_PARAMETERS_V. This design allows EAM behavior to vary per inventory organization without duplicating configuration logic in each calling module.

From a Data Vault modeling perspective, this object is best characterized as a link entity: it associates an inventory organization (ORGANIZATION_ID, referencing MTL_PARAMETERS) with a collection of EAM-specific defaults and control flags. Notably, DEF_EAM_COST_ELEMENT_ID references CST_EAM_COST_ELEMENTS, indicating that this is a keyed relationship hub linking organizations to their configured cost elements.

Key Information Stored

The table carries 34 documented columns. The most operationally significant are summarized below.

• ORGANIZATION_ID — The organization identifier and the sole column of the primary key WIP_EAM_PARAMETERS_PK. It is also the single column of the unique index WIP_EAM_PARAMETERS_U1 (APPS_TS_TX_IDX), making it the definitive business-key candidate. The primary key is therefore a natural business key rather than a generated surrogate.
• WORK_REQUEST_AUTO_APPROVE — Flag controlling automatic approval of work requests.
• DEF_MAINT_COST_CATEGORY — Default maintenance cost category assigned to maintenance activity.
• DEF_EAM_COST_ELEMENT_ID — Default cost element, foreign-keyed to CST_EAM_COST_ELEMENTS.
• DEFAULT_EAM_CLASS — Default EAM WIP accounting class (VARCHAR2(10)).
• WORK_ORDER_PREFIX / EASY_WORK_ORDER_PREFIX / PM_WORK_ORDER_PREFIX — Numbering prefixes for different work order origins (VARCHAR2(30)).
• SERIAL_NUMBER_ENABLED — Indicates whether serial number control is applied to EAM transactions.
• AUTO_FIRM_FLAG / AUTO_FIRM_ON_CREATE — Flags that auto-firm a job upon release or upon creation.
• WIP_EAM_REQUEST_TYPE — Determines whether the source document is a Work Request or a Service Request.
• DEFAULT_DEPARTMENT_ID — Default department assigned to EAM work.
• INVOICE_BILLABLE_ITEMS_ONLY / BILLING_BASIS / BILLING_METHOD — Group of columns governing maintenance billing, where BILLING_BASIS distinguishes Price List (1) versus Cost (2).
• Standard Who columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN provide audit traceability.

Common Use Cases and Queries

The most frequent access pattern is a single-row lookup by organization, which the unique index WIP_EAM_PARAMETERS_U1 is designed to serve efficiently.

• Retrieve a specific organization's EAM setup: SELECT * FROM wip.wip_eam_parameters WHERE organization_id = :org_id;
• Read through the public view: Application code and reports typically query WIP_EAM_PARAMETERS_V rather than the base table, matching the documented behavior of EAM modules.
• Audit EAM configuration across organizations: SELECT organization_id, work_request_auto_approve, default_eam_class, auto_firm_flag, billing_basis FROM wip.wip_eam_parameters ORDER BY organization_id;
• Identify billable maintenance setups: Filter on INVOICE_BILLABLE_ITEMS_ONLY and BILLING_BASIS to validate which organizations invoice materials and on what basis.
• Setup verification for EAM implementation: Confirm that each EAM-enabled organization has a valid DEF_EAM_COST_ELEMENT_ID, WORK_ORDER_PREFIX, and default department before going live.
• Change tracking: Use LAST_UPDATE_DATE and LAST_UPDATED_BY to drive audit and reconciliation reports.

Related Objects

• WIP.WIP_EAM_PARAMETERS_V — The view through which EAM modules obtain organization-level defaults.
• MTL_PARAMETERS — Parent inventory organization definition; joined on WIP_EAM_PARAMETERS.ORGANIZATION_ID = MTL_PARAMETERS.ORGANIZATION_ID.
• CST_EAM_COST_ELEMENTS — Referenced by DEF_EAM_COST_ELEMENT_ID to supply the default cost element.
• WIP_EAM_PARAMETERS_PK / WIP_EAM_PARAMETERS_U1 — The primary key and unique index on ORGANIZATION_ID that enforce one parameter row per organization.
• WIP_EAM_WORK_ORDERS / EAM work order tables — Inherit prefixes, accounting class, and firming behavior configured here.
• WIP_EAM_MAINTENANCE_* / maintenance activity tables — Consume defaults such as DEF_MAINT_COST_CATEGORY and DEFAULT_DEPARTMENT_ID.