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

TABLE: ASG.ASG_ERROR

Object Details
Object Name: ASG_ERROR
Object Type: TABLE
Owner: ASG
FND Design Data: TableASG.ASG_ERROR
Subobject Name:
Status: VALID


Stores information of error logs.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ASG_ERROR_U1 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnMOBILE_ERROR_ID
Columns
Name Datatype Length Mandatory Comments
MOBILE_ERROR_ID NUMBER
Yes PK column
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER
Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
DEVICE_USER_ID NUMBER

FK to ASG_DEVICE_USERS
TYPE VARCHAR2 (30)
Type. 'E' Error, 'N' Notification
PRIORITY NUMBER

Severity.
STATUS VARCHAR2 (1)
Status.'A' = Active, 'I' = InActive
APPLICATION_ID NUMBER

Associated application
RESPONSIBILITY_ID NUMBER

responsibility id
SYNCHRONOUS_EVENT VARCHAR2 (1)
Flag to indicate if the event is synchronous.
ERROR_DAYS_DEFAULT NUMBER

default error days
ERROR_TIME_DEFAULT VARCHAR2 (6)
default error time
ERROR_DESCRIPTION VARCHAR2 (2048)
error description
SECURITY_GROUP_ID NUMBER

Used in hosted environments
Query Text

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


SELECT MOBILE_ERROR_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      DEVICE_USER_ID
,      TYPE
,      PRIORITY
,      STATUS
,      APPLICATION_ID
,      RESPONSIBILITY_ID
,      SYNCHRONOUS_EVENT
,      ERROR_DAYS_DEFAULT
,      ERROR_TIME_DEFAULT
,      ERROR_DESCRIPTION
,      SECURITY_GROUP_ID
FROM ASG.ASG_ERROR;

Dependencies

[top of page]

ASG.ASG_ERROR does not reference any database object

ASG.ASG_ERROR is referenced by following:

SchemaASG
ViewASG_ERROR#