GL_SEGVAL_INHERIT_HISTORY
GL_SEGVAL_INHERIT_HISTORY keeps track of the segment value attribute maintenance records for each chart of accounts. For each chart of accounts for which the Segment Value Inheritance program has been run, there exists a row in this table. That row indicates the date and time on which the Segment Value Inheritance program was last run for this chart of accounts.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
GL_SEGVAL_INHERIT_HISTORY_PK |
CHART_OF_ACCOUNTS_ID, REQUEST_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CHART_OF_ACCOUNTS_ID | NUMBER | 18 | Yes | Key flexfield structure defining column. | |
| LAST_RUN_DATE | DATE | Yes | Date and time on which the Segment Value Inheritance program was last run for this chart of accounts. | ||
| 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 | Yes | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |
| PROGRAM_APPLICATION_ID | NUMBER | 18 | Identifies the Oracle Application that spawned the concurrent program. | ||
| PROGRAM_ID | NUMBER | 18 | Yes | Identifies the concurrent program. | |
| PROGRAM_UPDATE_DATE | DATE | Oracle internal use only. | |||
| 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 | Tablespace | Columns |
|---|---|---|---|
| GL_SEGVAL_INHERIT_HISTORY_U1 | Unique | Default | CHART_OF_ACCOUNTS_ID, REQUEST_ID |