1. Implementing Order Management
  2. Delete Records That Don't Contain Transaction Data

Delete Records That Don't Contain Transaction Data

Delete records that don't contain transaction data, such as the actions you do while managing a sales order. Deleting these records can improve performance.

For example, Oracle Order Management creates a request and saves it each time you do an action on a fulfillment line in the Order Management work area, such as override a scheduled ship date, unreserve, and so on. Order Management keeps this data even after it closes the sales order or fulfillment line. Accumulating entities over time doesn't affect Order Management's behavior, but it can have a negative impact on performance.

The scheduled process:

  • Doesn't delete any transaction data on the sales order, such customer, item, quantity, shipping data, and so on.

  • Deletes only nontransactional data for orders and lines that are closed. It doesn't delete data about actions or errors on orders or lines that aren't closed yet.

We strongly recommend that you periodically run the scheduled process.

Try it.

  1. Make sure you have this privilege:

    • Delete Nontransactional Entities From Closed Sales Orders (DOO_DELETE_NONTRANSACTIONAL_ENTITIES_FROM_CLOSED_SALES_ORDERS_PRIV)
  2. Go to the Scheduled Processes work area.

  3. If you need to delete entities from closed fulfilment lines, then go to the next step.

    If you need to delete entities from closed sales orders, then you must run the Update or Close Sales Orders scheduled process first, and then run the Delete Nontransactional Entities from Closed Sales Orders and Fulfillment Lines scheduled process:

    • On the Scheduled Process page, click Actions > Schedule New Process.
    • In the Schedule New Process dialog, click the down arrow, click Search, then search for the value.

      Attribute

      Value

      Name

      Update or Close Sales Orders

      Wait for the process to finish successfully.

  4. Delete entities that don't contain transactional data:
    • On the Scheduled Process page, click Actions > Schedule New Process.

    • In the Schedule New Process dialog, click the down arrow, click Search, then search for the value.

      Attribute

      Value

      Name

      Delete Nontransactional Entities from Closed Sales Orders and Fulfillment Lines

    • Click the line in the search results, then click OK > OK.

    • In the Process Details dialog, set the values.

      Parameter

      Value

      Retention Days

      Number of days to keep entities that don't contain transactional data.

      The default value is 60.

      The minimum value is 10.

      Assume you enter 10. The scheduled process will delete all nontransactional entities in sales orders that were closed more than 10 days ago. If the current system date is June 16, 2024, then the scheduled process will delete data on sales orders that were closed on June 6, 2024 or earlier.
      Batch Size

      Number of nontransactional entities to process.

      Comes predefined with a default value of 10,000.

      Number of Child Processes

      Number of child processes to run for each instance of Delete Nontransactional Entities from Closed Sales Orders and Fulfillment Lines.

      Comes predefined with a default value of 4.

      The minimum value is 1.

      The maximum value is 16.

  5. Click Advanced > Using a Schedule, then set the values.

    Specification Description
    Job Type Scheduled or as needed.
    Frequency

    Set it according to the number of order lines that you close each day:

    • Less than 300,000. Once a week.
    • 300,000 to 750,000. Twice a week.
    • Over 750,000. Three times a week.

    These are general guidelines. You might need to run it more or less frequently, depending on your requirements.
    Time of Day Any time, but we recommend you run it when there's not a lot processing going on. For example, 2 AM.
    Duration Varies, depending the number of closed order lines to process.
    Compatibility You can run only one instance of this scheduled process at a time.

  6. Click Notification, then select someone who can monitor the results, such as an order administrator.

  7. Click Submit.

For important details, see Guidelines for Using Scheduled Processes in Order Management.

Reference

The scheduled process deletes data from these tables for closed sales orders and fulfillment lines:

  • DOO_ACTION_REQUESTS
  • DOO_ACTION_REQUEST_ATTRIBUTES
  • DOO_MESSAGE_REQUESTS
  • DOO_MESSAGE_SUMMARY_STATUSES
  • DOO_MESSAGE_ENTITIES
  • DOO_MESSAGES_B
  • DOO_MESSAGES_TL
  • DOO_ERROR_RECOVERY_INSTANCES
  • DOO_TASK_BATCH_REQUESTS

The scheduled process deletes data from these tables for closed sales orders:

  • DOO_ORDER_STATES
  • DOO_AGGREGATION_HEADERS
  • DOO_AGGREGATION_TASK_INSTANCES