GL_PURGE_TRACKING_DETAILS
This table stores the purge status of a business object, ledger, or legal entity. It is used only when the retention location for the archived data is Oracle Cloud ERP. If the archived data is retained at the business object level, then this table will have one row for each combination of calendar and business object. If the archived data is retained at the ledger level, then this table will have one row for each combination of ledger, calendar, and business object. If the archived data is retained at the legal entity level, then this table will have one row for each combination of legal entity, ledger, calendar, and business object as well as one row for each combination of ledger, calendar, and business object. This second set of ledger-only rows will be used to track the purge status of data with no associated legal entity.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
GL_PURGE_TRACKING_DETAILS_PK |
BUSINESS_OBJECT_CODE, CALENDAR_ID, LEDGER_ID, LEGAL_ENTITY_ID, BALANCING_SEGMENT_VALUE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| BUSINESS_OBJECT_CODE | VARCHAR2 | 30 | Yes | Business object for which the archived data was purged. Some valid values are ORA_GL_JOURNALS for General Ledger Journals and ORA_GL_BALANCES for General Ledger Balances. | |
| CALENDAR_ID | NUMBER | 18 | Yes | Accounting calendar identifier associated with the archived data that was purged. | |
| PERIOD_SET_NAME | VARCHAR2 | 15 | Yes | Accounting calendar name associated with the archived data that was purged. | |
| PERIOD_TYPE | VARCHAR2 | 15 | Yes | Period type for the accounting calendar associated with the archived data that was purged. | |
| LEDGER_ID | NUMBER | 18 | Yes | Identifier of the primary ledger, secondary ledger, or reporting currency for which the archived data was purged. A value of -99 indicates the row applies to all ledgers. | |
| LEGAL_ENTITY_ID | NUMBER | 18 | Yes | Identifier of the legal entity for which the archived data was purged. A value of -99 indicates this row applies to all legal entities. | |
| LAST_PURGED_YEAR | NUMBER | 18 | Yes | Fiscal year that contains the latest period that was successfully purged for this combination of business object, calendar, ledger (if applicable), and legal entity (if applicable). A value of 0 indicates that no period has been purg | |
| LAST_PURGED_PERIOD_NUM | NUMBER | 18 | Yes | Period number of the latest period that was successfully purged for this combination of business object, calendar, ledger (if applicable), and legal entity (if applicable). A value of 0 indicates that no period has been purged yet. | |
| LAST_PURGED_END_DATE | DATE | Yes | End date of the latest period that was successfully purged for this combination of business object, calendar, ledger (if applicable), and legal entity (if applicable). A value of January 1, 1900 indicates that no period has been purged yet. | ||
| NEXT_UNPURGED_END_DATE | DATE | Yes | End date of the earliest period that has not yet been successfully purged for this combination of business object, calendar, ledger (if applicable), and legal entity (if applicable). A value of January 1, 1900 indicates that no period has been purged yet. | ||
| 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. | ||
| 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. | |
| BALANCING_SEGMENT_VALUE | VARCHAR2 | 25 | Yes | Balancing segment value associated with the specified retention period. A value of -99 indicates all balancing segment values. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| GL_PURGE_TRACKING_DETAILS_U1 | Unique | Default | BUSINESS_OBJECT_CODE, CALENDAR_ID, LEDGER_ID, LEGAL_ENTITY_ID, BALANCING_SEGMENT_VALUE |