GL_AUTORUN_RUN_NOTIFY_GT
This table is for internal use only. This table keeps track of what users should be notified about automation issues and for which combination of ledgers, error categories, and journal sources they should be notified.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
GL_AUTORUN_RUN_NOTIFY_GT_PK |
USER_ID, LEDGER_ID, ERROR_CATEGORY_CODE, JE_SOURCE_NAME |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| USER_ID | NUMBER | 18 | Yes | User to be notified when an issue occurs. | |
| LEDGER_ID | NUMBER | 18 | Yes | Ledger for which notifications will 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 will be sent. An error category of ALL means that notifications will be sent for all ledgers as well as in cases where the ledger is unknown. | |
| JE_SOURCE_NAME | VARCHAR2 | 25 | Yes | Journal source for which notifications will be sent. A source of ALL means that notificiations will be sent to this user for all errors, regardless of the journal source. | |
| REPORT_CRITERIA_ID | NUMBER | 18 | Yes | Report criteria identifier. Each distinct combination of ledger, error category, and journal source is assigned a different report criteria identifier. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| GL_AUTORUN_RUN_NOTIFY_GT_N1 | Non Unique | REPORT_CRITERIA_ID |
| GL_AUTORUN_RUN_NOTIFY_GT_U1 | Unique | USER_ID, LEDGER_ID, ERROR_CATEGORY_CODE, JE_SOURCE_NAME |