WFLOAD OEXWFOI.wft ORA-1: Unique Constraint WF_ACTIVITY_ATTRIBUTES_TL_U2 (Doc ID 1196633.1)

Last updated on JUNE 12, 2016

Applies to:

Oracle Order Management - Version 12.1.1 and later
Information in this document applies to any platform.
WFLOAD
OEXWFOI.wft

Symptoms

On : 12.1.1 version, Install / Upgrade

When upgrading from 11.5.10.2 to 12.1 received the error while running WFLOAD on @ONT:patch/115/import/US/oexwfoi.wft,

ERROR
-----------------------

wferr:
- 1602: Could not save.
- 1400: Could not save to database. MODE=UPGRADE EFFDATE=<null>
- 1401: Could not upload ACTIVITY entity 'OEOI/RUN_ORDER_IMPORT'.
- 1401: Could not upload ATTRIBUTE entity '<null>/ARG10'.
- 210: Oracle Error: ORA-00001: unique constraint (APPLSYS.WF_ACTIVITY_ATTRIBUTES_TL_U2) violated
ORA-01403: no data found
ORA-06512: at "APPS.WF_LOAD", line 1713
ORA-06512: at line 1. SQL text: BEGIN WF_LOAD.UPLOAD_ACTIVITY_ATTRIBUTE(
:activity_item_type, :activity_name, :activity_version, :name, :display_name, :description,
:sequence, :type, :protect, :custom, :subtype, :format, :default, :value_type, :level_error); END;


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