Workflow error: 1302: Loaded definition was incomplete.

Date: 08-Sep-2017

Oracle Version: 12.1.3
Database: 11.2.0.4

Today we will see how to fix below error

1302: Loaded definition was incomplete.  Although this definition may be edited and saved, it cannot be run until references to non-existent objects are corrected or the missing objects are added.

1303: Reference to nonexistent activity 'CVUAWAPR/NOTIFY_APPROVER_PROCESS' in process 'CVUAWAPR/ROOT' step label 'NOTIFY_APPROVER_PROCESS'.

Cause:

When you delete an existing process from item type, it does it delete from workflow table.

Even when you save the modified workflow to database from Workflow builder or when you use WFLOAD FORCE command you still get this error.

Solution:

To fix the issue with no-brainer call $wfrmitt.sql script which will delete, Oracle Workflow design time and runtime tables for a particular item type.

sqlplus apps/<pwd> @wfrmitt.sql

Cheers...

Thanks for visiting my blog.