1. Tables and Views for Sales and Fusion Service
  2. HZ_PARTIES_PURGE_LOG

HZ_PARTIES_PURGE_LOG

This Table keeps log for Parties Purge ESS

Details

  • Schema: FUSION

  • Object owner: HZ

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

HZ_PARTIES_PURGE_LOG_PK

PURGE_OBJECT_FILTER, CREATION_DATE, PURGE_FILTER_ID

Columns

Name Datatype Length Precision Not-null Comments
PURGE_FILTER_ID NUMBER 18 Yes PURGE_FILTER_ID
PURGE_MODE VARCHAR2 30 PURGE_MODE
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
PURGE_OBJECT_FILTER VARCHAR2 30 Yes PURGE_OBJECT_FILTER
PROC_NAME VARCHAR2 30 PROC_NAME
STATUS VARCHAR2 30 STATUS
TOTAL_COUNT NUMBER TOTAL_COUNT
EXCEPTION_MESSAGE VARCHAR2 300 EXCEPTION_MESSAGE
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
SUCCESS_COUNT NUMBER SUCCESS_COUNT
FAILURE_COUNT NUMBER FAILURE_COUNT
ENABLED_FLAG_FILTER VARCHAR2 1 ENABLED_FLAG_FILTER
CREATED_BY_FILTER VARCHAR2 120 CREATED_BY_FILTER
CREATION_DATE_FILTER TIMESTAMP CREATION_DATE_FILTER
ORIG_SYSTEM_FILTER VARCHAR2 120 ORIG_SYSTEM_FILTER
ORIG_SYSTEM_REFERENCE_FILTER VARCHAR2 120 ORIG_SYSTEM_REFERENCEFILTER
LAST_UPDATE_DATE_FILTER TIMESTAMP LAST_UPDATE_DATE_FILTER
AGED_BY_FILTER NUMBER 9 AGED_BY_FILTER
PARTY_NUMBER_FILTER VARCHAR2 30 PARTY_NUMBER_FILTER
STATUS_FILTER VARCHAR2 300 STATUS_FILTER
CREATED_BY_MODULE_FILTER VARCHAR2 30 CREATED_BY_MODULE_FILTER
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created 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.

Indexes

Index Uniqueness Tablespace Columns
HZ_PARTIES_PURGE_LOG_U1 Unique Default PURGE_OBJECT_FILTER, CREATION_DATE, PURGE_FILTER_ID