Search Results eng_revised_components




Overview
Explore in AI Chat

Overview

The ENG_REVISED_COMPONENTS table is a core data object within the Engineering (ENG) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It serves as a transactional repository for managing changes to the component structure of revised items. Specifically, it tracks both the implementation and cancellation of component revisions, which are modifications to the bill of material (BOM) for an engineering item. This table is essential for maintaining an accurate and auditable history of how an item's composition evolves over its lifecycle, supporting engineering change order (ECO) processes and ensuring manufacturing works with the correct component definitions.

Key Information Stored

The table's primary purpose is to record the status and sequence of component revisions. Its structure is anchored by the COMPONENT_SEQUENCE_ID column, which serves as the primary key and uniquely identifies each component revision record. A critical foreign key column is REVISED_ITEM_SEQUENCE_ID, which links the component revision back to its parent revised item record in the ENG_REVISED_ITEMS table. While the provided metadata does not list all columns, typical data stored includes the component item identifier, revision details, operation sequence, effectivity dates, and a status flag indicating whether the component revision is implemented or cancelled. This enables the system to distinguish between active, pending, and rescinded component changes.

Common Use Cases and Queries

A primary use case is generating reports on the component-level impact of a specific engineering change order. Analysts can query this table to list all component modifications associated with a revised item. Another common scenario is auditing the history of a particular component to understand when it was added, changed, or removed from an assembly. A sample query pattern involves joining to ENG_REVISED_ITEMS to provide context on the parent change order and item.

SELECT erc.*, eri.change_notice
FROM eng_revised_components erc,
     eng_revised_items eri
WHERE erc.revised_item_sequence_id = eri.revised_item_sequence_id
  AND eri.organization_id = :p_org_id
  AND eri.inventory_item_id = :p_item_id;

This query retrieves all component revisions for a specific item in a given organization, useful for lifecycle analysis and compliance reporting.

Related Objects

The ENG_REVISED_COMPONENTS table has a direct and documented foreign key relationship with the ENG_REVISED_ITEMS table, which is central to the revised items functionality. The relationship is defined as follows:

  • Foreign Key From: ENG_REVISED_COMPONENTS.REVISED_ITEM_SEQUENCE_ID
  • References Table: ENG_REVISED_ITEMS
  • Relationship: A revised item (parent) can have multiple revised components (children). This enforces referential integrity, ensuring every component revision is tied to a valid revised item record. Queries will typically join on this column to retrieve comprehensive ECO data.

As a transactional table, it is also expected to be referenced by various Engineering module forms, reports, and potentially public APIs that process engineering change data.