Previous  Next          Contents    Library

Deleting Objects in Oracle Workflow Builder

You can now delete an object in Oracle Workflow Builder even if the object is referenced by other objects, assuming the object is not protected against customizations. If the object you want to delete is referenced by other objects, a Workflow Error dialog box appears, warning you about the foreign key references that will break. You can proceed to delete the object anyway or cancel the action. If you choose to delete, then when you save or verify the workflow process definition, a Workflow Error dialog box appears, reporting all broken foreign key references that exist in the definition.

As a result of this change, you can now load workflow definitions with invalid foreign keys into Oracle Workflow Builder to correct. Oracle Workflow Builder preserves the original internal name reference for any missing foreign key, and displays it in a validation error message when you load the process definition. You can restore a broken foreign key reference in a process definition by recreating the deleted object with its original internal name under its original item type.

Note that you can also now copy item types from one store to another in any order even if the item types reference each other. The final process definition in the new store will be valid as long as all referenced item types are copied to the new destination store.

Note: You can now also delete an entire item type definition in Oracle Workflow Builder.

Note: You can use Oracle Workflow Builder to delete item type attributes loaded from a flat file, but to delete item type attributes in a database, you must still use the script wfrmita.sql. See: Wfrmita.sql.

         Previous  Next          Contents    Library