GL_AUTORUN_RUN_NOTIFY
This table contains the specific ledger and error categories that will be processed by each report submission for an automation run.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
GL_AUTORUN_RUN_NOTIFY_PK |
AUTORUN_REQUEST_ID, REPORT_SUBMISSION_ID, LEDGER_ID, ERROR_CATEGORY_CODE, JE_SOURCE_NAME |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| AUTORUN_REQUEST_ID | NUMBER | 18 | Yes | Automation run request identifier. | |
| REPORT_SUBMISSION_ID | NUMBER | 18 | Yes | Report submission identifier. Each report submission may combine what would otherwise be multiple reports intended for different users as long as those users have access to exactly the same set of ledgers and error categories. | |
| 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 should be sent. A source of ALL means that notificiations will be sent to this user for all errors, regardless of the journal source. | |
| DERIVED_ROW_FLAG | VARCHAR2 | 1 | Indicates if the notification record has been derived from a primary ledger or ledger set notification. | ||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| GL_AUTORUN_RUN_NOTIFY | gl_autorun_runs | AUTORUN_REQUEST_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| GL_AUTORUN_RUN_NOTIFY_U1 | Unique | Default | AUTORUN_REQUEST_ID, REPORT_SUBMISSION_ID, LEDGER_ID, ERROR_CATEGORY_CODE, JE_SOURCE_NAME |