Purge Engineering Change Orders in All Related Tables

The Engineering Change Order Purge program now ensures that all tables involved in the creation of change orders, irrespective of the source application, are considered during the purge process, eliminating any residual records, and ensuring data integrity.

Prior to Release 12.2.15, this program did not fully consider all change order-related Product Hub tables.

A new executable using the PL/SQL Stored Procedure method has been created and attached to the Engineering Change Order Purge concurrent program.

Two new value sets have been introduced.s have been introduced.

ENG_STS_PURGE_ECO_ORG_ID - Attached to organization parameter to display the list of organization accessible ENG_STS_PURGE_ECO_ORG_ID - Attached to organization parameter to display the list of organizations accessible by current user ENG_ECO_PURGE_MODE - For defining Change Order Purge Mode Parameter

ENG_ECO_PURGE_MODE - For defining Change Order Purge Mode Parameter - Select Validate to run validations and view generated report. Select Purge to permanently remove relevant data.

ECO Purge Concurrent Program

ECO Purge Concurrent Program

Change Order Purge Mode

Change Order Purge Mode

Steps to Enable

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

Tips And Considerations

For Diagnosis and Troubleshooting:

Set MRP: Debug Mode to Yes to print detailed information included in the concurrent Program logs.

Details such as the change order and revised item being purged are stored as CLOB entries in a new generic diagnostics table (ENG_PROCESS_LOG_INFO), linked to the concurrent request ID.

For development and debugging purposes, additional debug messages will be printed in the concurrent program log when the following profile options are set to the values indicated.

FND: Debug Log Enabled - Yes

FND: Debug Log Level - Statement

MRP: Debug Mode - Yes

MRP Debug Mode Change Order Purge Program Action Logging Details
Yes Purge Purges all Change Orders

Concurrent Program Parameters, Change Orders,Revised item, Count of records updated / deleted in each table,Additional debug messages
Yes Validate Does not purge Change Orders

Concurrent Program Parameters, Change Orders,Revised item, Count of records updated / deleted in each table,Additional debug messages
No Purge Purges all Change Orders Concurrent Program Parameters, Change Orders
No Validate Does not purge Change Orders

Concurrent Program Parameters, Change Orders,Revised item, Count of records updated / deleted in each table

Key Resources

  • Oracle E-Business Suite News and Information: oracle.com/ebs
  • Oracle E-Business Suite Product Documentation: https://docs.oracle.com/cd/E26401_01/index.htm
  • Oracle University: https://www.oracle.com/education
  • Oracle Support: https://www.oracle.com/support