GL_BAL_CUBE_CONCURRENCY
GL_BAL_CUBE_CONCURRENCY contains information for a ledger if Oracle General ledger balances are not synchronized with GL Balances Cube balances. Each row in this table stores entity information such as ledger identifier and name as 'LEDGER'.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
GL_BAL_CUBE_CONCURRENCY_PK |
CUBE_CONC_ENTITY_NAME, CUBE_CONC_ENTITY_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CUBE_CONC_ENTITY_NAME | VARCHAR2 | 30 | Yes | User entered name of the entity. | |
| CUBE_CONC_ENTITY_ID | VARCHAR2 | 240 | Yes | Unique identifier of the entity. | |
| POSTING_RUN_ID | NUMBER | 18 | Posting run identifying column. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who 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. | |
| JOURNAL_BATCHES | CLOB | Oracle internal use only. |