How To Purge End Dated OMERROR Workflow (Doc ID 2302627.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

Unable to purge end dated OMERROR workflow

Ran query to check:

SELECT COUNT(*)
FROM wf_item_activity_statuses_h
WHERE item_type = 'OMERROR'
AND end_date IS NOT NULL;

COUNT(*)
----------
3200858

SELECT COUNT(*)
FROM wf_items
WHERE item_type = 'OMERROR'
AND end_date IS NOT NULL;

COUNT(*)
----------
0

==

Customer has tried the following:

1. Run "Purge Order Management Workflow" program for parameters :
Workflow Item Type => All Item Types
Attempt to Close => Yes

2. Run scripts:

ont00165.sql

Count of header records before
------------------------------
1597

Count of line records before
----------------------------
563

PL/SQL procedure successfully completed.

Count of header records after
-----------------------------
0

Count of line records after
---------------------------
0

You must enter Commit to Save the Changes and Rollback to Revert.

SQL> commit;

Commit complete.

SQL> @ontd0060.sql

Count before
------------
1355

PL/SQL procedure successfully completed.

Count after
-----------
1119

3. Run purge:
exec WF_PURGE.ITEMS('OMERROR', NULL, SYSDATE, TRUE, TRUE);

--

Changes

Cause

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