GL_PERIOD_PARTITIONS
This table stores information about the partitioning of Oracle Fusion General Ledger tables by period and partition grouping. Each row contains the period stored in the partition, the partition grouping stored in the partition, the table that is partitioned, the name of the associated partition, and the status of the partition. If the partition has been archived and purged, it contains the name of the table in which the partition was archived.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
GL_PERIOD_PARTITIONS_PK |
TABLE_NAME, PERIOD_NAME, PARTITION_GROUP_CODE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PERIOD_NAME | VARCHAR2 | 15 | Yes | Accounting calendar period contained in a partition. | |
| TABLE_NAME | VARCHAR2 | 30 | Yes | Database table that has been partitioned. | |
| PARTITION_NAME | VARCHAR2 | 128 | Yes | Name of the partition that contains the specified period for the specified table. | |
| STATUS_CODE | VARCHAR2 | 30 | Yes | Status of that partition. Some valid values are ORA_CREATED, ORA_ARCHIVED, and ORA_ARCHIVED_NO_DATA. | |
| ARCHIVE_TABLE_NAME | VARCHAR2 | 30 | Name of the table that stores the archived data for this period. | ||
| ARCHIVE_ROW_COUNT | NUMBER | 18 | Number of rows archived and purged. | ||
| ERRORS_OVERRIDDEN_FLAG | VARCHAR2 | 1 | Oracle internal use only. | ||
| 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. | |
| PARTITION_GROUP_CODE | VARCHAR2 | 15 | Yes | Partition grouping contained in the partition. | |
| CALENDAR_ID | NUMBER | 18 | Yes | Calendar associated with the partition. | |
| PERIOD_YEAR | NUMBER | 18 | Yes | Fiscal year of the period contained in the partition. | |
| EFFECTIVE_PERIOD_NUM | NUMBER | 18 | Yes | Effective period number of the period contained in the partition. | |
| ALLOW_ARCHIVE_FLAG | VARCHAR2 | 1 | Yes | Indicates whether this partition can be archived. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| GL_PERIOD_PARTITIONS_N1 | Non Unique | Default | TABLE_NAME, CALENDAR_ID, EFFECTIVE_PERIOD_NUM |
| GL_PERIOD_PARTITIONS_U1 | Unique | Default | TABLE_NAME, PERIOD_NAME, PARTITION_GROUP_CODE |
| GL_PERIOD_PARTITIONS_U2 | Unique | Default | TABLE_NAME, PARTITION_NAME |