Purge Recent Objects

When to Use

An earlier release of Oracle Fusion Cloud 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 Oracle 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: Orders Order Lines Fulfillment Lines
Purge Date	Specify the latest date that you want to delete data. For example, 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.

Parameter

Description

Object

Select one of these entities:

Orders
Order Lines
Fulfillment Lines

Purge Date

Specify the latest date that you want to delete data. For example, 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.