XLA_TRANSFER_LOGS
This table contains the transfer to General Ledger log information. This information is used to recover the failed transfer to General Ledger requests. The log information is deleted once the transfer the batch is recovered or if the transfer request completes successfully.
Details
-
Schema: FUSION
-
Object owner: XLA
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
XLA_TRANSFER_LOGS_PK |
GROUP_ID, LEDGER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| GROUP_ID | NUMBER | 18 | Yes | Interface group identifying column. | |
| LEDGER_ID | NUMBER | 18 | Yes | Self-contained accounting information set for single or multiple legal or management entities. | |
| APPLICATION_ID | NUMBER | 18 | Yes | Functional area within a software suite of products. For example, Financials or Payroll. | |
| GLLEZL_REQUEST_ID | NUMBER | 18 | Journal import request identifier. | ||
| PARENT_GROUP_ID | NUMBER | 18 | Yes | Interface group identifier of the ledger for which the transfer request was submitted. If the transfer request is submitted for a primary ledger then it is the group identifier of the primary ledger journal import request. If the transfer request is submitted for a secondary ledger then it is the group identifier of the secondary ledger journal import request. | |
| TRANSFER_STATUS_CODE | VARCHAR2 | 30 | Yes | Transfer to accounting status code. The possible values are 'I' - Incomplete. | |
| 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. | ||
| 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. | ||
| 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. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| XLA_TRANSFER_LOGS_U1 | Unique | GROUP_ID, LEDGER_ID |
| XLA_TRANSFER_LOGS_N1 | Non Unique | PARENT_GROUP_ID |