Patch 12794417 Failure: ORA-00001: unique constraint (APPLSYS.FND_MIME_TYPES_U2) violated

(Doc ID 1416894.1)

Last updated on OCTOBER 06, 2016

Applies to:

Oracle Application Install - Version 12.0.1 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.


When attempting to install <Patch 12794417> - ORACLE APPLICATIONS RELEASE 12.1: CPU PATCH FOR OCT 2011. The following error occurs:

INSERT INTO FND_MIME_TYPES ( mime_type_id, mime_type, ctx_format_code,
last_update_date, last_updated_by,creation_date, created_by,
last_update_login,file_ext, allow_file_upload ) VALUES (
fnd_mime_types_s.NEXTVAL, 'application/zip', 'IGNORE', sysdate, -1,
sysdate,-1, -1, 'zip', 'N')

AD Worker error:
The following ORACLE error:

Error Codes
ORA-00001: unique constraint (APPLSYS.FND_MIME_TYPES_U2) violated


Upgraded to R12


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