My Oracle Support Banner

R12:AP:Upload APINVAPR Invoice Approval Workflow, Getting WF_MESSAGE_ATTRIBUTES_TL_U2 Unique Constraint Error (Doc ID 2428985.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Payables - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

When the workflow 'APINVAPR' is tried to upload to the instance with the WFLOAD FORCE command, getting the following error:

wferr:
- 1602: Could not save.
- 1400: Could not save to database. MODE=FORCE EFFDATE=
- 1401: Could not upload MESSAGE entity 'APINVAPR/DOCUMENT_APPROVAL_MSG'.
- 1401: Could not upload ATTRIBUTE entity '/#HDR_TOTAL_FORMATTED'.
- 210: Oracle Error: ORA-00001: unique constraint (APPLSYS.WF_MESSAGE_ATTRIBUTES_TL_U2) violated
ORA-06512: at "APPS.WF_LOAD", line 1033
ORA-06512: at line 1. SQL text: BEGIN WF_LOAD.UPLOAD_MESSAGE_ATTRIBUTE(:message_type, :message_name, :name, :display_name, :description, :sequence, :type, :subtype, :protect, :custom, :format, :default, :value_type, :attach, :level_error); END;


Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


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