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 |
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 |
|
|
|