Interactions

Interactions

Archive or Purge

Archive

Commit Type (Default)

ALL_OR_NOTHING

Commit Parameters (Default)

Default Aging Days

1096 days

Tables affected

RECIPIENT_MESSAGE

MESSAGE WORKFLOW_PROCESS

BUSINESS_OBJECT

BO_MESSAGE_HISTORY

MESSAGE_HEADER

Description/Notes

Moves all interactions to the archive schema. This process involves moving:

1. All data from the BUSINESS_OBJECT table where busobj_create_date is before the aging date and business object status is ACCEPTED, REJECTED, or CANCELLED.
2. All data from WORKFLOW_PROCESS table for the business objects identified in #1.
3. All the data from MESSAGE table where msg_id is in the msg_id’s from the business objects from business_object and bo_object_history tables for the business objects identified in #1.
4. All the data from RECIPIENT_MESSAGE table where msg_id is in the msg_id’s from the business objects from business_object and bo_object_history tables for the business objects identified in #1.
5. All data from BO_MESSAGE_HISTORY table for the business objects identified in #1.
6. All data from MESSAGE_HEADER table for the recipient messages identified in #4.