GL_AUTORUN_SETUP_NOTIFY
This table keeps track of who should be notified when issues occur for a specific ledger and error category.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
GL_AUTORUN_SETUP_NOTIFY_PK |
AUTORUN_NOTIFY_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
AUTORUN_NOTIFY_ID | NUMBER | 18 | Yes | Automation notification record unique identifier. | |
LEDGER_ID | NUMBER | 18 | Yes | edger for which notifications may be sent. A ledger identifier of -99 means notifications will be sent for all ledgers as well as in cases where the ledger is unknown. | |
ERROR_CATEGORY_CODE | VARCHAR2 | 30 | Yes | Error category for which notifications may be sent. An error category of ALL means that notifications will be sent to this user for all errors for this ledger, regardless of the error category of those errors. | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
JE_SOURCE_NAME | VARCHAR2 | 25 | Yes | Journal source for which notifications should be sent. A source of ALL means that notifications will be sent to this user for all errors, regardless of the journal source. | |
ROLE_NAME | VARCHAR2 | 256 | Role to which notifications should be sent. Notifications will be sent to all users with this role. |
Foreign Keys
Table | Foreign Table | Foreign Key Column |
---|---|---|
gl_autorun_setup_notify_users | gl_autorun_setup_notify | AUTORUN_NOTIFY_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
GL_AUTORUN_SETUP_NOTIFY_U1 | Unique | Default | AUTORUN_NOTIFY_ID |
GL_AUTORUN_SETUP_NOTIFY_U2 | Unique | Default | LEDGER_ID, ERROR_CATEGORY_CODE, JE_SOURCE_NAME, ROLE_NAME |