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_ITEM_EXCEPTIONS

Product:	MSC - Advanced Supply Chain Planning
Description:	This table stores a row per exception message against an item for exceptions generated in the Oracle Advanced planning and scheduling (APS) and the Oracle Supply Chain Hub products.
Implementation/DBA Data:	MSC.MSC_ITEM_EXCEPTIONS

Primary Key: MSC_ITEM_EXCEPTIONS_PK

PLAN_ID
EXCEPTION_TYPE
INVENTORY_ITEM_ID
ORGANIZATION_ID
SR_INSTANCE_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
MSC_ITEM_EXCEPTIONS	MSC_SYSTEM_ITEMS	MSC_ITEM_EXCEPTIONS.INVENTORY_ITEM_ID MSC_ITEM_EXCEPTIONS.PLAN_ID MSC_ITEM_EXCEPTIONS.SR_INSTANCE_ID MSC_ITEM_EXCEPTIONS.ORGANIZATION_ID
MSC_ITEM_EXCEPTIONS	MSC_DEPARTMENT_RESOURCES	MSC_ITEM_EXCEPTIONS.PLAN_ID MSC_ITEM_EXCEPTIONS.ORGANIZATION_ID MSC_ITEM_EXCEPTIONS.RESOURCE_ID MSC_ITEM_EXCEPTIONS.SR_INSTANCE_ID MSC_ITEM_EXCEPTIONS.DEPARTMENT_ID
MSC_ITEM_EXCEPTIONS	MSC_PROJECTS	MSC_ITEM_EXCEPTIONS.PLAN_ID MSC_ITEM_EXCEPTIONS.SR_INSTANCE_ID MSC_ITEM_EXCEPTIONS.PROJECT_ID MSC_ITEM_EXCEPTIONS.ORGANIZATION_ID
MSC_ITEM_EXCEPTIONS	MSC_PROJECT_TASKS	MSC_ITEM_EXCEPTIONS.ORGANIZATION_ID MSC_ITEM_EXCEPTIONS.TASK_ID MSC_ITEM_EXCEPTIONS.PROJECT_ID MSC_ITEM_EXCEPTIONS.SR_INSTANCE_ID MSC_ITEM_EXCEPTIONS.PLAN_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