eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: MSC.MSC_EXCEPTION_DETAILS

Object Details

Object Name:	MSC_EXCEPTION_DETAILS
Object Type:	TABLE
Owner:	MSC
FND Design Data:	MSC.MSC_EXCEPTION_DETAILS
Subobject Name:
Status:	VALID

This table stores the details of exceptions generated by Oracle Advanced Planning and Scheduling
(APS) and Oracle Supply Chain Hub products.

Storage Details

Tablespace:
PCT Free:
PCT Used:

Indexes

Index	Type	Uniqueness	Column
MSC_EXCEPTION_DETAILS_U1	NORMAL	UNIQUE	PLAN_ID EXCEPTION_DETAIL_ID SR_INSTANCE_ID
MSC_EXCEPTION_DETAILS_N1	NORMAL	NONUNIQUE	PLAN_ID EXCEPTION_TYPE ORGANIZATION_ID SR_INSTANCE_ID INVENTORY_ITEM_ID DEPARTMENT_ID RESOURCE_ID
MSC_EXCEPTION_DETAILS_N2	NORMAL	NONUNIQUE	PLAN_ID INVENTORY_ITEM_ID ORGANIZATION_ID SR_INSTANCE_ID EXCEPTION_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
EXCEPTION_DETAIL_ID	NUMBER		Yes	Exception detail identifier
EXCEPTION_TYPE	NUMBER		Yes	Type of exception resource, material
QUANTITY	NUMBER			Exception quantity
DATE1	DATE			Generic date column
DATE2	DATE			Generic date column
DATE3	DATE			Generic date column
DATE4	DATE			Generic date column
NUMBER1	NUMBER			Generic number column
NUMBER2	NUMBER			Generic number column
NUMBER3	NUMBER			Generic number column
NUMBER4	NUMBER			Generic number column
CHAR1	VARCHAR2	(80)		Generic character column
CHAR2	VARCHAR2	(80)		Generic character column
PLAN_ID	NUMBER		Yes	Plan identifier
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
RESOURCE_ID	NUMBER		Yes	Resource identifier
DEPARTMENT_ID	NUMBER		Yes	Department identifer or Line identifier
SR_INSTANCE_ID	NUMBER		Yes	Source application instance identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
REQUEST_ID	NUMBER			Concurrent Who column
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Who column
PROGRAM_ID	NUMBER			Concurrent Who column
PROGRAM_UPDATE_DATE	DATE			Concurrent Who column
SUPPLIER_ID	NUMBER			Supplier identifier
SUPPLIER_SITE_ID	NUMBER			Supplier site identifier
CUSTOMER_ID	NUMBER			Customer Identifier
CUSTOMER_SITE_ID	NUMBER			Customer Site Identifier
ORDER_NUMBER	VARCHAR2	(240)		Order number
ORDER_REL_NUMBER	VARCHAR2	(20)		Release Number
ORDER_LINE_NUMBER	VARCHAR2	(20)		Line Number
END_ORDER_NUMBER	VARCHAR2	(240)		End Order Number
END_ORDER_REL_NUMBER	VARCHAR2	(20)		End order release number
END_ORDER_LINE_NUMBER	VARCHAR2	(20)		End order line number
DATE5	DATE			Generic date column
NUMBER5	NUMBER			Generic number column
TRANSACTION_ID	NUMBER			map to transaction_id in msc_supplies table
DEMAND_ID	NUMBER			map to demand_id in msc_demands table
ACTION_TAKEN	NUMBER			indicate if this exception detail has been deleted
NUMBER6	NUMBER			Generic number column
NUMBER7	NUMBER			Generic number column
NUMBER8	NUMBER			Generic number column
CAUSE	NUMBER
NEW_EXCEPTION	NUMBER
ACTION_TAKEN_BY	NUMBER
ACTION_TAKEN_DATE	DATE
FIRST_GENERATED_DATE	DATE
PART_CONDITION	NUMBER
ZONE_ID	NUMBER
DATE6	DATE

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT EXCEPTION_DETAIL_ID
,      EXCEPTION_TYPE
,      QUANTITY
,      DATE1
,      DATE2
,      DATE3
,      DATE4
,      NUMBER1
,      NUMBER2
,      NUMBER3
,      NUMBER4
,      CHAR1
,      CHAR2
,      PLAN_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      RESOURCE_ID
,      DEPARTMENT_ID
,      SR_INSTANCE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
,      CUSTOMER_ID
,      CUSTOMER_SITE_ID
,      ORDER_NUMBER
,      ORDER_REL_NUMBER
,      ORDER_LINE_NUMBER
,      END_ORDER_NUMBER
,      END_ORDER_REL_NUMBER
,      END_ORDER_LINE_NUMBER
,      DATE5
,      NUMBER5
,      TRANSACTION_ID
,      DEMAND_ID
,      ACTION_TAKEN
,      NUMBER6
,      NUMBER7
,      NUMBER8
,      CAUSE
,      NEW_EXCEPTION
,      ACTION_TAKEN_BY
,      ACTION_TAKEN_DATE
,      FIRST_GENERATED_DATE
,      PART_CONDITION
,      ZONE_ID
,      DATE6
FROM MSC.MSC_EXCEPTION_DETAILS;

Dependencies

[top of page]

MSC.MSC_EXCEPTION_DETAILS does not reference any database object

MSC.MSC_EXCEPTION_DETAILS is referenced by following:

MSC: MSC_EXCEPTION_DETAILS#