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.

[Home] [Help]

Table: MSC_EXCEPTION_DETAILS

Product:	MSC - Advanced Supply Chain Planning
Description:	This table stores the details of exceptions generated by Oracle Advanced Planning and Scheduling(APS) and Oracle Supply Chain Hub products.
Implementation/DBA Data:	MSC.MSC_EXCEPTION_DETAILS

Primary Key: MSC_EXCEPTION_DETAILS_PK

PLAN_ID
SR_INSTANCE_ID
EXCEPTION_DETAIL_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
MSC_EXCEPTION_DETAILS	MSC_SYSTEM_ITEMS	MSC_EXCEPTION_DETAILS.INVENTORY_ITEM_ID MSC_EXCEPTION_DETAILS.PLAN_ID MSC_EXCEPTION_DETAILS.SR_INSTANCE_ID MSC_EXCEPTION_DETAILS.ORGANIZATION_ID
MSC_EXCEPTION_DETAILS	MSC_DEPARTMENT_RESOURCES	MSC_EXCEPTION_DETAILS.PLAN_ID MSC_EXCEPTION_DETAILS.ORGANIZATION_ID MSC_EXCEPTION_DETAILS.RESOURCE_ID MSC_EXCEPTION_DETAILS.SR_INSTANCE_ID MSC_EXCEPTION_DETAILS.DEPARTMENT_ID
MSC_EXCEPTION_DETAILS	MSC_ITEM_EXCEPTIONS	MSC_EXCEPTION_DETAILS.PLAN_ID MSC_EXCEPTION_DETAILS.EXCEPTION_TYPE MSC_EXCEPTION_DETAILS.INVENTORY_ITEM_ID MSC_EXCEPTION_DETAILS.ORGANIZATION_ID MSC_EXCEPTION_DETAILS.SR_INSTANCE_ID