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_X_EXCEPTION_DETAILS

Object Details

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

This table contains exceptions generated in Oracle Collaborative planning.
This table can be populated by:
1. The Supply Chain Event Manager program which generates exceptions based on data
in MSC_SUP_DEM_ENTRIES table in Oracle Collaborative planning.
2. Custom exceptions defined in Oracle Collaborative planning.
The Exceptions page for viewing seeded and custom exceptions in Oracle Collaborative
planning is based on this table.
All the exceptions in this table correspond to the lookup MSC_X_EXCEPTION_TYPE.
This table is deleted at the end of a complete refresh from the source.
Exception notifications are generated from the supply chain event manager for data in this table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MSC_X_EXCEPTION_DETAILS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	EXCEPTION_DETAIL_ID
MSC_X_EXCEPTION_DETAILS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COMPANY_ID COMPANY_SITE_ID INVENTORY_ITEM_ID EXCEPTION_TYPE EXCEPTION_GROUP
MSC_X_EXCEPTION_DETAILS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXCEPTION_TYPE EXCEPTION_GROUP CUSTOMER_ID CUSTOMER_SITE_ID
MSC_X_EXCEPTION_DETAILS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUPPLIER_ID SUPPLIER_SITE_ID
MSC_X_EXCEPTION_DETAILS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID1
MSC_X_EXCEPTION_DETAILS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID2
MSC_X_EXCEPTION_DETAILS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COMPANY_ID EXCEPTION_TYPE ITEM_NAME
MSC_X_EXCEPTION_DETAILS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_NAME COMPANY_ID EXCEPTION_TYPE
MSC_X_EXCEPTION_DETAILS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUPPLIER_NAME COMPANY_ID EXCEPTION_TYPE
MSC_X_EXCEPTION_DETAILS_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PLAN_ID VERSION EXCEPTION_GROUP

Columns

Name	Datatype	Length	Mandatory	Comments
EXCEPTION_DETAIL_ID	NUMBER		Yes	Exception detail identifier
PLAN_ID	NUMBER			Plan identifier
SR_INSTANCE_ID	NUMBER			Source application instance identifier
EXCEPTION_TYPE	NUMBER			Exception type
EXCEPTION_TYPE_NAME	VARCHAR2	(80)		Exception type name
EXCEPTION_GROUP	NUMBER			Exception group
EXCEPTION_GROUP_NAME	VARCHAR2	(80)		Exception group name
COMPANY_ID	NUMBER			Company identifier
COMPANY_NAME	VARCHAR2	(255)		Company name
COMPANY_SITE_ID	NUMBER			Company site identifier
COMPANY_SITE_NAME	VARCHAR2	(40)		Company site name
SUPPLIER_ID	NUMBER			Supplier identifier
SUPPLIER_NAME	VARCHAR2	(255)		Supplier name
SUPPLIER_SITE_ID	NUMBER			Supplier site identifier
SUPPLIER_SITE_NAME	VARCHAR2	(40)		Supplier site name
CUSTOMER_ID	NUMBER			Customer identifier
CUSTOMER_NAME	VARCHAR2	(255)		Customer name
CUSTOMER_SITE_ID	NUMBER			Customer site identifier
CUSTOMER_SITE_NAME	VARCHAR2	(40)		Customer site name
INVENTORY_ITEM_ID	NUMBER			Inventory item identifier
ITEM_NAME	VARCHAR2	(250)		Item name
TRADING_PARTNER_ITEM_NAME	VARCHAR2	(250)		Trading partner item name
TRANSACTION_ID1	NUMBER			Transaction identifier 1
TRANSACTION_ID2	NUMBER			Transaction idenfitifier 2
TRANSACTION_ID3	NUMBER			Transaction identifier 3
ORDER_NUMBER	VARCHAR2	(240)		Order number
RELEASE_NUMBER	VARCHAR2	(20)		Release number
LINE_NUMBER	VARCHAR2	(20)		Line number
END_ORDER_NUMBER	VARCHAR2	(240)		Pegged order number
END_ORDER_REL_NUMBER	VARCHAR2	(20)		Pegged order release number
END_ORDER_LINE_NUMBER	VARCHAR2	(20)		Pegged order line number
VERSION	VARCHAR2	(80)		Version
ORDER_CREATION_DATE1	DATE			Order creation date 1
ORDER_CREATION_DATE2	DATE			Order creation date 2
DATE1	DATE			Date 1
DATE2	DATE			Date 2
DATE3	DATE			Date 3
DATE4	DATE			Date 4
DATE5	DATE			Date 5
DATE6	DATE			Date 6
DATE7	DATE			Date 7
NUMBER1	NUMBER			Number 1
NUMBER2	NUMBER			Number 2
NUMBER3	NUMBER			Number 3
NUMBER4	NUMBER			Number 4
NUMBER5	NUMBER			Number 5
NUMBER6	NUMBER			Number 6
NUMBER7	NUMBER			Number 7
LEAD_TIME	NUMBER			Lead time
ITEM_MIN_QTY	NUMBER			Item minimum quantity
ITEM_MAX_QTY	NUMBER			Item maximum quantity
THRESHOLD	NUMBER			Threshold
USER_ATTRIBUTE1	VARCHAR2	(240)		Descriptive flexfield segment
USER_ATTRIBUTE2	VARCHAR2	(240)		Descriptive flexfield segment
USER_ATTRIBUTE3	VARCHAR2	(240)		Descriptive flexfield segment
USER_ATTRIBUTE4	VARCHAR2	(240)		Descriptive flexfield segment
USER_ATTRIBUTE5	VARCHAR2	(240)		Descriptive flexfield segment
USER_ATTRIBUTE6	VARCHAR2	(240)		Descriptive flexfield segment
USER_ATTRIBUTE7	VARCHAR2	(240)		Descriptive flexfield segment
USER_ATTRIBUTE8	VARCHAR2	(240)		Descriptive flexfield segment
USER_ATTRIBUTE9	VARCHAR2	(240)		Descriptive flexfield segment
USER_ATTRIBUTE10	VARCHAR2	(240)		Descriptive flexfield segment
USER_ATTRIBUTE11	VARCHAR2	(240)		Descriptive flexfield segment
USER_ATTRIBUTE12	VARCHAR2	(240)		Descriptive flexfield segment
USER_ATTRIBUTE13	VARCHAR2	(240)		Descriptive flexfield segment
USER_ATTRIBUTE14	VARCHAR2	(240)		Descriptive flexfield segment
USER_ATTRIBUTE15	VARCHAR2	(240)		Descriptive flexfield segment
USER_ATTRIBUTE16	VARCHAR2	(240)		Descriptive flexfield segment
USER_ATTRIBUTE17	VARCHAR2	(240)		Descriptive flexfield segment
USER_ATTRIBUTE18	VARCHAR2	(240)		Descriptive flexfield segment
USER_ATTRIBUTE19	VARCHAR2	(240)		Descriptive flexfield segment
USER_ATTRIBUTE20	VARCHAR2	(240)		Descriptive flexfield segment
CREATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
NUMBER8	NUMBER			Number 8
NUMBER9	NUMBER			Number 9
NUMBER10	NUMBER			Number 10
ITEM_DESCRIPTION	VARCHAR2	(240)		Item description
OWNING_COMPANY_ID	NUMBER			Owning company identifier
CUSTOMER_ITEM_NAME	VARCHAR2	(250)		Customer item name
SUPPLIER_ITEM_NAME	VARCHAR2	(250)		Supplier item name
REPLENISHMENT_METHOD	NUMBER			VMI replenishment method
EXCEPTION_BASIS	VARCHAR2	(100)		Basis for computing exceptions: Ship/Dock

