1. Tables and Views for SCM
  2. EGP_STRUCTURES_INTERFACE

EGP_STRUCTURES_INTERFACE

EGP_STRUCTURES_INTERFACE temporarily stores bills of material before loading information into Oracle Bills of Material. This table contains user friendly columns which allow you to easily enter your data as well as their corresponding foreign keys. Oracle Bills of Material will derive column values you do not enter, after performing the proper validation. For example, you enter the ORGANIZATION_CODE and Oracle Bills of Material will fill in the corresponding ORGANIZATION_ID for you. . Also, if you enter REVISION, Oracle Bills of Material will insert a record into MTL_ITEM_REVISIONS for your bill item.

Details

  • Schema: FUSION

  • Object owner: EGP

  • Object type: TABLE

  • Tablespace: INTERFACE

Columns

Name Datatype Length Precision Comments Status
ASSEMBLY_ITEM_ID NUMBER 18 Inventory item identifier of manufactured assembly Active
PREPROCESS_THREAD_NUMBER NUMBER 18 PreProcess Thread Number for interface processing
ORGANIZATION_ID NUMBER 18 A organizing unit in the internal or external structure of your enterprise. Organization structures provide the framework for performing legal reporting, financial control, and management reporting. Active
ALTERNATE_BOM_DESIGNATOR VARCHAR2 80 Unique name given to a specific variation of a Structure type. Active
LAST_UPDATE_DATE TIMESTAMP Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Who column: indicates the user who last updated the row. Active
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
COMMON_ASSEMBLY_ITEM_ID NUMBER 18 Inventory item identifier of common assembly Active
SPECIFIC_ASSEMBLY_COMMENT VARCHAR2 240 Specific bill of material comment Active
PENDING_FROM_ECN VARCHAR2 10 Change notice that created this bill Active
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE21 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE22 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE23 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE24 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE25 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE26 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE27 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE28 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE29 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE30 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
COMMON_BILL_SEQUENCE_ID NUMBER 18 Unique bill identifier for common bill Active
BILL_SEQUENCE_ID NUMBER 18 Bill of material unique identifier Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
DEMAND_SOURCE_LINE VARCHAR2 30 Demand source line - used for ATO Active
REVISION VARCHAR2 3 Revision Identifer of the Item/Component participating in the structure Active
COMMON_ORGANIZATION_ID NUMBER 18 Organization identifier of common organization Active
COMMON_ALT_BOM_DESIGNATOR VARCHAR2 80 Common Alternate BOM Designator. Active
DEMAND_SOURCE_TYPE NUMBER Demand source type - used for ATO Active
DEMAND_SOURCE_HEADER_ID NUMBER Demand source header identifier - used for ATO Active
TRANSACTION_ID NUMBER 18 Identifier used for tracking the transaction during import/data load. Active
PROCESS_STATUS NUMBER 18 Row Status for the Import and Data Load Jobs Active
ORGANIZATION_CODE VARCHAR2 18 Abbreviation of organization name Active
COMMON_ORG_CODE VARCHAR2 18 Abbreviation of common organization name Active
ITEM_NUMBER VARCHAR2 820 Concatenated bill item segments Active
COMMON_ITEM_NUMBER VARCHAR2 240 Concatenated common bill item segments Active
NEXT_EXPLODE_DATE DATE Next date when pre-explosion will be refreshed Active
TRANSACTION_TYPE VARCHAR2 10 Type of action: CREATE, UPDATE, or DELETE Active
DELETE_GROUP_NAME VARCHAR2 10 Delete group name for the entity type you are deleting Active
DG_DESCRIPTION VARCHAR2 240 Description of the delete group Active
ORIGINAL_SYSTEM_REFERENCE VARCHAR2 50 Original system that data for the current record has come from. Active
IMPLEMENTATION_DATE DATE The date when an event will take place. Active
OBJ_NAME VARCHAR2 30 Name of the object. Contains values like EGO_ITEM etc., Active
PK1_VALUE VARCHAR2 240 Identifier representing inventory_item_id of the item Active
PK2_VALUE VARCHAR2 240 Identifier representing Organization_id of the item Active
PK3_VALUE VARCHAR2 240 Used to refer any other identifiers from other tables Active
PK4_VALUE VARCHAR2 240 Used to refer any other identifiers from other tables Active
PK5_VALUE VARCHAR2 240 Used to refer any other identifiers from other tables Active
STRUCTURE_TYPE_NAME VARCHAR2 80 A unique identifier of a structure type used in the code. Active
STRUCTURE_TYPE_ID NUMBER 18 Structure Type Identifier of the given structure Active
EFFECTIVITY_CONTROL NUMBER Effectivity control of the source item structure. Active
RETURN_STATUS VARCHAR2 1 No longer used. Active
IS_PREFERRED VARCHAR2 1 Determines whether this structure is preferred or not. Active
SOURCE_SYSTEM_REFERENCE VARCHAR2 255 Source system item name for import Active
SOURCE_SYSTEM_REFERENCE_DESC VARCHAR2 240 Source system reference description Active
BATCH_ID NUMBER 18 A unique identifier of an item batch. Batch Identifier for Data Load Active
CHANGE_ID NUMBER 18 A unique identifier of a change order. Active
CATALOG_CATEGORY_NAME VARCHAR2 240 Catalog Category Name to which the item belongs Active
ITEM_CATALOG_GROUP_ID NUMBER 18 Item Catalog Category Identifier Active
PRIMARY_UNIT_OF_MEASURE VARCHAR2 25 The principal unit of measure in which the quantity of an item is managed. Active
ITEM_DESCRIPTION VARCHAR2 240 Description of the item, for given structure. Active
TEMPLATE_NAME VARCHAR2 240 Name of the Item Template, points to the item table Active
SOURCE_BILL_SEQUENCE_ID NUMBER 18 Bill Sequence Id of the source structure Active
ENABLE_ATTRS_UPDATE VARCHAR2 1 Indicates whether attributes of a Common BOM need to be updated. Possible values are 'Y'/'N'. Active
OBJECT_VERSION_NUMBER NUMBER 9 Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. Active
PROGRAM_NAME VARCHAR2 30 Identifies the concurrent program Active
PROGRAM_APP_NAME VARCHAR2 50 Identifies the Application name spawning the Concurrent Request Active
THREAD_NUMBER NUMBER 18 Thread Number for interface processing Active
SOURCE_SYSTEM_ID NUMBER 18 Identifier of the source spoke system Active
INTERFACE_TABLE_UNIQUE_ID NUMBER 18 Interface Table Unique Identifier for Structure Header's interface rows. Active
ITEM_TRANSACTION_ID NUMBER 18 Identifier used for tracking the transaction during import/data load process Active
PHASE_NUMBER NUMBER 18 Phase Number identifer for Import. Active
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP1 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP2 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP3 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP4 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_TIMESTAMP5 TIMESTAMP Descriptive Flexfield: segment of the user descriptive flexfield.
BATCH_NUMBER VARCHAR2 40 Unique identifier of the batch that is used for item import.
SOURCE_SYSTEM_CODE VARCHAR2 30 ORIG_SYSTEM in HZ_ORIG_SYSTEMS_VL
LOAD_REQUEST_ID NUMBER 18 Request Id of the Job which loads the data to interface tables
INTERFACE_DATA_TYPE VARCHAR2 100 Data type of record. Values-BATCH/SUPPLIER_STAGE/SPOKE_STAGE
COMPONENTS_TO_EXCLUDE CLOB This column stores the Comma Seperated component Ids to be excluded while performing copy operation
SUPPLIER_ID NUMBER 18 Unique identifier for supplier in case of supplier stage record

