1. Tables and Views for Financials
  2. JG_FSCL_ATRB_INT_ERRORS

JG_FSCL_ATRB_INT_ERRORS

This table stores information about interface data required for generating fiscal document that failed the validation process.

Details

  • Schema: FUSION

  • Object owner: JG

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

JG_FSCL_ATRB_INT_ERRORS_PK

ERROR_ID

Columns

Name Datatype Length Precision Not-null Comments Status
ERROR_ID NUMBER 18 Yes Identifier for text that communicates an error or violation. Active
INTERFACE_HDR_ID NUMBER 18 Interface header identifier of the document. Active
INTERFACE_LINE_ID NUMBER 18 Interface line identifier corresponding to the transaction line during importing transactions. Active
INTERFACE_LINE_DETAIL_ID NUMBER 18 Interface line detail identifier. Active
INTERFACE_HDR_DETAIL_ID NUMBER 18 Interface legal message identifier for a transaction. Active
MESSAGE_TEXT VARCHAR2 1000 Yes Message text associated with the error code. Active
MESSAGE_CAUSE VARCHAR2 1000 Message cause associated with the error code. Active
MESSAGE_USER_ACTION VARCHAR2 1000 Message user action associated with the error code. Active
MESSAGE_NAME VARCHAR2 30 Standard message name for the validation error. Active
TOKEN1_NAME VARCHAR2 60 Oracle internal use only. Active
TOKEN1_VALUE VARCHAR2 240 Oracle internal use only. Active
TOKEN2_NAME VARCHAR2 60 Oracle internal use only. Active
TOKEN2_VALUE VARCHAR2 240 Oracle internal use only. Active
TOKEN3_NAME VARCHAR2 60 Oracle internal use only. Active
TOKEN3_VALUE VARCHAR2 240 Oracle internal use only. Active
TOKEN4_NAME VARCHAR2 60 Oracle internal use only. Active
TOKEN4_VALUE VARCHAR2 240 Oracle internal use only. Active
TOKEN5_NAME VARCHAR2 60 Oracle internal use only. Active
TOKEN5_VALUE VARCHAR2 240 Oracle internal use only. Active
TOKEN6_NAME VARCHAR2 60 Oracle internal use only. Active
TOKEN6_VALUE VARCHAR2 240 Oracle internal use only. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
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. Active
LOAD_REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. Active
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. Active

Indexes

Index Uniqueness Tablespace Columns Status
JG_FSCL_ATRB_INT_ERRORS_N1 Non Unique FUSION_TS_TX_IDX INTERFACE_HDR_ID Active
JG_FSCL_ATRB_INT_ERRORS_N2 Non Unique Default INTERFACE_LINE_ID
JG_FSCL_ATRB_INT_ERRORS_N3 Non Unique Default INTERFACE_LINE_DETAIL_ID
JG_FSCL_ATRB_INT_ERRORS_N4 Non Unique Default INTERFACE_HDR_DETAIL_ID
JG_FSCL_ATRB_INT_ERRORS_U1 Unique FUSION_TS_TX_IDX ERROR_ID Active