My Oracle Support Banner

Report Layout Component Import Returns ORA-20001 & ORA-00001: UNIQUE CONSTRAINT VIOLATED (Doc ID 2427093.1)

Last updated on SEPTEMBER 11, 2021

Applies to:

Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Application Express (APEX) - Version 5.1.4 and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.


In production mode, the Administration user interface is disabled for security reasons. All the APEX application deployment is done through the SQL command line.

There is a specific report layout file deployment that needs to be updated in the production APEX application.

The equivalent deployment in the administration user interface is done by:
1) Going into the 'Shared Component' -> 'Report Layout'.
2) Deleting the old layout file and then upload the fresh layout file.
3) The new layout file reference is then passed to the corresponding report query.

Can the above steps be achieved using SQL commands without redeploying the entire application.


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

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