Delete Temporary Data Created When Exploding Configured Items

Use a scheduled process to delete the temporary data created when exploding a configured item.

Realize these benefits:

  • Optimize your database usage. Automatically delete obsolete configuration data so you can free up space and keep temporary tables lean.
  • Improve performance. Simplify configuration, create orders more quickly, and explode your bill of materials more efficiently.
  • Reduce system load. Minimize database contention and improve throughput across Oracle Order Management and Oracle Manufacturing.
  • Smooth operation. Run critical transactions more efficiently without the lag caused by data buildup.

You can now use a scheduled process to delete the temporary data that you create when exploding a configured item. This process helps to maintain optimal database performance and prevents temporary configuration data from accumulating over time, and that improves overall system responsiveness.

Try it:

  1. Go to Home > Tools > Scheduled Processes.
  2. Run the Delete Temporary Data Created When Exploding Configured Items scheduled process.

Note this:

  • Use the From Creation Date parameter and the To Creation Date parameter to filter the tables that you want to delete. For example, set From Creation Date to January 1, 2026 to delete temporary tables for all configured items that you exploded on after January 1.
  • Use the Base Model Item parameter or the Configured Item parameter to identify specific configured items.
  • If you set up a schedule for the scheduled process, then run it during off-peak hours to minimize performance impact. Adjust frequency according to your organization’s order volume and configuration activity.
  • Regularly review the log for the scheduled process to confirm it successfully finished and to track how much data you reduce over time.
  • Use security privileges to restrict access to the scheduled process to system administrators or advanced users.

Steps to Enable and Configure

You don't need to do anything to enable this feature.

Tips And Considerations

  • Make sure all transactions that depend on the exploded data are done before you run the scheduled process.
  • If an external or custom integration depends on temporary configuration data, then review and update it before you set up the scheduled process to run automatically on a schedule.

Key Resources

Access Requirements

Users who are assigned a configured job role that contains these privileges can access this feature:

A new privilege is added in this update to control on who can delete the temporary data created when exploding a configured item.

  • Purge Configured Item Explosions (CTO_PURGE_MATCH_LINES_EXPL_PRIV)

These privileges were available prior to this update.

  • Process Supply Order Interface (DOS_PROCESS_SUPPLY_ORDER_INTERFACE_PRIV)
  • View Supply Orders (DOS_VIEW_SUPPLY_ORDERS_PRIV)
  • Manage Supply Request Exceptions (DOS_MANAGE_SUPPLY_REQUEST_EXCEPTIONS_PRIV)
  • View Supply Order Exceptions and Status (DOS_VIEW_SUPPLY_ORDER_EXCEPTIONS_AND_STATUS_PRIV)