Interactions

Interactions

Archive or Purge
Archive
Commit Type (Default)
ALL_OR_NOTHING
Commit Parameters (Default)
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.