Results for “eam_failureset_association_u1”

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

Overview

EAM.EAM_FAILURE_SET_ASSOCIATIONS is an Oracle Enterprise Asset Management (EAM) transactional table that stores the association between failure set libraries and asset groups (or rebuildable inventory items). The table governs which failure set libraries may be presented to users when a failure is reported against an asset. Specifically, the associations recorded here restrict the set of failure set libraries available for failure, cause, and resolution code capture, ensuring that only contextually valid libraries are offered for a given asset group. The table also carries a flag, FAILURE_CODE_REQUIRED, which, when set at the association level, defaults to the work order level to enforce mandatory failure capture.

From a dimensional modeling perspective, the mined relationship structure classifies this object as satellite-leaning. This is a heuristic suggestion: the table behaves less like an independent hub and more like an associative satellite that records descriptive, context-dependent attributes (such as the required flag and effective dating) attached to a combination of a failure set and an asset group. In Oracle EBS 12.1.1 and 12.2.2, the object resides in the EAM schema and stores transaction data in the APPS_TS_TX_DATA tablespace, with its unique index in APPS_TS_TX_IDX.

Key Information Stored

The table comprises nine documented columns. The most significant are the two key columns and the behavioral flag:

• SET_ID — Numeric identifier for the failure set library. Together with INVENTORY_ITEM_ID, it forms the primary key EAM_FAILURE_SET_ASSOCIATION_PK.
• INVENTORY_ITEM_ID — Identifies the asset group or rebuildable item to which the failure set is associated.
• FAILURE_CODE_REQUIRED — A VARCHAR2 flag signifying mandatory failure capture; when enabled at the association level it defaults onto work orders.
• EFFECTIVE_END_DATE — Indicates deletion or expiration of the association; a populated end date effectively retires the link without physically removing the row.

The surrogate primary key is EAM_FAILURE_SET_ASSOCIATION_PK (SET_ID, INVENTORY_ITEM_ID). The business-key candidate is defined by the unique index EAM_FAILURESET_ASSOCIATION_U1, also on (SET_ID, INVENTORY_ITEM_ID), which enforces that any given failure set is associated with a given asset group only once. The remaining columns — CREATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE, and LAST_UPDATED_BY — are standard "Who" audit columns maintained automatically by the EBS framework.

Common Use Cases and Queries

Typical scenarios include determining which failure set libraries are valid for a particular asset group, auditing mandatory failure-capture enforcement, and reporting on active versus expired associations. Because associations are effective-dated, active links are those with a null or future EFFECTIVE_END_DATE.

• List all failure sets associated with a specific asset group: SELECT SET_ID, FAILURE_CODE_REQUIRED FROM EAM.EAM_FAILURE_SET_ASSOCIATIONS WHERE INVENTORY_ITEM_ID = :item_id AND (EFFECTIVE_END_DATE IS NULL OR EFFECTIVE_END_DATE > SYSDATE);
• Identify associations that enforce mandatory failure capture: filter on FAILURE_CODE_REQUIRED = 'Y'.
• Audit retired associations: select rows where EFFECTIVE_END_DATE is not null and in the past.
• Reconcile associations against work order defaults to verify that the required flag propagated correctly.

Related Objects

The table participates in a satellite-style relationship centered on the failure set. Its documented foreign key behavior links SET_ID toward the failure set definition, which supplies the failure, cause, and resolution code libraries. Related objects include:

• EAM_FAILURE_SET_ASSOCIATIONS# — the underlying base table referenced in the dependency list.
• Failure set definition tables — joined on SET_ID to retrieve library metadata.
• Asset group / inventory item tables — joined on INVENTORY_ITEM_ID to resolve the associated asset group or rebuildable identifier.
• Work order failure tables — consume the FAILURE_CODE_REQUIRED default established here.