My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

Applies to:

Oracle Application Express (APEX) - Version 5.1.4 and later
Information in this document applies to any platform.

Goal

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.
 

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.