1. Tables and Views for Financials
  2. JG_FSCL_DOC_GEN_ERRORS_ALL

JG_FSCL_DOC_GEN_ERRORS_ALL

This table contains errors found before sending the fiscal document to fiscal authority such as tax calculation error.

Details

  • Schema: FUSION

  • Object owner: JG

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

JG_FSCL_DOC_GEN_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
APPLICATION_ID NUMBER 18 Yes Identifier of a functional area within a software suite of products. For example: Financials, or Payroll. Active
ENTITY_CODE VARCHAR2 30 Yes Entity code of the transaction, which indicates the type of transaction being created. Active
EVENT_CLASS_CODE VARCHAR2 30 Yes Application event class of the transaction, such as requisition, purchase order and agreement, and release. Active
TRX_ID NUMBER 18 Yes System-generated identification number of a transaction. Active
TRX_LINE_ID NUMBER 18 Transaction line identifier of the transaction. Active
TRX_LINE_DETAIL_ID NUMBER 18 Transaction line detail identifier of the transaction. Active
TRX_LEVEL_TYPE VARCHAR2 30 Level at which the transaction line identifier is stored. Possible values are Line, Shipment, and Freight. Active
MESSAGE_NAME VARCHAR2 240 Standard message name for the validation error. 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
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or 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
ORG_ID NUMBER 18 Yes Indicates the identifier of the business unit associated to 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
STATUS VARCHAR2 30 Fiscal document status associated with the transaction, such as in process, sent, finalized, error, denied, or void.
FISCAL_DOC_KEY VARCHAR2 64 Fiscal document access key composed by concatenation of fiscal document number and other fiscal document information. It is used as unique identifier for the tax authority system.
FISCAL_DOC_TYPE VARCHAR2 30 Fiscal document type of the transaction. Possible values are Remittance Fiscal Document, Symbolic Remittance Fiscal Document, and Sale Fiscal Document.
MESSAGE_TEXT VARCHAR2 1000 Yes Message text associated with the error code.
MESSAGE_CAUSE VARCHAR2 1000 Message cause associated with the error code.
MESSAGE_USER_ACTION VARCHAR2 1000 User action associated with the error code.
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 Status
JG_FSCL_DOC_GEN_ERRORS_N1 Non Unique FUSION_TS_TX_IDX APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TRX_LINE_ID, TRX_LINE_DETAIL_ID, TRX_LEVEL_TYPE Active
JG_FSCL_DOC_GEN_ERRORS_N2 Non Unique Default APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, FISCAL_DOC_KEY, FISCAL_DOC_TYPE
JG_FSCL_DOC_GEN_ERRORS_U1 Unique FUSION_TS_TX_IDX ERROR_ID Active