Purge Recent Objects
Use the Purge Recent Objects scheduled process to remove objects from the DOO_UI_RECENT_OBJECTS database table.
When to Use
An earlier release of Oracle Order Management displayed a page in the Order Management work area that listed the actions the user had recently performed on sales orders, order lines, and fulfillment lines. You can't use this feature anymore but Order Management still saves these actions in the DOO_UI_RECENT_OBJECTS database table. Over time, the table might become very large and use up a lot of storage space and affect performance. You can use the Purge Recent Objects scheduled process to keep that from happening.
Privileges Required
- Purge Orchestration Order Recent Objects (DOO_PURGE_ORCHESTRATION_ORDER_RECENT_OBJECTS_PRIV)
Specifications
Use these specifications when you run the scheduled process.
Specification | Description |
---|---|
Job Type | Scheduled. |
Frequency | One time every 30 days. |
Time of Day | After business hours. |
Duration | Varies depending on the parameters that you set when you run the scheduled process. |
Compatibility | You can run more than one instance of this scheduled process at the same time. However, to avoid conflicts, we recommend that you run only one instance at a time. |
Parameters
Use these parameters to filter the data that the scheduled process will look at.
Parameter | Description |
---|---|
Object |
Select one of these entities:
|
Purge Date |
Specify the latest date that you want to delete data. For example, if you want to delete all actions that the user performed on and before May 1, 2023, then set this parameter to May 1, 2023. The process won't delete any actions that the user performed after May 1, 2023. If you set only the Purge Date or only the User ID, then the scheduled process will delete all records from the table. If you need to delete an object according to date, then you must set the Object parameter and the Purge Date parameter. |
User ID | Select a value that uniquely identifies the user who performed
the action. If you need to delete an object according to user, then you must set Object and User ID. |
You don't need any of this data. We strongly recommend that you don't set any parameter values, and the scheduled process will delete all records from DOO_UI_RECENT_OBJECTS.
We're providing this information for reference purposes only:
- All parameters are optional.
- No special combinations are required.
- You can use attributes to filter the data to delete. For example, set Object to Orders and set user ID to Elaine Cho, and the scheduled process will delete all actions that Elaine performed on all sales orders.
For important details, see Guidelines for Using Scheduled Processes in Order Management.