GL_PURGE_TRACKING
This table stores the archive and purge status for each business object and fiscal year. It stores the current stage of archive and purge, the status of that stage, as well as the Enterprise Service Scheduler requests that executed prior stages.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
GL_PURGE_TRACKING_PK |
BUSINESS_OBJECT_CODE, CALENDAR_ID, PERIOD_RANGE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BUSINESS_OBJECT_CODE | VARCHAR2 | 30 | Yes | Business object for which archive and purge is being done. Some valid values are ORA_GL_JOURNALS and ORA_GL_BALANCES. | |
| CALENDAR_ID | NUMBER | 18 | Yes | Calendar for which archive and purge is being done. | |
| PERIOD_RANGE_ID | NUMBER | 18 | Yes | Period range for which archive and purge is being done. Currently always maps to a single fiscal year and contains that year. | |
| PERIOD_YEAR | NUMBER | 18 | Yes | Fiscal year for which archive and purge is being done. | |
| START_PERIOD_NUM | NUMBER | 18 | Yes | Period number of the first period in the period range. Currently always maps to the period number of the first period in the fiscal year, which will always be 1. | |
| END_PERIOD_NUM | NUMBER | 18 | Yes | Period number of the last period in the period range. Currently always maps to the period number of the last period in the fiscal year. | |
| CURRENT_STAGE_CODE | VARCHAR2 | 30 | Yes | Current overall stage of the archive and purge for the business object and fiscal year. Some valid values are ORA_NEW, ORA_VALIDATE, ORA_ARCHIVE_AND_PURGE, ORA_ARCHIVE_TO_STORAGE, and ORA_CLEAR_ARCHIVE_TABLES. | |
| STATUS_CODE | VARCHAR2 | 30 | Yes | Status within the overall stage. Some valid values are ORA_SUBMITTED, ORA_RUNNING, ORA_SUCCESS, ORA_WARNING, ORA_VALIDATION_ERROR, and ORA_FATAL_ERROR. | |
| ERRORS_OVERRIDDEN_FLAG | VARCHAR2 | 1 | Indicates whether validation errors were overridden. | ||
| VALIDATION_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler request that validated whether the business object and fiscal year was ready for archive and purge. | ||
| PURGE_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler request that archived and purged the data for this business object and fiscal year. | ||
| STORAGE_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler request that archived to storage the data for this business object and fiscal year. | ||
| CLEANUP_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler request that cleared the archive tables for this business object and fiscal year. | ||
| 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. | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| PARTITION_REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: Indicates the request ID of the job request to partition the data for this business object |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| GL_PURGE_TRACKING_U1 | Unique | Default | BUSINESS_OBJECT_CODE, CALENDAR_ID, PERIOD_RANGE_ID |