Indexes

Index Uniqueness Tablespace Columns Status
EGP_STRUCTURES_INTERFACE_N1 Non Unique FUSION_TS_INTERFACE ASSEMBLY_ITEM_ID, ORGANIZATION_ID, ALTERNATE_BOM_DESIGNATOR Active
EGP_STRUCTURES_INTERFACE_N10 Non Unique FUSION_TS_INTERFACE BATCH_ID, PREPROCESS_THREAD_NUMBER, PROCESS_STATUS, THREAD_NUMBER, PHASE_NUMBER Active
EGP_STRUCTURES_INTERFACE_N11 Non Unique Default BATCH_ID, PREPROCESS_THREAD_NUMBER, PROCESS_STATUS, ITEM_NUMBER
EGP_STRUCTURES_INTERFACE_N13 Non Unique Default LOAD_REQUEST_ID
EGP_STRUCTURES_INTERFACE_N2 Non Unique FUSION_TS_INTERFACE BILL_SEQUENCE_ID Active
EGP_STRUCTURES_INTERFACE_N3 Non Unique FUSION_TS_INTERFACE COMMON_BILL_SEQUENCE_ID Active
EGP_STRUCTURES_INTERFACE_N5 Non Unique FUSION_TS_INTERFACE PROCESS_STATUS, ORGANIZATION_ID, TRANSACTION_ID Active
EGP_STRUCTURES_INTERFACE_N6 Non Unique FUSION_TS_INTERFACE ITEM_NUMBER, ORGANIZATION_CODE, ALTERNATE_BOM_DESIGNATOR Active
EGP_STRUCTURES_INTERFACE_N7 Non Unique FUSION_TS_INTERFACE BATCH_ID, SOURCE_SYSTEM_REFERENCE, PREPROCESS_THREAD_NUMBER, PROCESS_STATUS Active
EGP_STRUCTURES_INTERFACE_N9 Non Unique Default BATCH_NUMBER
EGP_STRUCTURES_INTERFACE_U1 Unique FUSION_TS_INTERFACE TRANSACTION_ID Active
EGP_STRUCTURE_INTERFACE_N12 Non Unique Default BATCH_ID, PROCESS_STATUS, ORGANIZATION_ID, NVL("ITEM_NUMBER", "TRANSACTION_ID")