Results for “enable_item_in_local_org”

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

Overview

ENG_CHANGE_ORDER_TYPES is a reference and configuration table in the Oracle E-Business Suite Engineering (ENG) module. It defines the categories of engineering change orders (ECOs) that can be created and managed within the enterprise, serving as a master repository for change order type definitions. Each row represents a distinct type of change order — such as a standard engineering change, a manufacturing change, or a document change — that governs behavior such as auto-numbering, assignee defaults, subject handling, and item/BOM generation rules during the change management lifecycle.

The table resides in the ENG schema and contains 49 documented columns in ETRM 12.2.2. Its primary key, ENG_CHANGE_ORDER_TYPES_PK, is defined on CHANGE_ORDER_TYPE_ID. A heuristic Data Vault classification derived from the foreign key structure suggests this table is hub-leaning, meaning it can reasonably be modeled as a hub entity whose natural business key is the change order type, with descriptive attributes functioning as satellite data. This classification is a modeling suggestion rather than a prescriptive design.

Key Information Stored

The surrogate primary key is CHANGE_ORDER_TYPE_ID, which uniquely identifies each change order type and is referenced throughout the Engineering schema. Business-key candidates are defined by unique indexes: ENG_CHANGE_ORDER_TYPES_U1 on (CHANGE_ORDER_TYPE_ID, ZD_EDITION_NAME) and ENG_CHANGE_ORDER_TYPES_U2 on (CHANGE_MGMT_TYPE_CODE, CHANGE_ORDER_TYPE_ID, ZD_EDITION_NAME). These reflect the multi-edition architecture introduced in EBS 12.2.2.

• CHANGE_ORDER_TYPE — the user-facing name of the change order type.
• DESCRIPTION — descriptive text explaining the purpose of the type.
• CHANGE_MGMT_TYPE_CODE — a coded classification distinguishing change management categories.
• BASE_CHANGE_MGMT_TYPE_CODE — the parent or base type code used for hierarchical derivation.
• TYPE_CLASSIFICATION and CLASS_CODE_DERIVED_FLAG — control how classification attributes are derived.
• ASSEMBLY_TYPE — the type of assembly associated with the change order.
• DISABLE_DATE, START_DATE — define the active date range for the type.
• AUTO_NUMBERING_METHOD — governs how change order numbers are generated.
• DEFAULT_ASSIGNEE_ID and DEFAULT_ASSIGNEE_FROM_ROLE_ID — specify default assignees or role-based assignment.
• OBJECT_ID and SUBJECT_ID — link the type to associated objects and subjects.
• SEQUENCE_NUMBER — ordering sequence for display or processing.
• SEEDED_FLAG — indicates whether the type is Oracle-seeded or user-defined.
• Standard audit columns include LAST_UPDATE_DATE, CREATED_BY, LAST_UPDATED_BY, and the 15 ATTRIBUTE columns for extensibility.

Common Use Cases and Queries

Common use cases include listing active change order types for a given organization, resolving default assignees, and joining change order types to engineering changes for reporting. A typical query retrieves all enabled change order types:

• SELECT CHANGE_ORDER_TYPE_ID, CHANGE_ORDER_TYPE, DESCRIPTION FROM ENG.ENG_CHANGE_ORDER_TYPES WHERE DISABLE_DATE IS NULL OR DISABLE_DATE > SYSDATE;
• Joining to ENG_ENGINEERING_CHANGES on CHANGE_ORDER_TYPE_ID to count change orders by type.
• Joining to ENG_CHANGE_ORDER_TYPES_TL for translated type names in multi-language environments.

Reporting use cases include auditing default assignee configuration, verifying auto-numbering methods, and analyzing change order distribution across types using the ENI_DBI_CO_* materialized views.

Related Objects

The following objects reference or depend on ENG_CHANGE_ORDER_TYPES:

• ENG_ENGINEERING_CHANGES — joins on CHANGE_ORDER_TYPE_ID; the primary transactional consumer.
• ENG_CHANGE_ORDER_TYPES_TL — translation table for change order type names.
• ENG_ENG_CHANGES_INTERFACE — interface table referencing the type during change imports.
• RCI_OPEN_ISSUES_F — references CHANGE_ORDER_TYPE_ID for issue tracking.
• ENI_DBI_CO_NUM_MV, ENI_DBI_CO_SUM_MV, ENI_DBI_CO_ALL_MV, ENI_DBI_CO_UNION_MV, ENI_DBI_CO_DNUM_MV — Engineering Intelligence materialized views used for change order analytics.
• IGS_UC_COM_EBL_SUBJ — referenced via SUBJECT_ID for subject/community linkage.