1. Tables and Views for Financials
  2. XLA_FSN_EVENTS_INT

XLA_FSN_EVENTS_INT

This table contains the set of events that is to be processed by a run of the accounting engine.

Details

  • Schema: FUSION

  • Object owner: XLA

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Columns

Name Datatype Length Precision Not-null Comments Status
REPORT_REQUEST_ID NUMBER 18 Yes Request identifier of original request.
PARENT_REQUEST_ID NUMBER 18 Yes Request identifier of parent request.
EVENT_SET_ID NUMBER 18 Yes Event set that this event has been grouped into.
PROCESSING_ORDER NUMBER 18 Yes Order on how accounting events are processed.
APPLICATION_ID NUMBER 18 Yes Functional area within a software suite of products. For example, Financials or Payroll.
EVENT_ID NUMBER 18 Yes Identifier of the categorization of accounting events that is unique within an application and event class.
ENTITY_ID NUMBER 18 Yes Identifies subledger transactions associated with the accounting events.
LEDGER_ID NUMBER 18 Yes Self-contained accounting information set for single or multiple legal or management entities.
ENTITY_CODE VARCHAR2 30 Yes Entity code of transaction event.
EVENT_CLASS_CODE VARCHAR2 30 Yes Unique abbreviated name assigned to an event class and used for reporting or in reference to an option.
EVENT_TYPE_CODE VARCHAR2 30 Yes Unique abbreviated name assigned to an event type and used for reporting or in reference to an option.
EVENT_NUMBER NUMBER 18 Yes Identifying number of an accounting event.
EVENT_DATE DATE Yes Date when an accounting event is created.
EVENT_STATUS_CODE VARCHAR2 1 Yes Event status code at the start of the run.
PROCESS_STATUS_CODE VARCHAR2 1 Yes Event process status at the start of the run.
TRANSACTION_NUMBER VARCHAR2 240 Transaction number associated with the transaction entity of the event.
SOURCE_ID_INT_1 NUMBER 18 Source identifier associated with the transaction entity of the event.
SOURCE_ID_INT_2 NUMBER 18 Source identifier associated with the transaction entity of the event.
SOURCE_ID_INT_3 NUMBER 18 Source identifier associated with the transaction entity of the event.
SOURCE_ID_INT_4 NUMBER 18 Source identifier associated with the transaction entity of the event.
SOURCE_ID_CHAR_1 VARCHAR2 30 Source identifier associated with the transaction entity of the event.
SOURCE_ID_CHAR_2 VARCHAR2 30 Source identifier associated with the transaction entity of the event.
SOURCE_ID_CHAR_3 VARCHAR2 30 Source identifier associated with the transaction entity of the event.
SOURCE_ID_CHAR_4 VARCHAR2 30 Source identifier associated with the transaction entity of the event.
LEGAL_ENTITY_ID NUMBER 18 Legal entity associated with the transaction entity of the event.
LINE_NUMBER NUMBER 18 Not currently used.
EVENT_CREATED_BY VARCHAR2 100 Not currently used.
REFERENCE_NUM_1 NUMBER Additional reference information for event.
REFERENCE_NUM_2 NUMBER Additional reference information for event.
REFERENCE_NUM_3 NUMBER Additional reference information for event.
REFERENCE_NUM_4 NUMBER Additional reference information for event.
REFERENCE_CHAR_1 VARCHAR2 240 Additional reference information for event.
REFERENCE_CHAR_2 VARCHAR2 240 Additional reference information for event.
REFERENCE_CHAR_3 VARCHAR2 240 Additional reference information for event.
REFERENCE_CHAR_4 VARCHAR2 240 Additional reference information for event.
REFERENCE_DATE_1 DATE Additional reference information for event.
REFERENCE_DATE_2 DATE Additional reference information for event.
REFERENCE_DATE_3 DATE Additional reference information for event.
REFERENCE_DATE_4 DATE Additional reference information for event.
VALUATION_METHOD VARCHAR2 30 Valuation method associated with the transaction entity of the event.
SECURITY_ID_INT_1 NUMBER 18 Not currently used.
SECURITY_ID_INT_2 NUMBER 18 Not currently used.
SECURITY_ID_INT_3 NUMBER 18 Not currently used.
SECURITY_ID_CHAR_1 VARCHAR2 30 Not currently used.
SECURITY_ID_CHAR_2 VARCHAR2 30 Not currently used.
SECURITY_ID_CHAR_3 VARCHAR2 30 Not currently used.
OLD_HOLD_FLAG VARCHAR2 1 Not currently used.
TRANSACTION_DATE DATE Date on which transaction occurred.
BUDGETARY_CONTROL_FLAG VARCHAR2 1 Budgetary control flag of an event.
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.
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_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of 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.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
ACCOUNTING_BATCH_ID NUMBER 18 Stores XLA_AE_HEADERS.ACCOUNTING_BATCH_ID
LOCKING_REQUEST_ID NUMBER 18 The request identifier for the accounting engine that has locked the event for processing in an accounting run. The value is blank if the engine is not able to lock the event.

Indexes

Index Uniqueness Tablespace Columns
XLA_FSN_EVENTS_INT_U1 Unique FUSION_TS_TX_DATA REPORT_REQUEST_ID, PARENT_REQUEST_ID, PROCESSING_ORDER, EVENT_SET_ID, EVENT_ID