ZCA_PARTY_PURGE_LOGS
After GDPR uptake, ESS purge job will be removing all the references of purged accounts and contacts from the transaction table of BusinessPlans,Objectives,Quotes,Sales Orders.We need to maintain a traceability to understand which all records in our tables had undergone an update during Account or Contact purge.This will help us to debug any issue that the customer reports, if they see that any contact/account that was associated to the consuming object has been wiped off.To maintain traceability, this table is introduced, which will just record the details/primary key of the transaction record that has underwent the change.
Details
-
Schema: FUSION
-
Object owner: ZCA
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
ZCA_PARTY_PURGE_LOGS_PK |
PARTY_PURGE_LOG_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PARTY_PURGE_LOG_ID | NUMBER | 18 | Yes | Unique primary key identifier for the party purge log records. | |
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| OBJECT_TABLE_TYPE | VARCHAR2 | 40 | Yes | Indicates the name of the object getting updated during party purge process. eg: ZCA_BP_BUSINESS_PLANS | |
| OBJECT_ID | NUMBER | 18 | Yes | Unique identifier of the object that's being updated during party purge. eg: BP_ID. | |
| PURGE_OBJECT_TYPE | VARCHAR2 | 20 | Yes | Indicates the party type that is getting updated during purge. It can have two values ORA_ACCOUNTS, ORA_CONTACTS. | |
| 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. | |
| 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_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. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ZCA_PARTY_PURGE_LOGS_U1 | Unique | Default | PARTY_PURGE_LOG_ID |