Query Text

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


SELECT EXCEPTION_DETAIL_ID
,      PLAN_ID
,      SR_INSTANCE_ID
,      EXCEPTION_TYPE
,      EXCEPTION_TYPE_NAME
,      EXCEPTION_GROUP
,      EXCEPTION_GROUP_NAME
,      COMPANY_ID
,      COMPANY_NAME
,      COMPANY_SITE_ID
,      COMPANY_SITE_NAME
,      SUPPLIER_ID
,      SUPPLIER_NAME
,      SUPPLIER_SITE_ID
,      SUPPLIER_SITE_NAME
,      CUSTOMER_ID
,      CUSTOMER_NAME
,      CUSTOMER_SITE_ID
,      CUSTOMER_SITE_NAME
,      INVENTORY_ITEM_ID
,      ITEM_NAME
,      TRADING_PARTNER_ITEM_NAME
,      TRANSACTION_ID1
,      TRANSACTION_ID2
,      TRANSACTION_ID3
,      ORDER_NUMBER
,      RELEASE_NUMBER
,      LINE_NUMBER
,      END_ORDER_NUMBER
,      END_ORDER_REL_NUMBER
,      END_ORDER_LINE_NUMBER
,      VERSION
,      ORDER_CREATION_DATE1
,      ORDER_CREATION_DATE2
,      DATE1
,      DATE2
,      DATE3
,      DATE4
,      DATE5
,      DATE6
,      DATE7
,      NUMBER1
,      NUMBER2
,      NUMBER3
,      NUMBER4
,      NUMBER5
,      NUMBER6
,      NUMBER7
,      LEAD_TIME
,      ITEM_MIN_QTY
,      ITEM_MAX_QTY
,      THRESHOLD
,      USER_ATTRIBUTE1
,      USER_ATTRIBUTE2
,      USER_ATTRIBUTE3
,      USER_ATTRIBUTE4
,      USER_ATTRIBUTE5
,      USER_ATTRIBUTE6
,      USER_ATTRIBUTE7
,      USER_ATTRIBUTE8
,      USER_ATTRIBUTE9
,      USER_ATTRIBUTE10
,      USER_ATTRIBUTE11
,      USER_ATTRIBUTE12
,      USER_ATTRIBUTE13
,      USER_ATTRIBUTE14
,      USER_ATTRIBUTE15
,      USER_ATTRIBUTE16
,      USER_ATTRIBUTE17
,      USER_ATTRIBUTE18
,      USER_ATTRIBUTE19
,      USER_ATTRIBUTE20
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      NUMBER8
,      NUMBER9
,      NUMBER10
,      ITEM_DESCRIPTION
,      OWNING_COMPANY_ID
,      CUSTOMER_ITEM_NAME
,      SUPPLIER_ITEM_NAME
,      REPLENISHMENT_METHOD
,      EXCEPTION_BASIS
FROM MSC.MSC_X_EXCEPTION_DETAILS;

Dependencies

[top of page]

MSC.MSC_X_EXCEPTION_DETAILS does not reference any database object

MSC.MSC_X_EXCEPTION_DETAILS is referenced by following:

APPS: MSC_X_EXCEPTION_DETAILS