My Oracle Support Banner

How to Purge Product Hub Change Order Tables ENG_CHANGE_ROUTE_PEOPLE_TL And ENG_CHANGE_ROUTE_STEPS_TL Tables ? -- Not possible (Doc ID 2514042.1)

Last updated on MAY 02, 2023

Applies to:

Oracle Product Hub - Version 12.2.5 and later
Information in this document applies to any platform.

Goal

ENG_CHANGE_ROUTE_PEOPLE_TL and ENG_CHANGE_ROUTE_STEPS_TL are used to store Product Hub Change WF routes and WF steps for Product Hub Change Orders. Presently, there is no standard program available to purge Product Hub related change orders. The standard Engineering Change Order Purge program is available that purges Engineering Change Order related information for Closed / Cancelled ECOs from the Core ENG tables. However, Product Hub uses a lot of additional tables to support the advanced features like User-defined attributes, Extensible workflows, Lifecycles etc.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution
 1. Datafix
 2. Idea (Future consideration)
 3. Patches (to help reduce / maintain data)
 4. Related Purge Programs (available) 
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.