1. Tables and Views for SCM
  2. EGP_IMPORT_BULKLOAD_RECS

EGP_IMPORT_BULKLOAD_RECS

When Items are bulkloaded, request_id is passed as a parameter to business event. API's subscribing to these events will use this value to query against request_id column in egp_system_items_b. Teams requested for index on request_id to enable faster access to all the bulkloaded records. Since egp_system_items_b table has more than 15 indexes, we are providing the following as alternate solution. This is outcome of discussions with perf team.

Details

  • Schema: FUSION

  • Object owner: EGP

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

EGP_IMPORT_BULKLOAD_RECS_PK

RECORD_ID

Columns

Name Datatype Length Precision Not-null Comments
RECORD_ID NUMBER 18 Yes Attribute indicating the record identifier associated with the specific import record.
COMPONENT_SEQUENCE_ID NUMBER 18 Attribute indicating the primary key associated with the component sequence in the structure import
EFF_LINE_ID NUMBER Attribute indicating the primary key associated with the change order for the items in the import
BILL_SEQUENCE_ID NUMBER 18 Attribute indicating the primary key associated with the item structure
SUB_COMP_SEQUENCE_ID NUMBER 18 An unique identifier for a sub component in a structure.
REQUEST_ID NUMBER 18 Yes Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
INVENTORY_ITEM_ID NUMBER 18 Yes Attribute indicating the Item Identifier
ORGANIZATION_ID NUMBER 18 Yes 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.
REVISION_ID NUMBER 18 Identifies the revision of an item.
CATEGORY_ID NUMBER 18 Category an item is assigned to when during new item creation
CATEGORY_SET_ID NUMBER 18 Collection of items grouped into categories
ITEM_RELATIONSHIP_ID NUMBER 18 Unique identifier for an item relationship.
ITEM_CATEGORY_ASSIGNMENT_ID NUMBER 18 This is the unique identifier of the item category assignment created/updated/deleted by the bulk process. This is the primary key for the table EGP_ITEM_CAT_ASSIGNMENTS
ENTITY_TYPE VARCHAR2 25 Yes Type of the Entity associated to the Item Class and displayed as a column header in a table.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER NUMBER 9 Yes 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.
LOAD_REQUEST_ID NUMBER 18 ESS Request Id for Loading data into interface tables
TRANSACTION_TYPE VARCHAR2 10 Attribute indicating the type of action completed by the import process for the row. It can be create, update, or delete.

Indexes

Index Uniqueness Tablespace Columns
EGP_IMPORT_BULKLOAD_RECS_N1 Non Unique Default REQUEST_ID, ENTITY_TYPE, TRANSACTION_TYPE
EGP_IMPORT_BULKLOAD_RECS_U1 Unique Default RECORD_ID