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

Last updated on SEPTEMBER 05, 2017

Applies to:

Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.

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);

--



Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms