Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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

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
67 views