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

TABLE: MSC.MSC_USER_EXCEPTIONS

Object Details
Object Name: MSC_USER_EXCEPTIONS
Object Type: TABLE
Owner: MSC
FND Design Data: TableMSC.MSC_USER_EXCEPTIONS
Subobject Name:
Status: VALID


MSC_USER_EXCEPTIONS is the header table for user defined exceptions. It stores attributes such as the name and the schedule for the user defined exception.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
EXCEPTION_ID NUMBER
Yes Unique identfier for user defined exception. The value is set to > 1000 to differentiate from seeded exceptions.
NAME VARCHAR2 (80) Yes Name of the user defined exception.
DESCRIPTION VARCHAR2 (240)
Description of the exception.
REGION_CODE VARCHAR2 (30) Yes region code of the ak region that contains exception attribute metadata.
COMPANY_ID NUMBER (15)
Company of the user who created the exception.
SECURITY_FLAG VARCHAR2 (1)
Not used.
WF_ITEM_TYPE VARCHAR2 (8)
Item Type of workflow process that gets triggered for each result row of the exception.
WF_PROCESS VARCHAR2 (30)
Workflow process within the item type for the workflow process that gets triggered for each result row of the exception.
WF_LAUNCH_FLAG VARCHAR2 (1)
Always 0
NOTIFICATION_TEXT VARCHAR2 (2000)
Text of the notification to be sent for generated result rows.
REQUEST_ID NUMBER

request id of the concurrent request that runs this custom exception.
START_FLAG VARCHAR2 (1)
Always NULL.
RECURRENCE_FLAG VARCHAR2 (1)
Type of recurrence: 0 Never
EVENT VARCHAR2 (240)
Not used.
START_DATE DATE

Start date for running the exception.
REPEAT_INTERVAL NUMBER

Number of units of REPEAT_TYPE
REPEAT_TYPE VARCHAR2 (10)
MINUTES, HOURS, DAYS, MONTHS
REPEAT_END_TIME DATE

For repeating exceptions repeat until this date and time.
LAST_RUN_DATE DATE

Last time exception was run in canonical text format.
FULL_DATA_FLAG VARCHAR2 (1)
Always NULL.
REFRESH_NUMBER NUMBER

Controls refresh of exception data on rerunning the exception.
LAST_UPDATE_DATE DATE
Yes WHO field.
LAST_UPDATED_BY NUMBER
Yes WHO field
CREATION_DATE DATE
Yes WHO field
CREATED_BY NUMBER
Yes WHO field
LAST_UPDATE_LOGIN NUMBER

WHO field
ATTRIBUTE1 VARCHAR2 (240)
Flexfield column
ATTRIBUTE2 VARCHAR2 (240)
Flexfield column
ATTRIBUTE3 VARCHAR2 (240)
Flexfield column
ATTRIBUTE4 VARCHAR2 (240)
Flexfield column
ATTRIBUTE5 VARCHAR2 (240)
Flexfield column
ATTRIBUTE6 VARCHAR2 (240)
Flexfield column
ATTRIBUTE7 VARCHAR2 (240)
Flexfield column
ATTRIBUTE8 VARCHAR2 (240)
Flexfield column
ATTRIBUTE9 VARCHAR2 (240)
Flexfield column
ATTRIBUTE10 VARCHAR2 (240)
Flexfield column
ATTRIBUTE11 VARCHAR2 (240)
Flexfield column
ATTRIBUTE12 VARCHAR2 (240)
Flexfield column
ATTRIBUTE13 VARCHAR2 (240)
Flexfield column
ATTRIBUTE14 VARCHAR2 (240)
Flexfield column
ATTRIBUTE15 VARCHAR2 (240)
Flexfield column
CONTEXT VARCHAR2 (30)
Flexfield column
Query Text

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


SELECT EXCEPTION_ID
,      NAME
,      DESCRIPTION
,      REGION_CODE
,      COMPANY_ID
,      SECURITY_FLAG
,      WF_ITEM_TYPE
,      WF_PROCESS
,      WF_LAUNCH_FLAG
,      NOTIFICATION_TEXT
,      REQUEST_ID
,      START_FLAG
,      RECURRENCE_FLAG
,      EVENT
,      START_DATE
,      REPEAT_INTERVAL
,      REPEAT_TYPE
,      REPEAT_END_TIME
,      LAST_RUN_DATE
,      FULL_DATA_FLAG
,      REFRESH_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CONTEXT
FROM MSC.MSC_USER_EXCEPTIONS;

Dependencies

[top of page]

MSC.MSC_USER_EXCEPTIONS does not reference any database object

MSC.MSC_USER_EXCEPTIONS is referenced by following:

SchemaMSC
ViewMSC_USER_EXCEPTIONS#