Database Utilities (MOSC)

MOSC Banner

ORA-00001: Unique constraint violated when using APEX Data Load page with MERGE option

in Database Utilities (MOSC) 3 commentsAnswered

Hi everyone,

I created a Data Load page in my APEX application to upload data from excel files. In the Data Load definition, I correctly specified the key column, set the column mappings, aligned the data types with the database, and selected the MERGE option.

When I test the page, the upload works fine for new records. However, for existing records, I’m getting the following error instead of an update:

ORA-00001: unique constraint violated

Has anyone experienced this issue or could help me figure out what might be wrong with the configuration?

Thanks in advance for your help!

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center