JG_FSCL_IMPORT_ERRORS
This table stores tax authority return information which could not be processed due to errors such as invalid fiscal document key.
Details
-
Schema: FUSION
-
Object owner: JG
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
JG_FSCL_IMPORT_ERRORS_PK |
IMPORT_ERROR_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| IMPORT_ERROR_ID | NUMBER | 18 | Yes | Interface identifier of the process error. | |
| PARENT_TABLE | VARCHAR2 | 30 | Yes | Reference to the source table in which the error occurred during the Import Fiscal Document Approval Information process. Possible values are JG_FSCL_TAX_AUTH_RET_INT, JG_FSCL_TAX_AUTH_TAXES_INT and JG_FSCL_TAX_AUTH_MSG_INT. | |
| PARENT_ID | NUMBER | 18 | Yes | Reference to return interface identifier of the source table in which the error occurred during the Import Fiscal Document Approval Information process. Possible values are the correspondent identifications to the tables JG_FSCL_TAX_AUTH_RET_INT, JG_FSCL_TAX_AUTH_TAXES_INT and JG_FSCL_TAX_AUTH_MSG_INT. | |
| 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. | |
| 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_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the interface load job that created 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. | |
| MESSAGE_NAME | VARCHAR2 | 240 | Standard message name for the validation error. | ||
| MESSAGE_TEXT | VARCHAR2 | 1000 | Message text providing details of the validation error. | ||
| MESSAGE_CAUSE | VARCHAR2 | 1000 | Message cause associated with the error. | ||
| MESSAGE_USER_ACTION | VARCHAR2 | 1000 | User action that can be performed for the error condition. | ||
| TOKEN1_NAME | VARCHAR2 | 60 | Oracle internal use only. | ||
| TOKEN1_VALUE | VARCHAR2 | 240 | Oracle internal use only. | ||
| TOKEN2_NAME | VARCHAR2 | 60 | Oracle internal use only. | ||
| TOKEN2_VALUE | VARCHAR2 | 240 | Oracle internal use only. | ||
| TOKEN3_NAME | VARCHAR2 | 60 | Oracle internal use only. | ||
| TOKEN3_VALUE | VARCHAR2 | 240 | Oracle internal use only. | ||
| TOKEN4_NAME | VARCHAR2 | 60 | Oracle internal use only. | ||
| TOKEN4_VALUE | VARCHAR2 | 240 | Oracle internal use only. | ||
| TOKEN5_NAME | VARCHAR2 | 60 | Oracle internal use only. | ||
| TOKEN5_VALUE | VARCHAR2 | 240 | Oracle internal use only. | ||
| TOKEN6_NAME | VARCHAR2 | 60 | Oracle internal use only. | ||
| TOKEN6_VALUE | VARCHAR2 | 240 | Oracle internal use only. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| JG_FSCL_IMPORT_ERRORS_N1 | Non Unique | Default | LOAD_REQUEST_ID |
| JG_FSCL_IMPORT_ERRORS_U1 | Unique | Default | IMPORT_ERROR_ID |
| JG_FSCL_IMPORT_ERRORS_U2 | Unique | Default | PARENT_TABLE, PARENT_ID, LOAD_REQUEST_ID, MESSAGE_NAME |