1. Tables and Views for SCM
  2. MSC_EXCEPTION_STORE

MSC_EXCEPTION_STORE

This table stores user edits and notes on exceptions, so they can be persisted across plan runs

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

MSC_EXCEPTION_STORE_PK

EXCEPTION_STORE_ID, PLAN_ID

Columns

Name Datatype Length Precision Not-null Comments
EXCEPTION_STORE_ID NUMBER 18 Yes This is an identifier that together with plan_id, uniquely identifies one row.
TRANSACTION_ID NUMBER 18 This column is referring to msc_exception_details.transaction_id which is preserved across plan runs for existing orders.
EXCEPTION_TYPE NUMBER 18 Yes This column is the numeric type of the exception.
PLAN_ID NUMBER 18 Yes Unique Id of the plan which is associated to the planning cycle.
ORGANIZATION_ID NUMBER 18 Organization identifier of a organization in the plan.
INVENTORY_ITEM_ID NUMBER 18 This is the identifier of the Inventory Item.
ORDER_NUMBER VARCHAR2 240 This is the order number of the demand receiving the material or the supplier of the material.
ORDER_LINE_NUMBER VARCHAR2 25 This is the line number within an order of material.
END_ORDER_NUMBER VARCHAR2 240 Order number of the end demand involved in the exception.
ACTION_TAKEN NUMBER 18 This column indicates if the planner has taken action on the exception. Valid values: 1 (Yes), 2 (No).
ACTION_TAKEN_BY NUMBER 18 This shows the planner identifier.
ACTION_TAKEN_DATE DATE This is the date that the planner took an action about the exception shown.
NOTES_COUNT NUMBER 18 This a numeric value showing the number of notes added by the planner about this exception.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated 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.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
CUSTOMER_ID NUMBER This is the identifier of the customer of the order for which the exception is shown.
CUSTOMER_SITE_ID NUMBER This is the customer site identifier.
DEMAND_CLASS VARCHAR2 80 Demand Class of the demand involved in the exception.
DEMAND_DATE DATE Date of the demand when the material is requested
DEMAND_ID NUMBER Id of the demand receiving the material.
ORDER_TYPE NUMBER Describes Order Type of the order for which the exception is shown.
RESOURCE_ID NUMBER dentifier of the resource involved in the exception.
DEPARTMENT_ID NUMBER Department Identifier of the resource involved in the exception.
START_CONSTRAINT_DATE DATE This column is not currently used.
SUPPLIER_ID NUMBER Id of the supplier shipping the material.
SUPPLIER_SITE_ID NUMBER This is the identifier of the supplier site.
FROM_DATE DATE Start of the date interval for which the exception happened.
TO_DATE DATE End of the date interval for which the exception happened.
DUE_DATE DATE Date of the demand when the material is requested.
QUANTITY NUMBER The quantity of the order for which the exception happened.
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.
DEMAND_TYPE NUMBER Type of order for the material.
RESOURCE_ORG_ID NUMBER This column is not currently used.
LOT_NUMBER VARCHAR2 80 This the lot number for the on-hand lot.
SUB_INV_CODE VARCHAR2 20 This column is not currently used.
END_ORDER_LINE_NUMBER VARCHAR2 250 Line number of the Order of the end demand involved in the exception.

Indexes

Index Uniqueness Tablespace Columns
MSC_EXCEPTION_STORE_U1 Unique Default EXCEPTION_STORE_ID, PLAN_ID