GL_PURGE_SETUP_
This table stores information about the archive and purge of data for each business object. It stores whether archive and purge is enabled, whether partitioning has been done, and whether the PARTITION_GROUP_CODE and PERIOD_NAME columns have been populated for historical data.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
GL_PURGE_SETUP_PK_ |
LAST_UPDATE_DATE, LAST_UPDATED_BY, BUSINESS_OBJECT_CODE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BUSINESS_OBJECT_CODE | VARCHAR2 | 30 | Yes | Business object for which archive and purge setup is being done. Some valid values are ORA_GL_JOURNALS and ORA_GL_BALANCES. | |
| ARCHIVE_AND_PURGE_ENABLED_FLAG | VARCHAR2 | 1 | Indicates whether archive and purge should be done for this business object. | ||
| PARTITIONING_STATUS_CODE | VARCHAR2 | 30 | Indicates the status of the table partitioning. Some valid values are ORA_SUBMITTED, ORA_RUNNING, ORA_SUCCESS, ORA_VALIDATION_ERROR, and ORA_FATAL_ERROR. | ||
| UPGRADE_STATUS_CODE | VARCHAR2 | 30 | Indicates the status of the population of the PARTITION_GROUP_CODE and PERIOD_NAME columns for historical data. Some valid values are ORA_SUBMITTED, ORA_RUNNING, ORA_SUCCESS, and ORA_FATAL_ERROR. | ||
| PARTITIONING_REQUEST_ID | NUMBER | 18 | Enterprise Services Scheduler request that partitioned the table. | ||
| CREATION_DATE | TIMESTAMP | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | 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. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | 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. | |||
| RETENTION_LOCATION_CODE | VARCHAR2 | 30 | Location where the archived data, which is no longer used, is being retained for the legal retention period. Valid values are ORA_EXTERNAL for external storage and ORA_LOCAL for Oracle Fusion Cloud ERP. | ||
| RETENTION_CONTROL_LEVEL_CODE | VARCHAR2 | 30 | Level at which to retain the archived data for the specified number of years. Only applicable if the retention location is Oracle Fusion Cloud ERP. Valid values are ORA_BUSINESS_OBJECT, ORA_LEDGER, and ORA_LEGAL_ENTITY. | ||
| RETENTION_YEARS | NUMBER | 5 | Default number of years to retain the archived data for the business object. Only applicable if the retention location is Oracle Fusion Cloud ERP. | ||
| TRANSACTION_RETENTION_YEARS | NUMBER | 5 | The number of years the transaction data for a business object to be retained before it can be archived. | ||
| AUDIT_ACTION_TYPE_ | VARCHAR2 | 10 | Action Type - have values like INSERT, UPDATE and DELETE. | ||
| AUDIT_CHANGE_BIT_MAP_ | VARCHAR2 | 1000 | Used to store a bit map of 1s and 0s for each column in the table. | ||
| AUDIT_IMPERSONATOR_ | VARCHAR2 | 64 | Original Impersonator User. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| GL_PURGE_SETUP_N1_ | Non Unique | Default | BUSINESS_OBJECT_CODE |
| GL_PURGE_SETUP_U1_ | Unique | Default | LAST_UPDATE_DATE, LAST_UPDATED_BY, BUSINESS_OBJECT_CODE |