Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00001: unique constraint (APEX_240100.REGION_COL_NAME_UK) violated

Null_Jan 29 2025

Hi,

I am having a hard time to troubleshoot the following issue when installing an APEX application after a code merge. We are using git and maintain the application source code using the apex export -split functionality from sqlcl.

The unique constrain according to what I can see in the DB is for the table: WWV_FLOW_REGION_COLUMNS.

I am not able to query the table since it is an internal apex table. So not really sure what to look for.

The constrain is for:

REGION_ID and NAME. I can't have 2 entries on the table above with the same region_id and name.

While the above is obvious, I am not sure what to look for so I can check the source code and find the duplicates.

Any idea?

Comments
Post Details
Added on Jan 29 2025
1 comment
257 views